https://bugs.documentfoundation.org/show_bug.cgi?id=162093
Bug ID: 162093
Summary: Excel keywords [#Data], [#Totals] ... are wrongly
imported
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 195380
--> https://bugs.documentfoundation.org/attachment.cgi?id=195380&action=edit
Source for import
Open attached document. It has on the left side the import of Excel table
"myData". It becomes a database range in LibreOffice. That is correct.
Column K contains the formulas as text as they are used in Excel.
Column I contains =FORMULA(col F) and shows, what LibreOffice has produced in
import.
Columns F:H should show the same data as columns B:D. You will see error
#NAME?.
(If you see a different error, that is likely bug 162087. In that case look at
Tools > Options > Calc > Formula whether the option "Use English function
names" is really off and reload the document.)
The column I has for example {=myData[#headers]}. The lowercase 'headers' show,
that the keyword is not detected.
Reason for the error is, that the import generates a wrong expression. For
LibreOffice it has to be {=myData[[#Headers]]}. Notice the double brackets.
You can use column L to test this: Enter =myData[[#Headers]] in cell L4 and
finish with Ctrl+Shift+Enter to generate a matrix formula.
--
You are receiving this mail because:
You are the assignee for the bug.
