[Libreoffice-bugs] [Bug 113991] New: Named ranges without sheet reference are exported as corrupted XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113991

            Bug ID: 113991
           Summary: Named ranges without sheet reference are exported as
                    corrupted XLSX
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: filters and storage
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 104839, 109178

Created attachment 137914
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137914&action=edit
Sample ODS

- Define a named range in an empty spreadsheet, and delete the sheet reference
from the range. Eg. $A$1:$A$3 instead of $Sheet1.$A$1:$A$3
- Save as XLSX.
- Open in Excel.

=> In Excel the file opens with repair, and the named range is removed.

Apparently in Excel the ranges have to include the sheet name.

Attaching an ODS sample, and the corrupted XLSX saved from it.
Note how because the range always refers to the current sheet, and the range
A1-A3 (test_range) contains different values on Sheet1 and Sheet2, the result
of SUM(test_range) is different as well.

Not sure what would be the preferre fix... possibly add as many different
ranges as there are sheets?

Observed using 6.0 daily build (2017-11-06_23:18:19,
a5af0fd9f27af42cf2e8571f659cdad6e606215b), 3.3.0 / Windows 7.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=109178
[Bug 109178] [META] Cell names bugs and enhancements
-- 
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/20171122/aec4f15a/attachment.html>