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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
