Summary: | Links to external data not preserved for XLS | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | manover <davideluca.milani> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WORKSFORME | ||
Severity: | normal | CC: | muthu.subramanian.karunanidhi, serval2412 |
Priority: | medium | ||
Version: | 3.5.4 release | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | BSA | ||
Crash report or crash signature: | Regression By: |
Description
manover
2012-11-20 16:40:12 UTC
On pc Debian x86-64 with 3.6 sources updated 3 days ago, I gave a try to case 1 (since I don't know how case 2 may work). With xls format, after having linked the source, closed the file and opened, the data are present. However, if I change txt file and open xls file again, it doesn't propose to update and keeps the old data. On the contrary, with ods format, when I reopen the file, a popup displays to propose to update the data. If you accept, it works. I've got the same behaviour with master sources updated yesterday. Muthu: one for you? (perhaps it lacks something during export in xls to indicate that the sheet source must be linked, so xls file must be updated) I think my comment here is relevant to this bug: https://bugs.freedesktop.org/show_bug.cgi?id=54533#c2 Cases (1) and (3) in particular would seem to be a duplicate of bug #54533, which in turn is currently suffering from problems (for testing purposes) specified in bug #63407. I will leave it to the QA team to work out which is a duplicate of which and to what extent. Julien I think this can be resolved as a duplicate of one of the bugs I list. The main problem with this report is it contains multiple issues and is not as clear as the other bugs. As Eike Rathke has reported in: https://bugs.freedesktop.org/show_bug.cgi?id=54533#c5 > Insert -> Link to external data is not meant to work with CSV files or files of > types other than spreadsheet or HTML files. In this sense case (1) is invalid or at least a duplicate of enhancement bug 35040. In terms of case (2) this is not clear: > Create a list of simple comma separated numbers in a .xls file, for ex. E1.xls. If the file is in XLS format it is not "comma separated" and vice versa. It may be a reference (as indicated in comment #2) to LO not exporting the link correctly to the XLS format, in which case it is a duplicate of bug 48463. In terms of case (3) the data can be inserted / linked OK and initially re-opening the XLS the data is displayed as expected, but answering "Yes" to the "This file contains links to other files. Should they be updated?" query results in the message "The link could not be updated." I tested this using this basic example: http://www.w3schools.com/html/tryit.asp?filename=tryhtml_tables ... under Ubuntu 10.04 x86_64 running: - v3.3.0.4 OOO330m19 Build: 6 - v4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a As I previously suggested, this would appear to be bug 63407. Summary edited for clarity. I am having a similar/related issue that I have documented here: https://bugs.freedesktop.org/show_bug.cgi?id=76047 (In reply to comment #4) > http://www.w3schools.com/html/tryit.asp?filename=tryhtml_tables The above example was bad as it does not include any tabular elements. Apologies. Under GNU/Linux using: - v4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a - v4.2.6.2 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f - 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 A link to a working example, such as one of these: http://portfolios.morningstar.com/fund/summary?t=VTI http://coinmarketcap.com/currencies/views/all/ ... works as expected for XLS file format. v4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 currently has problems with link insertion (refer bug 49043). I think this report can be RESOLVED as WORKSFORME (unless a related fix can be located). Summary amended for clarity. Following Owen's comments and no additional feedback from reporter, let's put this to WFM. Don't hesitate to reopen this tracker if you still reproduce this. |