https://bugs.freedesktop.org/show_bug.cgi?id=76047
Priority: medium
Bug ID: 76047
Assignee: [email protected]
Summary: FILESAVE: external data links not saved properly
(.ods, .sxc, .xls, .xlsx)
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 95625
--> https://bugs.freedesktop.org/attachment.cgi?id=95625&action=edit
zip archive containing various files demonstrating bug
.ods and .sxc files retain external data links but the "update every [n
seconds]" setting either gets reset or corrupted. .xls and .xlsx files do not
retain external data links.
To reproduce:
1. Create a new document
2. Insert external data of your choice with some low value for the "update
every [n seconds]" setting, to verify that the data is in fact updating every n
seconds.
3. Save as one of the specified file types and close the document.
Then:
Case 1 (.ods, .sxc)
Open the file again and it will retain the link to external data, but will have
corrupted or reset the "update every [n seconds]" setting. Open up the
Edit->Links window, hit modify, and the setting will have changed from n
seconds to some other value. In my tests the results were that with n=10 it
would change to 9,999, and with n=60 it would change to 60,000. So it seems
this value is becoming corrupted somehow.
Case 2 (.xls, .xlsx)
Open the file again and it will not retain the link to external data, at all.
These are the only file types I've tested, and I'm not sure if external data is
only supposed to work with certain formats and not others. Some test files are
included in the attached zip archive.
I also have a .xls file that I have been working with for a while (since 4.1 I
think) that DOES work as expected. I have included a stripped down, but still
working, version of this file in the attached archive.
As another test, I tried converting the working .xls file to a .ods file and it
resets just like a new .ods file does. This is also included in the archive.
I found a related bug
(https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57330) that I will
comment on as well.
--
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
