[Libreoffice-bugs] [Bug 113596] New: Default name of XLSX print ranges is displayed as _xlnm.Print_Area

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113596
           Summary: Default name of XLSX print ranges is displayed as
                    _xlnm.Print_Area
           Product: LibreOffice
           Version: 5.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: topicUI
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 137458
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137458&action=edit
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.

-- 
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/20171102/cc2fde5f/attachment.html>