Created attachment 136461 [details] 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.
Created attachment 136462 [details] A spreadsheet with the same property, created with Mirosoft Excel.
Created attachment 136463 [details] A screenshot showcasing the error report.
Created attachment 136464 [details] A screenshot showcasing the named range.
I cannot Reproduce Windows 10 Version: 5.4.1.2 (x64) Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527 CPU threads: 8; OS: Windows 6.19; UI render: default; Locale: en-US (en_US); Calc: group Description: I tried it but never seen the error message saying "Removed Records: Named range from /xl/workbook.xml part (Workbook)".
I can't reproduce it either with LO 5.4.1.2 / Windows 7. No error in Excel, and there is an entry with the name Print_Titles
Created attachment 136700 [details] Example file saved from 6.0 alpha Attached ods file should show the symptoms. Open Format - Print Ranges - Edit. You should see it has Rows to Repeat set to $1, Columns to Repeat set to $A. Save this to xlsx and you should get an error from Excel 2013.
Created attachment 136701 [details] 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.
Created attachment 136702 [details] The xlsx file in Calc looks fine.
No repro with LO 5.4.2.2 & 6.0 daily build (2017-09-28_03:27:43, 0fa21336428b286d69684cfbb7b845f123657041). I used the file from comment 6, saved as XLSX and opened in Excel 2013, no error message in either case. Gábor, please specify exact build id you tested with in case of the 6.0 master build, and results both with master build and with a 5.4 release (preferably 5.4.2.2).
We used the 6.0 build f70e0ec6b3c61a7c7caa469949b0ac8016c89854 this is from 09-13, to generate the example files. Retried with f50bf3c5225b49b3c6f77f882e35305e5dc5ccd3 from 10-03 and it still exports a faulty xlsx.
Created attachment 136728 [details] File exported by a current LO6 master build
Created attachment 136729 [details] Original ods from the current LO6 master
Ha, you need to set Hungarian locale (possibly other non-English locales are sufficient as well), it doesn't occur with English (USA). Once I set Hungarian locale, and saved attachment 136729 [details] as XLSX in Calc, it gave an error in Excel.
The difference is in xl\workbook.xml. See the separator being ";" instead of "," in Hungarian. In US English: <definedName function="false" hidden="false" localSheetId="0" name="_xlnm.Print_Titles" vbProcedure="false">Sheet1!$A:$A,Sheet1!$1:$1</definedName> In Hungarian: <definedName function="false" hidden="false" localSheetId="0" name="_xlnm.Print_Titles" vbProcedure="false">Sheet1!$A:$A;Sheet1!$1:$1</definedName>
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/19976f079800ec4c1d0d5d7e226986cb41f834c2%5E%21 tdf#112567 XLSX export: fix broken built-in names It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I exported the original ODS file: https://bugs.documentfoundation.org//attachment.cgi?id=136729 with LibreOffice 6.3 alpha 1+ (Build ID: 37103a3f008c13dee21d55c8da9e6af807b1997c, Branch:master, Time: 2019-05-27_23:46:36, Locale: hu-HU) and the problem still persists. I was also able to replicate a bug from scratch, without using the original ODS. The relevant part of the workbook.xml still looks like this: <definedName function="false" hidden="false" localSheetId="0" name="_xlnm.Print_Titles" vbProcedure="false">Sheet1!$A:$A;Sheet1!$1:$1</definedName> Tested file: https://bugs.documentfoundation.org//attachment.cgi?id=136729 LibreOffice details: Version: 6.3.0.0.alpha1+ (x64) Build ID: 37103a3f008c13dee21d55c8da9e6af807b1997c CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-05-27_23:46:36 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Created attachment 151774 [details] XLSX exported with LO 6.3 alpha (2019-05-27_23:46:36, hu-HU) Here is the XLSX file exported with LibreOffice 6.3 alpha 1+ (Build ID: 37103a3f008c13dee21d55c8da9e6af807b1997c, Branch:master, Time: 2019-05-27_23:46:36, Locale: hu-HU).
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/32a11727a0f709c11685d4200b1db08dac211dec%5E%21 tdf#112567 XLSX export: correct built-in names It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/ac8368767d3c50c46a764987bf0fd783579f3d9f%5E%21 tdf#112567 XLSX export: correct built-in names It will be available in 6.3.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Checked with Version: 6.4.0.0.alpha0+ (x86) Build ID: 5e74085e07bbeb23c7d29fc3c5f6f6d2b7ff97e7 CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-06-10_00:14:28 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded Now attachment #136462 [details] roundtrips correctly (Excel - LO - Excel, Excel - LO - LO does not cause invalid file either), thanks!
@Gábor: thanks for the verification!