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 -- To UNSUBSCRIBE, email to debian-openoffice-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20120204073724.22330.62770.report...@elmo.enc.com.au