[Libreoffice-bugs] [Bug 112571] New: FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112571
           Summary: FILESAVE XLSX New named range is created every time an
                    Excel made spreadsheet that contains print ranges is
                    saved as XLSX
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 136468
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136468&action=edit
The original file.

A new named range is created every time an XLSX spreadsheet that was created
with Microsoft Excel and contains Print Ranges is saved as XLSX in LibreOffice
Calc.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel 2013.
2. Select a range of cells.
2. Specify the print ranges (print area in Excel terminology) by clicking on
Print Area -> Set Print Area button in the Page Layout tab.
5. Save the file as XLSX.
6. Open the file with LibreOffice Calc.
7. Check the named ranges by clicking on the Sheet -> Named Ranges and
Expressions -> Manage option.
8. Save the file as XLSX and click on File -> Reload.
9. Check again the named ranges by clicking on the Sheet -> Named Ranges and
Expressions -> Manage option.
10. Every time you repeat the 8. step a new named range is created.

Actual results:
A new named range is created every time the spreadsheet is saved as XLSX.

Expected results:
The number of named ranges should stay constant.

-- 
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/20170922/ff266f92/attachment.html>