Bug 127300 (Excel-Default-Names)

Summary: [META] Issues with import/export/display of Excel built-in defined names
Product: LibreOffice Reporter: Aron Budea <aron.budea>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: oliver.brinzing, thomas.lendo
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on: 113596, 118592, 100034, 109240, 112567, 112571, 115159, 127301, 154449    
Bug Blocks: 108815, 108897, 109072, 109178    

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.