Bug 170452 - FILESAVE: XLS -> XLSX external references in Data Validation are not exported in workbook.xml
Summary: FILESAVE: XLS -> XLSX external references in Data Validation are not exported...
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.8.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Karthik
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-01-23 13:04 UTC by Karthik
Modified: 2026-01-23 13:05 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
XLS File (35.00 KB, application/vnd.ms-excel)
2026-01-23 13:05 UTC, Karthik 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Karthik 2026-01-23 13:04:29 UTC 
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
Comment 1 Karthik 2026-01-23 13:05:39 UTC 
Created attachment 205152 [details]
XLS File