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@lists.freedesktop.org
Reporter: ba...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs