https://bugs.documentfoundation.org/show_bug.cgi?id=170249
Bug ID: 170249
Summary: FILESAVE: XLSX - Handle labels in formulas
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Firstly go to "Tools" > "Options" > "LibreOffice Calc" > "Calculate", here
enable
"Automatically find column and row labels" option
Open the ODP attachment, the cell B2 has the formula "=INDEX('Prices', 1, 3)".
Here 'Prices' is a label of the 2nd row.
When we export the file to XLSX, these labels are exported in formulas without
any change, as a result Excel throws an error when we open the exported XLSX
Lables in formulas are supported in XLS, but they are deprecated in XLSX
Steps to Reproduce:
1. Open the attached ODP file
2. Save it as XLSX
3. Open the resulting file in Excel
Actual Results:
Excel throws an error when opening the file
Expected Results:
Excel opens the file without any problem
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 22; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
