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.

Reply via email to