https://bugs.documentfoundation.org/show_bug.cgi?id=170452
Bug ID: 170452
Summary: FILESAVE: XLS -> XLSX external references in Data
Validation are not exported in workbook.xml
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:
Open the attached XLS file and save it as XLSX, Excel throws an error when
opening the resulting file
In the first sheet, cell E10 has data validation with external reference.
When exported to XLSX, this external reference is properly exported in data
validation but the associated external reference is not exported in
workbook.xml. Because of this, the external reference in data validation has
out of range index.
Steps to Reproduce:
1. Open the attached XLS 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 error
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.