[Libreoffice-bugs] [Bug 139405] New: FILESAVE XLSX Named range with name S not allowed in Excel is saved to XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210104/79e9401e/attachment.htm>