https://bugs.documentfoundation.org/show_bug.cgi?id=162369
Bug ID: 162369
Summary: XLSX: Interpret link to Table in external sheet in
structured references
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 195732
--> https://bugs.documentfoundation.org/attachment.cgi?id=195732&action=edit
Example documents for use of Table from external sheet
In Excel it is possible to use a link to a Table in an external sheet in a
structured-reference. You can use e.g. [1]!myData[#All]. (You do not write the
[1] manually, but it is automatically constructed by Excel when you create the
link.)
myData is the name of the Table in the external sheet.
[1] refers to the file externalLinks1.xml in folder externalLinks. The file
externalLinks1.xml contains an element <externalBook r:id="rId1"> (or other rId
number). The accomplishing externalLink1.xml.rels file in the _rels folder on
same level has the path to the external sheet.
I have attached a zip-file which contains such an example.
Excel currently shows the values only if the external sheet is open.
When LibreOffice imports such file it cannot display the data, even if the
external file is opened.
Even if "update external links" is disabled or you open the file read-only, it
does not show the content of the cells, although the <c> elements contain the
value at time of saving.
For ods-files exist same mechanism to use a Database Range from an external
ods-file. In menu Sheet > External File browse to the external file. Then you
can select the Database Range from the external file. Update of the values is
done with menu Edit > Links to external files. However, ods has no means for
structured-references; that is bug 162088.
Request minimum: If "update external links" is disabled or the file is opened
read-only, the cell values as stored in the file should be shown.
Request full: Make LibreOffice able to handle a Table in external file in
structured-references for xlsx-files.
--
You are receiving this mail because:
You are the assignee for the bug.
