Public bug reported: libreoffice: Installed: 1:3.5.3-0ubuntu1~lucid1 Candidate: 1:3.5.3-0ubuntu1~lucid1 Version table: *** 1:3.5.3-0ubuntu1~lucid1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main Packages 100 /var/lib/dpkg/status
In LibreOffice Calc 3.5.3-0ubuntu1~lucid1 (PPA) and 3.5.2-6 (Debian sid unstable) there are problems with malformed links to external Excel-sheets. It's a serious problem imho in all 3.5.x-Linux-versions of Calc. Linux-users with any 3.5.x-version can't cooperate at the office with MS Office users if they use links to external Excel-sheets. [also reported there https://bugs.freedesktop.org/show_bug.cgi?id=48463 2012-04-09 05:17 PDT] Make a source.xls and a merged.xls. Type in source.xls [A1]number [A2]A [A3]B [B1]value [B2]11 [B3]22 Type in merged.xls [A1]number [A2]A [A3]B [B1]value [B2]252-2ubuntu1 [B3]45 Make in merged.xls [C1]diff [C2]=B2-'file:///tmp/source.xls'#$sheet1.B2 [C3]=B3-'file:///tmp/source.xls'#$sheet1.B3 The sheet merged.xls shows now in [C2]14 and [C3]23. If you close merged.xls and reopen it, you get a message "… contains links … should they be updated?" and an error. =B3-'file:///tmp/tmp/source.xls/'#$sheet1.B2 The path-name was saved (or reloaded) wrong into [C2] and [C3]. As LO-users will/must cooperate with MSO-users, they can't use LibreOffice 3.5 because the malformed links to external sheets. To let all switch to ods-sheets is not an option "at the office". There is no work-around atm with other formats like xlsx. I tested in 3.4.4 links to other sheets - works fine there (tested with Oneiric). (I heard also about normal behaviour in Debian wheezy testing LibreOffice calc 1:3.4.6-2.) Can we go back to the behaviour of 3.4.x to make/save/reload links to external Excel sheets? ** Affects: calc (Ubuntu) Importance: Undecided Status: New ** Tags: regression -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/995418 Title: LO calc creates malformed links to external Excel-sheets To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/calc/+bug/995418/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs