https://bugs.documentfoundation.org/show_bug.cgi?id=147522
Bug ID: 147522
Summary: Table-based totalization formulas convert to
lower-case cell references, while the cells they
reference stay in title case (correctly), causing
totalizations to fail with Err:508 and Err:507
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 178385
--> https://bugs.documentfoundation.org/attachment.cgi?id=178385&action=edit
Spreadsheet generated by me that contains a table with totalization formulas
referencing cells and cell ranges within the same table
When opening a report I generated for Excel in Calc, table-based totalization
formulas get converted to lower-case cell references, while the cells they
reference stay in title case (correctly), causing totalizations to fail.
See attached report.
When this same spreadsheet opens in Excel, that conversion does not happen. The
formulas are generated with matching capital case. If adjusted in the copy Calc
creates, the error resolves and totalizations are calculated.
Calc should not be lower-casing these cell references.
--
You are receiving this mail because:
You are the assignee for the bug.
