https://bugs.documentfoundation.org/show_bug.cgi?id=101691
Bug ID: 101691
Summary: Links to external cells broken
Product: LibreOffice
Version: 5.1.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi
for years I have used a set of calc-sheets with references in formulas to each
other. Syntax: =['file:///C:/path/to/file 2016.ods']Projektplanung!D4
Extras.Options.LibreOffice Calc.Formula.Formel-Einstellungen="Excel A1"
Extras.Options.LibreOffice Calc.Formula.Detailed setup for
computation="Defaults/Vorgaben/First option"
Before upgrading to version 5 of LO this worked fine in all versions I have
been using up to 4.4.7.2. After upgrading to 5.1.5.2 RC behavior was like this:
- after loading a version 4-file without updating formulas the values were OK
- after recomputing formulas (F9) err:507 where displayed all over
- copying an old formula to a new cell: err:507
- playing with Extras.Options.LibreOffice Calc.Formula.Formel Einstellungen
only helped sometimes(!?)
- resetting or deleting the user profile didn't help
- reformating all formulas in all files to a new #$.-format is not an option
really
As this is an important bug to me I have tried with 4 different versions of LO5
with no difference in the result: all were wrong. Version 4.4.7.2 is the last
version which can handle external sheet links correctly.
As I found I am not alone with this bug (see Bug 97185).
btw: I found it very inconveniant that with each new installation of LO an
existing installation was removed without me being asked before. LO accepts
parallel installations of different versions. This is essential in the process
of upgrading to test code quality against features used. What's about an option
flag during installation?
Regards, Eric
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
