[Libreoffice-bugs] [Bug 127300] New: [META] Issues with import/export/display of Excel built-in defined names

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127300
           Summary: [META] Issues with import/export/display of Excel
                    built-in defined names
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 108815, 108897, 109072, 109178

Excel has the following built-in defined names for specific purposes, they all
begin with "_xlnm" in XLSX:
- _xlnm.Print_Area
- _xlnm.Print_Titles
- _xlnm.Criteria
- _xlnm.FilterDatabase
- _xlnm.Extract
- _xlnm.Consolidate_Area
- _xlnm.Database
- _xlnm.Sheet_Title

These are related to print area/title, filter & advanced filter and various
less important stuff. For details see ECMA-376-1 18.2.5. There are somewhat
similar XLS equivalents, not listing those here.

In Calc these tend to show in Manage Names dialog (Sheet -> Named Ranges and
Expressions -> Manage...), but as they have specific purposes, and can be set
in different places, they shouldn't really be listed there.

They also tend to be exported in multiples if a defined range is changed, which
shouldn't happen.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108815
[Bug 108815] [META] Print range/area bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker
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/20190902/a0bbd1cd/attachment.html>