Bug 113596 - Default name of XLSX print ranges is displayed as _xlnm.Print_Area
Summary: Default name of XLSX print ranges is displayed as _xlnm.Print_Area
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.2.2 release
Hardware: All All
: lowest trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print-Range Not-Localizable Excel-Default-Names
  Show dependency treegraph
 
Reported: 2017-11-02 12:19 UTC by Gabor Kelemen (allotropia)
Modified: 2021-01-11 14:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file with an unnamed print range (11.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-11-02 12:19 UTC, Gabor Kelemen (allotropia)
Details
The same file in XLS format (33.00 KB, application/vnd.ms-excel)
2017-11-02 12:19 UTC, Gabor Kelemen (allotropia)
Details
The XLSX file in Excel 2013 (23.04 KB, image/png)
2017-11-02 12:20 UTC, Gabor Kelemen (allotropia)
Details
The XLSX file in LO 5.4.2 (16.05 KB, image/png)
2017-11-02 12:21 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2017-11-02 12:19:15 UTC
Created attachment 137458 [details]
Example file with an unnamed print range

In Excel, create a simple print range, save the file as XLSX.
Note that in the Excel Name Manager it appears with a localized default name, "Nyomtatási_terület" (~Print_range).

Open the file in LO 5.4 and go to the Manage Names dialog.
The name of the range here appears as "_xlnm.Print_Area" - which is somewhat ugly.

If the file is saved as XLS, the default name of the range in LO is "Excel_BuiltIn_Print_Area" - not localized, but more human readable than "_xlnm.Print_Area".

This default name is stored in the XLSX as 
<definedName name="_xlnm.Print_Area" localSheetId="0">Munka1!$A$1:$A$3</definedName>

This doesn't seem to be a fileopen issue, just a display one.
Comment 1 Gabor Kelemen (allotropia) 2017-11-02 12:19:39 UTC
Created attachment 137459 [details]
The same file in XLS format
Comment 2 Gabor Kelemen (allotropia) 2017-11-02 12:20:24 UTC
Created attachment 137460 [details]
The XLSX file in Excel 2013
Comment 3 Gabor Kelemen (allotropia) 2017-11-02 12:21:14 UTC
Created attachment 137461 [details]
The XLSX file in LO 5.4.2

Version: 5.4.2.2
Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU threads: 4; OS: Windows 6.2; UI render: default; 
Locale: hu-HU (hu_HU); Calc: group
Comment 4 Buovjaga 2017-11-11 16:41:59 UTC
Confirmed.

Manage Names = Ctrl-F3

Arch Linux 64-bit, KDE Plasma 5
Version: 6.0.0.0.alpha1+
Build ID: 1aba1955f161cc112dab80b6b3e78ec7761616fc
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on November 10th 2017
Comment 5 Aron Budea 2019-09-02 22:58:45 UTC
I don't think it should appear there at all (similar to other default ranges), Calc has Format -> Print Rages -> a bunch of items, eg. Edit...
Comment 6 Rigel Flynn 2019-09-16 08:49:49 UTC Comment hidden (spam)
Comment 7 tyron woodley 2020-04-25 09:43:18 UTC Comment hidden (spam)
Comment 8 Flipmorgan 2021-01-11 14:15:57 UTC Comment hidden (spam)