https://bugs.documentfoundation.org/show_bug.cgi?id=171221
Bug ID: 171221
Summary: FILEOPEN: Named ranges are not imported from older XLS
files
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, in LO the formula in cell R4 of sheet "16 Cars" is
imported as "=RANK(Q4,#NAME?,TRUE())".
Open the XLS file in Excel, and check the formula in cell R4 of sheet "16 Cars"
the formula is "=RANK(Q4,Scores,TRUE)".
LO doesn't import scoped named ranges from older XLS file.
Because of this, when the file is saved to XLSX, Excel throws an error when
opening the resulting file
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 resulting 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.
