https://bugs.documentfoundation.org/show_bug.cgi?id=139405
Bug ID: 139405
Summary: FILESAVE XLSX Named range with name S not allowed in
Excel is saved to XLSX
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 104839
Created attachment 168667
--> https://bugs.documentfoundation.org/attachment.cgi?id=168667&action=edit
Minimized version of attachment #168418
This is split off from bug #139163
There the ODS attachment #168418 has several named ranges, saving them to XLSX
makes Excel find invalid contents in the named ranges.
The cause seems to be the named range “S” which is not allowed in Excel, can
not even be created as new.
Removing only this one from the Manage names dialog makes the error go away.
Steps to reproduce:
1. Open attached file
2. Save as XLSX, reopen in Excel
3. For a counter-test open attachment #168418
4. In the Manage Names dialog find and delete the named range “S”
5. Save as XLSX, reopen in Excel -> no invalid contents error among named
ranges.
Actual results:
Excel finds invalid contents.
Expected results:
No invalid contents.
LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 96bafa464ebdbce3ef04bec9beae5e745bb37794
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Also with 6.0, 5.0, 4.0. Also happens when saving to XLS format.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
