https://bugs.documentfoundation.org/show_bug.cgi?id=148812
Bug ID: 148812
Summary: [FILEOPEN] [FILESAVE] XLS -> XLSX bad translation of
defined names
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: d...@sheetjs.com
Description:
LO can read files with "\x2e" (".") in defined names from an XLS file. When
saving the files to XLSX, those characters are replaced with "\x5f" ("_"). It
may be an issue with the XLS import filter or the XLSX export filter. Since
the test files were generated using LibreOffice save as XLS, the XLS export
filter does not exhibit the issue.
Steps to Reproduce:
Open attachment and save as XLSX, then try opening the file in Excel
Actual Results:
File opens
Expected Results:
Excel reports file is invalid
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The XLS file has the correct defined name:
```js
> require("xlsx").readFile("locrash.xls")?.Workbook?.Names?.map(x => x.Name)
[ '_xlfn.UNICHAR' ]
```
The generated XLSX does not:
```js
> require("xlsx").readFile("locrash.xlsx")?.Workbook?.Names?.map(x => x.Name)
[ '_xlfn_UNICHAR' ]
```
(note that the "." was replaced with "_")
--
You are receiving this mail because:
You are the assignee for the bug.
