[Libreoffice-bugs] [Bug 112567] New: FILESAVE XLSX Rows to Repeat and Columns to Repeat properties in XLSX files created with Calc are saved as incorrect Named ranges

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: kelemeng at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170922/fcd7d446/attachment.html>