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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
