Created attachment 178385 [details] 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.
The is corrupted also for Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20180) 32-bit
You say you created this in Calc. Can you attach an ODS version? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 184375 [details] ODS export of the XLSX attachment, Calc version 7.4.2.3
Same happens in Calc version 7.4.2.3. ODS export attached, as requested.
Moving status back to unconfirmed, as requested.
The issue is that 'labels' in calc https://help.libreoffice.org/latest/en-US/text/scalc/guide/address_auto.html?DbPAR=CALC#bm_id3148797 are not the same as in Excel the structured references. In P31: =SUBTOTAL(109;Summary[Buy 1]) works for me. Please take a look on https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references
The problem is that after converting from the Excel sheet, in which the references and formulas work, to a Calc sheet, the formulas fail. It means that during the conversion, something went wrong. As Miguel pointed out: Calc can do it when using labels. If that is what is needed to keep the formulas working, then the conversion should have made that happen. The end user (me) should not have to worry about such things. Converting from the most important competition should work flawlessly.
Created attachment 184405 [details] File saved as xlsx You need to save it always a xlsx. ODF doesn't support these formulas, and as I know it is not i Any further development should be reported as 'enhancement'.n development to support them.