Description: Calculating with column labels in XLSX documents created with LibreOffice Calc 6.3.0.0.alpha0+ doesn’t work when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+. Steps to Reproduce: 1. Turn on Options – Calc – Calculate – Automatically find column and row labels. 2. Open the attached ODS file in LibreOffice Calc. It contains a column label (that can be automatically found) in A1 and a formula =SUM('numbers') in A10. 3. Open the attached XLSX file in LibreOffice Calc. It was saved from the ODS file. 4. Type a value in the A8 cell in each document. 5. Compare the A10 cells in ODS and XLSX file. 6. View the attached screenshot. 7. Notice, that in XLSX file the value of A10 cell doesn’t change. 8. Opening the XLSX file in Excel gives “Part of this file is corrupted, should we try to restore” error. Actual Results: Calculating with column labels doesn’t work when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+. Expected Results: Calculating with column labels doesn’t work should work the same way as the ODS file when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.3.0.0.alpha0+ Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded Verzió: 5.0.0.5 Build az.: 1b1a90865e348b492231e1c451437d7a15bb262b Területi beállítások: hu-HU (hu_HU) Verzió: 4.2.0.4 Build az.: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Verzió: 4.1.0.4 Build az.: 89ea49ddacd9aa532507cbf852f2bb22b1ace28 But not with: Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)
Created attachment 150121 [details] Example file from LO 6.3 master
Created attachment 150122 [details] The example file saved as xlsx by LO 6.3 master
Created attachment 150123 [details] The example file saved by LO 4.0. Works in LO, but not in Excel 2013.
Created attachment 150124 [details] Screenshot of the problem
If I'm not wrong `labels`are not compatible with xlsx format and excel. For compatibility with excel there was added Table structured references. https://wiki.documentfoundation.org/ReleaseNotes/5.1#Table_structured_references
You may be right, thanks. I think our Label range (See Workbook - Named Ranges and Expressions - Labels) feature was inspired by a similar older Excel feature that is no longer present (at least on my 2013). Probably this one evolved into the "Insert - Tables" feature of Excel. This tutorial explains it with Excel 2003 (or XP?): https://www.youtube.com/watch?v=GX6OBfXuSGQ I'd like to dig after the history of this one.
Created attachment 150140 [details] Another example file saved as XLS Apparently we can write custom made label ranges to XLS format.
Created attachment 150141 [details] Opening the example XLS file in Excel 2007 However opening it in Excel 2007 it tells us the feature is no longer supported and label ranges will be converted to cell references.