Bug#658569: libreoffice-calc: Will not correctly use cross-file links with xlsx files
Package: libreoffice
Version: 1:3.4.5-2
Severity: normal
This bug first bit me on some spreadsheets I inherited, but I have made
a simple test case. Basically you cannot link one sheet to another, if
they are xls or xlsx files. ods work fine but this is no good if you
get the sheets as-is.
test1.xlsx doesn't have to be xlsx, the fault is in test2 and still
appears if you link from an ods file. Making test2 an ods works fine.
1) Make a new spreadsheet.
2) Put some value into cell A1, I put 42
3) Save the file as a excel xlsx extension, I called mine test1.xlsx
4) Create a new blank spreadsheet
5) switch to test1 and copy the A1 cell
6) Paste this cell in your second spreadsheet, with paste special-> link
At this point the second sheet will have your value "42" and the
function will be
{=DDE("soffice","/home/csmall/Documents/test1.xlsx","Sheet1.A1")}
Note, if you try to edit it the curly braces go away but they come
back after hitting enter
7) Save the second sheet, I called it test2.xlsx, excel format again
8) Close the second sheet
9) Open test2.xlsx
Magic! Your cell now has #NAME?
The function is
=dde("soffice","/home/csmall/Documents/test1.xlsx","Sheet1.A1")
10) Change the dde to DDE
The 42 appears again
You can save and open and it will keep doing this every time.
I don't know why they just cannot save DDE instead of dde.
- Craig
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.1.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages libreoffice depends on:
ii fonts-sil-gentium-basic [ttf-sil-gentium-basic] 1.1-5
ii liblucene2-java 2.9.4+ds1-4
ii libreoffice-base 1:3.4.5-2
ii libreoffice-calc 1:3.4.5-2
ii libreoffice-core 1:3.4.5-2
ii libreoffice-draw 1:3.4.5-2
ii libreoffice-filter-mobiledev 1:3.4.5-2
ii libreoffice-impress 1:3.4.5-2
ii libreoffice-java-common 1:3.4.5-2
ii libreoffice-math 1:3.4.5-2
ii libreoffice-report-builder-bin 1:3.4.5-2
ii libreoffice-writer 1:3.4.5-2
ii ttf-dejavu 2.33-2
ii ttf-sil-gentium-basic 1.1-5
Versions of packages libreoffice recommends:
ii fonts-liberation [ttf-liberation] 1.07.0-2
ii libpaper-utils 1.1.24+nmu1
ii ttf-liberation 1.07.0-2
Versions of packages libreoffice suggests:
ii cups-bsd <none>
ii default-jre [java5-runtime] 1:1.6-46
ii gstreamer0.10-ffmpeg 1:0.10.13-0.2
ii gstreamer0.10-plugins-bad 0.10.22-3
ii gstreamer0.10-plugins-base 0.10.35-1
ii gstreamer0.10-plugins-good 0.10.30-2.1
ii gstreamer0.10-plugins-ugly 0.10.18-3+b1
ii hunspell-en-us [hunspell-dictionary] 20070829-5
ii hyphen-hyphenation-patterns <none>
ii iceweasel 9.0.1-1
ii imagemagick 8:6.6.9.7-5+b2
ii libgl1-mesa-glx [libgl1] 7.11.2-1
ii libldap-2.4-2 2.4.28-1.1
ii libreoffice-filter-binfilter 1:3.4.5-2
ii libreoffice-gnome 1:3.4.5-2
ii libreoffice-help-3.4 <none>
ii libreoffice-l10n-en-gb [libreoffice-l10n-3.4] 1:3.4.5-2
ii libreoffice-officebean <none>
ii libsane 1.0.22-7
ii libxrender1 1:0.9.6-2
ii myspell-dictionary <none>
ii mythes-thesaurus <none>
ii openclipart-libreoffice <none>
ii openjdk-6-jre [java5-runtime] 6b24~pre4-1
ii pstoedit 3.60-1
ii unixodbc 2.2.14p2-5
Versions of packages libreoffice-core depends on:
ii fontconfig 2.8.0-3.1
ii fonts-opensymbol [ttf-opensymbol] 2:2.4.3+LibO3.4.5-2
ii libatk1.0-0 2.2.0-2
ii libc6 2.13-24
ii libcairo2 1.10.2-6.2
ii libcurl3-gnutls 7.24.0-1
ii libdb5.1 5.1.29-1
ii libexpat1 2.0.1-7.2
ii libfontconfig1 2.8.0-3.1
ii libfreetype6 2.4.8-1
ii libgcc1 1:4.6.2-12
ii libgdk-pixbuf2.0-0 2.24.0-2
ii libglib2.0-0 2.30.2-6
ii libgraphite2-2.0.0 1.0.3.real-1
ii libgstreamer-plugins-base0.10-0 0.10.35-1
ii libgstreamer0.10-0 0.10.35-1
ii libgtk2.0-0 2.24.8-3
ii libhunspell-1.3-0 1.3.2-4
ii libhyphen0 2.8.3-1
ii libice6 2:1.0.7-2
ii libicu48 4.8.1.1-3
ii libjpeg8 8d-1
ii libmythes-1.2-0 2:1.2.2-1
ii libneon27-gnutls 0.29.6-1
ii libnspr4-0d 4.8.9-1
ii libnss3-1d 3.13.1.with.ckbi.1.88-1
ii libpango1.0-0 1.29.4-2
ii libpng12-0 1.2.46-4
ii librdf0 1.0.15-1
ii libreoffice-common 1:3.4.5-2
ii libsm6 2:1.2.0-2
ii libssl1.0.0 1.0.0g-1
ii libstdc++6 4.6.2-12
ii libtextcat0 2.2-10
ii libx11-6 2:1.4.4-4
ii libxaw7 2:1.0.9-3
ii libxext6 2:1.3.0-3
ii libxinerama1 2:1.1.1-3
ii libxml2 2.7.8.dfsg-7
ii libxrandr2 2:1.3.2-2
ii libxrender1 1:0.9.6-2
ii libxslt1.1 1.1.26-8
ii libxt6 1:1.1.1-2
ii ttf-opensymbol 2:2.4.3+LibO3.4.5-2
ii uno-libs3 3.4.5-2
ii ure 3.4.5-2
ii zlib1g 1:1.2.3.4.dfsg-3
Versions of packages libreoffice-writer depends on:
ii libc6 2.13-24
ii libgcc1 1:4.6.2-12
ii libicu48 4.8.1.1-3
ii libreoffice-base-core 1:3.4.5-2
ii libreoffice-core 1:3.4.5-2
ii libstdc++6 4.6.2-12
ii libwpd-0.9-9 0.9.4-1
ii libwpg-0.2-2 0.2.1-1
ii libwps-0.2-2 0.2.4-1
ii libxml2 2.7.8.dfsg-7
ii uno-libs3 3.4.5-2
ii zlib1g 1:1.2.3.4.dfsg-3
Versions of packages libreoffice-writer recommends:
ii default-jre [java5-runtime] 1:1.6-46
ii libreoffice-emailmerge 1:3.4.5-2
ii libreoffice-filter-binfilter 1:3.4.5-2
ii libreoffice-java-common 1:3.4.5-2
ii libreoffice-math 1:3.4.5-2
ii openjdk-6-jre [java5-runtime] 6b24~pre4-1
Versions of packages libreoffice-writer suggests:
pn libreoffice-base 1:3.4.5-2
pn libreoffice-gcj <none>
Versions of packages libreoffice-calc depends on:
ii libc6 2.13-24
ii libcolamd2.7.1 1:3.4.0-2
ii libgcc1 1:4.6.2-12
ii libreoffice-base-core 1:3.4.5-2
ii libreoffice-core 1:3.4.5-2
ii libstdc++6 4.6.2-12
ii lp-solve 5.5.0.13-7
ii uno-libs3 3.4.5-2
Versions of packages libreoffice-base depends on:
ii base-files 6.5
ii default-jre [java5-runtime] 1:1.6-46
ii libc6 2.13-24
ii libgcc1 1:4.6.2-12
ii libhsqldb-java 1.8.0.10-11
ii libreoffice-base-core 1:3.4.5-2
ii libreoffice-core 1:3.4.5-2
ii libreoffice-java-common 1:3.4.5-2
ii libstdc++6 4.6.2-12
ii openjdk-6-jre [java5-runtime] 6b24~pre4-1
ii uno-libs3 3.4.5-2
ii ure 3.4.5-2
Versions of packages libreoffice-base suggests:
ii libmyodbc | odbc-postgresql | libsqliteodbc | tdsodbc | mdbtool <none>
ii libmysql-java | libpg-java | libjtds-java <none>
ii libreoffice-gcj <none>
ii libreoffice-report-builder <none>
ii unixodbc 2.2.14p2-5
Versions of packages libreoffice-impress depends on:
ii libc6 2.13-24
ii libgcc1 1:4.6.2-12
ii libreoffice-core 1:3.4.5-2
ii libreoffice-draw 1:3.4.5-2
ii libstdc++6 4.6.2-12
ii uno-libs3 3.4.5-2
Versions of packages libreoffice-math depends on:
ii fonts-opensymbol [ttf-opensymbol] 2:2.4.3+LibO3.4.5-2
ii libc6 2.13-24
ii libgcc1 1:4.6.2-12
ii libreoffice-core 1:3.4.5-2
ii libstdc++6 4.6.2-12
ii ttf-opensymbol 2:2.4.3+LibO3.4.5-2
ii uno-libs3 3.4.5-2
-- no debconf information
Reply to: