https://bugs.documentfoundation.org/show_bug.cgi?id=112567
Bug ID: 112567
Summary: FILESAVE XLSX Rows to Repeat and Columns to Repeat
properties in XLSX files created with Calc are saved
as incorrect Named ranges
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@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Created attachment 136461
--> https://bugs.documentfoundation.org/attachment.cgi?id=136461&action=edit
The file showcasing the bug.
Rows to Repeat and Columns to Repeat properties are stored as named ranges in
XLSX files. When a spreadsheet with both Rows to Repeat and Columns to Repeat
properties is saved as XLSX in Calc, the resulting file loses the Columns to
Repeat and Rows to Repeat property of the document but still retains an
incorrect named range. The following error message appears when the document is
opened in Microsoft Excel 2013:
Removed Records: Named range from /xl/workbook.xml part (Workbook).
Steps to reproduce:
1. Create a new spreadsheet in LibreOffice Calc.
2. Click Format -> Print Ranges -> Edit.
3. Set the value of Rows to Repeat to $1.
4. Set the value of Columns to Repeat to $A.
5. Save the file as XLSX.
6. Open the file both in LibreOffice Calc and Microsoft Excel 2013.
Actual results:
The rows to repeat and columns to repeat property isn't retained in Calc or
Excel and the following error message appears when the document is opened with
Microsoft Excel 2013: Removed Records: Named range from /xl/workbook.xml part
(Workbook).
Expected results:
Both the rows to repeat and columns to repeat properties should be retained and
the spreadsheet should open in Excel without displaying an error message.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
