Bug 127300 (Excel-Default-Names) - [META] Issues with import/export/display of Excel built-in defined names
Summary: [META] Issues with import/export/display of Excel built-in defined names
Status: NEW
Alias: Excel-Default-Names
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on: 113596 118592 100034 109240 112567 112571 115159 127301 154449
Blocks: Print-Range XLSX XLS Cell-Name
  Show dependency treegraph
Reported: 2019-09-02 23:16 UTC by Aron Budea
Modified: 2023-04-04 15:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2019-09-02 23:16:31 UTC
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.