https://bugs.freedesktop.org/show_bug.cgi?id=57330
Priority: medium
Bug ID: 57330
Assignee: [email protected]
Summary: : Link to external data does not work
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.5.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
no way to link external data to .xls file in Calc and keep it updated.
Neither (1)linking .txt,.csv file format via the Insert -> Sheet from file ->
Link,(2)nor with "Paste as link" with .xls external file format, (3) nor with
.html external file format via "Link to external data" in Insert menu.
Case (1)
Steps to reproduce:
1. Create a list of simple comma separated numbers in a .txt, .csv file,
for ex. E1.txt.
2. Open a new spreadsheet in Calc, .xls format (for ex. NEW.xls), and try
to link data from external source to this file using Insert -> Sheet from file
-> Link from external sheet to the new sheet.
3. Now save and close the files.
4. Open the "new" sheet.
Expected behavior:
NEW.xls open and linked data are shown correctly.
Current behavior:
No data update in NEW.xls is done.
Case (2)
Steps to reproduce:
1. Create a list of simple comma separated numbers in a .xls file, for
ex. E1.xls.
2. Open a new spreadsheet in Calc, .xls format (for ex. NEW.xls), and try
to link data from external source to this file using "Paste special" and "Link"
from external sheet to the new sheet.
3. Now save and close the files.
4. Open the "new" sheet.
Expected behavior:
NEW.xls open and linked data are shown correctly.
Current behavior:
At file opening an error message will pop up: "
---- reported error window ----
The following external file could not be loaded. Data linked from this
file did not get updated.
file:///home/xxx/E1.txt
---- end error window ----
Looking into the linked cell it paste twice the file path: i.e.
file:///home/xxx/home/xxx/E1.txt
Case (3)
Steps to reproduce:
1. Create a .html file with a table of simple numbers. Called for or ex.
E1.html.
2. Open a new spreadsheet in Calc, .xls format (for ex. NEW.xls), and try
to link data from external source to this file using "Insert" -> "Link to
external data".
3. Now save and close the files.
4. Open the "new" sheet.
Expected behavior:
NEW.xls open and linked data are shown correctly.
Current behavior:
At file opening all linked values are gone and replaced by "The link cannot be
updated"
Looking into the reference link file path is pasted twice.
Platform (if different from the browser):
Browser: Firefox 16.0.2
Ubuntu; Linux 12.04.1 LTS (kernel: 3.2.0-33-generic #52-Ubuntu SMP Thu Oct 18
16:19:45 UTC 2012 i686 i686 i386 GNU/Linux)
Calc 3.5.4.2 Numero di build: 350m1(Build:2)
--
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
