[Libreoffice-bugs] [Bug 116331] New: XLSX FILEOPEN Reference to an external *.xlsx file’s data ta =?UTF-8?Q?ble=20results=20an=20Error?=:508

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116331

            Bug ID: 116331
           Summary: XLSX FILEOPEN Reference to an external *.xlsx file’s
                    data table results an Error:508
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 140534
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140534&action=edit
Example file with database table

If we create a table in Microsoft Excel and refer to the table’s column in a
function with an external *.xlsx file and open it with LibreOffice Calc, the
reference file link will disappear/transform [1] and the [Column1] named range
will be treated as an external file.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016
2. Insert a table to the A1:A5 range.
2. Fill the A2:A5 cells with some number. Save the file as “Source.xlsx”
3. Open a new spreadsheet and create an Avarage function, which refer to the
[Column1] of [Table1] of the “Source.xlsx” file in the A1 cell.
Here is an example:
       
=Average('C:\Users\teszt_admin\Desktop\ujproba_link\Reference-to-an-external-datatable\Source-with-datatable.xlsx'!Table1[Column1])
4. Save the file as “Target.xlsx”
5. Open the “Target.xlsx” file with LibreOffice Calc. (Click OK to the Error
message)
6. Save the file as “Target_LO.xlsx” and reload the file.

Actual results:
When we open (Import) the “Target.xlsx” file with LibreOffice Calc we got an
Error message: The following external file could not be loaded. Data linked
from this file did not get updated.
file:///C:/Users/teszt_admin/Desktop/ujproba_link/Reference-to-an-external-datatable/Column1.
Open the ‘Links to external files’ window and you will see the Column1 as file
reference. At the function the reference file path will transform from the
original path to [1] and we have an Error:508 code in the A1 cell.
When we save as the “Target.xlsx” file and reload we got two error message
because of the two “file reference”. At the ‘Links to external files’ window
you will see that the Source file name will be “1” and the “Column1” will be
there.

Expected results:
The external file reference should not disappear or transformed to [1] and the
[Column1] reference should not be at the file Links. The problem may be that
the column name and the filename are not separated locally in the function
formula. LibreOffice only takes into consideration that the column name is in a
stapler “[]” just like the file name in the Excel syntax.

Version: 6.0.0.3
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 4; OS: Windows 6.1; UI render: default; 
Locale: hu-HU (hu_HU); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180310/e60c0097/attachment.html>