https://bugs.freedesktop.org/show_bug.cgi?id=76047
--- Comment #3 from Owen Genat <[email protected]> --- Created attachment 105136 --> https://bugs.freedesktop.org/attachment.cgi?id=105136&action=edit ZIP containing ODS, XLS, XLSX created under LOv4162, LOv4262, and LOv4400 TL;DR Summary ------------- Case 1: - Provided files do (mostly) have very high update frequency values. - Change-in-update-frequency behaviour reported (10 sec to 9999 sec and 60 sec to 60,000 sec) may have been related to v4.2.1.1 under which the provided files were created. I cannot confirm this behaviour using the versions indicated below. Case 2: - Saving to XLS is OK however there is strange Import Options dialog behaviour when attempting to edit links. Refer note [1] below. - Saving to XLSX seems to completely break external links. Testing overview ---------------- There appear to be a number of issues highlighted by this bug. Attachment 95628 contains these files: a) coinmarketcap-new-broken.xls b) coinmarketcap-new-broken.xlsx c) coinmarketcap-new-resets-10-9999.ods d) coinmarketcap-new-resets-10-9999.sxc e) coinmarketcap-new-resets-60-60000.ods f) coinmarketcap-new-resets-60-60000.sxc g) coinmarketcap-ods2xls-broken.xls h) coinmarketcap-old-working.xls i) coinmarketcap-old_xls2ods-resets.ods I have initially tested the links in the above files by opening each under these versions: 1) v4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a 2) v4.2.6.2 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f 3) v4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 4) v4.4.0.0.alpha0+ Build ID: e379401618268ed7f7f5885a36b90e1f4f6cd4af TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-08-18_05:51:03 Intial test ----------- Ask to update? Are links updated? Update every N sec? a) 1) N - - 2) N - - 3) N - - 4) N - - b) 1) N - - 2) N - - 3) N - - 4) N - - c) 1) Y Y 99,999 2) Y Y 99,999 3) Y Y 99,999 4) Y Y 99,999 d) 1) Y Y 99,999 2) Y Y 99,999 3) Y Y 99,999 4) Y Y 99,999 e) 1) Y Y 60,000 2) Y Y 60,000 3) Y Y 60,000 4) Y Y 60,000 f) 1) Y Y 60,000 2) Y Y 60,000 3) Y Y 60,000 4) Y Y 60,000 g) 1) N - - 2) N - - 3) N - - 4) N - - h) 1) Y Y 60[1] 2) Y Y 60[1] 3) Y Y 60[1] 4) Y Y 60[1] i) 1) Y Y 99,999[1] 2) Y Y 99,999[1] 3) Y Y 99,999[1] 4) Y Y 99,999[1] [1] Edit > Links... > Modify... displays the Text Import dialog. Clicking Cancel then displays the update time. Summary: - Behaviour for each file appears consistent across versions. - Only new XLS/XLSX lose the ability to prompt for update. - Update frequency for nearly all files that update is set to a very high value. This may be the result of v4.2.1.1 under which the files appear to have been created (refer New File Test below). Fix/Break Test -------------- Using v4.4.0.0 (4) in a simple attempt to try and repair / break some of the provided files: - Open (a). Save as XLS (new name). Close. Reopen. LINKS (STILL) BROKEN. - Open (b). Save as XLSX (new name). Close. Reopen. LINKS (STILL) BROKEN. - Open (c). Save as XLS (new name). Close. Reopen. LINKS BROKEN. - Open (c). Save as XLSX (new name). Close. Reopen. LINKS BROKEN. - Open (e). Save as XLS (new name). Close. Reopen. LINKS BROKEN. - Open (e). Save as XLSX (new name). Close. Reopen. LINKS BROKEN. - Open (g). Save as XLS (new name). Close. Reopen. LINKS (STILL) BROKEN. - Open (g). Save as XLSX (new name). Close. Reopen. LINKS (STILL) BROKEN. - Open (h). Save as XLS (new name). Close. Reopen. OK. - Open (h). Save as XLSX (new name). Close. Reopen. LINKS BROKEN. It appears in simple terms that once the links are broken they cannot be repaired by re-saving in an up-to-date version. Furthermore links in the "old-working" XLS stop working after being saved as XLSX. New File Test ------------- Create a new file using the indicated file formats / versions with: - http://coinmarketcap.com/currencies/views/all/ - Select table HTML__currencies-all - Update frequency of 60 sec ODS: (1) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED. (2) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED. (3) LINK FAIL ON ENTRY. This appears to be bug 49043 again. (4) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED. XLS: (1) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED[1]. (2) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED[1]. (3) N/A see above. (4) Save. Close. Reopen. LINKS UPDATE. FREQ PRESERVED[1]. XLSX: (1) Save. Close. Reopen. LINKS BROKEN. (2) Save. Close. Reopen. LINKS BROKEN. (3) N/A see above. (4) Save. Close. Reopen. LINKS BROKEN. Refer attached for files created from this last series of tests. -- 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
