https://bugs.freedesktop.org/show_bug.cgi?id=76709
Priority: medium
Bug ID: 76709
Assignee: [email protected]
Summary: Err:520 when using external link in ods format
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96487
--> https://bugs.freedesktop.org/attachment.cgi?id=96487&action=edit
sample monthly file with all irrelevant pages cleared
Multi-page spreadsheets. Reference in one spreadsheet to a page and cell in an
external (closed) spreadsheet fails in one cell with "Err:520" shown. Other
cells with similar references work.
If other cells are changed to refer to the target page/cell in the external
file they work.
If the failing cell is COPIED to another cell and adjusted to refer to the
correct page there, it will initially work but later fail.
If the cell is changed, file saved, then edited to refer to the correct
external page/cell again, the correct value will appear but will again fail
after the external links are refreshed either manually (Edit-Links-Update) or
by save/close and reopen with external links updated.
If the target spreadsheet is open, all links work.
** If the name of the source spreadsheet (where the failing cell is located) is
changed so that the name includes more than just the month and year (say,
MAR2014.ODS change to MAR2014C.ODS) all links work.
Dependency seems to exist between the name of the open file and behavior of one
cell in the file?
File setup is, in an annual directory:
Month files: JAN2014.ODS, FEB2014.ODS, MAR2014.ODS ...
Stock records file: STOCKS14.ODS
Failure first noted in 4.2.1.1 release; 4.2.2.1 not tested
Failure also occurs in LO 4.1.5.3 release (currently in use)
Not been tested in 4.0
Worked correctly in 3.6.5.2 release
Attachment is the first of 2 files. Will add the external link file afterward.
The failure is in the monthly file, in the cell referring to the external
stocks file for the number of shares for IBM. CVX reference always works
correctly.
Note: the sample files don't appear to have the problem. No idea why. But they
do contain the linkage examples that have the problem.
Workaround: will be changing filenames and/or directory names, but that's a lot
of editing ... or building batch files to always open both the monthly and the
stocks file for every editing session.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
