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
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.