When I apply "Window -> Freeze" then save a spreadsheet to .xlsx, the file saved is incompatible with MSO 2010. Steps to reproduce: 1. New Calc, click B2, then apply "Window -> Freeze"; 2. Save as .xlsx; 3. Open the .xlsx file with MSO 2010. --> "View -> Freeze Pane" is grayed out. (i.e., LibreOffice produced an xlsx file in which "Freeze Pane" feature is incompatible with MSO). 4. Based on step 3 (within MSO 2010), type "1" in A1 (or do any other editing), then save the file and reopen. --> The sheet tabs are missing. (i.e., we do not see the sheet tabs "sheet1, sheet2...") (This must be caused by the "Freeze Pane" issue, as when you do not do "Window -> Freeze" in step 1, the .xlsx file in step 4 will be OK). Version: 4.4.0.0.beta1 Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e Locale: zh_CN Version: 4.3.5.1 Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889 Win 7 X64 & Ubuntu 14.10 x64.
Created attachment 110386 [details] xlsx file produced in step 2
Created attachment 110387 [details] xlsx file produced in step 4
Created attachment 110388 [details] step 2 screenshot
Created attachment 110389 [details] step 4 screenshot
The related code seems to be in: sc/source/filter/excel/xeview.cxx
I can not confirm with Version: 4.3.6.0.0+ Build ID: 9e57326acebde972df22ea4368b5ce4822d51330 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-11-27_12:21:59 excel2010 I can not confirm with Version: 4.4.0.0.beta1+ Build ID: 0bd7e1cfed956b0cb2dcdfac9d382e044440d119 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2014-11-27_05:31:01 excel2010
I looked at your screenshot and I can confirm screenshot step 2. Setting as NEW I can not reproduce step 4. I can confirm also with LO 4.3.4.1, win7 -> changing version
(In reply to raal from comment #7) Thanks for confirming. For step 4: * Are you doing the changes in MSO 2010? * Are reopening the file with MSO 2010? * My MSO 2010 version: 14.0.7015.1000 32bit.
(In reply to Kevin Suo from comment #8) > (In reply to raal from comment #7) > Thanks for confirming. > > For step 4: > * Are you doing the changes in MSO 2010? > * Are reopening the file with MSO 2010? > * My MSO 2010 version: 14.0.7015.1000 32bit. Yes, mso 2010
** 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 on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
(In reply to QA Administrators from comment #10) Still reproducable with: Version: 5.1.0.1 (x64) Build ID: bcace328aabc4c8c10b56daa87da0a2ee6579b5a Threads 4; Ver: Windows 6.19; Render: GL; Locale: zh-CN (zh_CN)
Seems fixed in Version: 5.3.0.0.alpha0+ Build ID: 9dc3356f1499a2b90078be86ca7470eb2e96aba8 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-07-21_23:52:45 Locale: zh-CN (zh_CN); Calc: group Mark as WORKSFORME.
Tested and I confirm this one is really a duplicate of bug 101042. *** This bug has been marked as a duplicate of bug 101042 ***