https://bugs.documentfoundation.org/show_bug.cgi?id=162087
Bug ID: 162087
Summary: Database-range keywords are not detected if Calc is
forced to English function names
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 195372
--> https://bugs.documentfoundation.org/attachment.cgi?id=195372&action=edit
Document for experiments
Open attached document.
Goto Tools > Options > Calc > Formula.
Enable option "Use English function names". OK.
Enter the formulas as described on the sheet.
Notice: The formulas produce errors.
Close the document without saving.
Open the document.
Goto Tools > Options > Calc > Formula.
Disable option "Use English function names". OK.
Enter the formulas as described on the sheet.
Notice: The formulas work.
The file has a database-range named "myData" that has the options "Contains
column labels" and "Contains totals row" enable. For such database range you
can use
myData[[#Data]] to address the cell range without label row or totals row
myData[[#Headers]] to address only the label row
myData[[#Totals]] to address only the totals row
myData[[#All]] to address the entire database range
If the option "Use English Function names" is on, the keywords #Data, #Headers,
#Totals and #All are not detected, what you can see on the fact, that they
appear in lower case in you failing cases.
--
You are receiving this mail because:
You are the assignee for the bug.
