[Libreoffice-bugs] [Bug 112567] 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 bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 2 16:03:50 UTC 2017


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

--- Comment #7 from Gabor Kelemen <kelemeng at ubuntu.com> ---
Created attachment 136701
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136701&action=edit
The previous file saved as xlsx from LO 6.0alpha

The previous file exported from Calc 6.0 alpha.

Open in Calc, then go to Sheet - Named Ranges and Expressions - Manage.
You should see there is a Name _xlnm.Print_Titles and Range
Sheet1!$A:$A;Sheet1!$1:$1 with the Repeat column and Repeat row Range Options
checked. Also Calc highlights the first row and column - so it looks fine.

Open in Excel 2013 - it should say it has invalid content and removes all named
ranges.

-- 
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/20171002/d1fe0bb0/attachment.html>


More information about the Libreoffice-bugs mailing list