Bug 40070 - Calc [UI] abnormal after row-freeze & FILESAVE as *.xlsx
Summary: Calc [UI] abnormal after row-freeze & FILESAVE as *.xlsx
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: All All
: high major
Assignee: Not Assigned
Whiteboard: target:4.2.5
Keywords: regression
: 37595 49222 49886 57324 (view as bug list)
Depends on:
Reported: 2011-08-14 00:17 UTC by puhv
Modified: 2014-05-17 15:25 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:

Spreadsheets with frozen row, screenshot of UI (26.23 KB, application/x-zip-compressed)
2011-08-14 00:17 UTC, puhv
test file, broken UI, freeze at B2 cell (5.90 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-18 05:28 UTC, gader
broken UI screenshot (20.07 KB, image/png)
2012-05-18 05:28 UTC, gader
Possibly-simpler test case (open this; SaveAs .xlsx; File->Reload) (8.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-02 20:50 UTC, Jim Avera
This file still displays crazy. (11.77 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-09-02 14:06 UTC, Rubem
screenshot in 4.1 on Fedora (RFR) 64 bit. Row titles on left side of screen are corrupted (147.14 KB, image/png)
2013-09-06 07:07 UTC, sasha.libreoffice

Note You need to log in before you can comment on or make changes to this bug.
Description puhv 2011-08-14 00:17:57 UTC
Created attachment 50191 [details]
Spreadsheets with frozen row, screenshot of UI

After creating a new Spreadsheet in LibreOffice 3.4.2 Calc, freezing the first row (using menu Window -> Freeze), saving the document as *.xlsx, and opening it, the user interface behaves strangely.

Steps to reproduce:

First, extract the contents of the attached "freeze-row.zip" archive.

Then in Calc (in new empty LibO Spreadsheet document), use menu File -> Open (LibO dialog) - file type "Spreadsheets" -> select the extracted "freeze-row-ok.ods" document -> double-click.

The first row in the spreadsheet "Sheet1" is frozen (and "Freeze" is seen as selected under the Window menu).

Now save the document: use menu File -> Save As... (LibO dialog) - choose file type either "Microsoft Excel 2007 XML (*.xlsx)" or "Office Open XML Spreadsheet (*.xlsx)" -> type some filename (e.g. "freeze-bug.xlsx") -> click Save, click "Keep Current Format" (if asked). Close Calc.

(The resulting file is provided as the "freeze-row-bug.xlsx" in the attached archive.)

Now open Calc again and use menu File -> Open (LibO dialog) - file type "All files" -> select the saved "freeze-bug.xlsx" document -> double-click.

As shown in the screenshot (see "freeze-row-bug-screenshot.png" from the archive), the Window menu will now indicate that "Split" is active (instead of "Freeze"). Moreover, column name labels ("A", "B", "C") have some gaps in them. Clicking on any cell causes the labels to appear, disappear or overlap with the topmost dispayed row.
Comment 1 Jeffrey 2011-08-20 20:45:16 UTC
Confirmed for LibreOffice 3.4  340m1(Build:103) on OpenSuse Linux. Followed steps exactly, bug occurred. Thanks for document and steps.
Comment 2 Kris Lou 2011-08-31 12:17:17 UTC
Confirmed for 3.4.3 in Windows.

Also, when saved to *.xls and reopened, the frozen row is duplicated upon the initial display.  Subsequent scrolling eliminates this and it works as intended.

Saving to *.ods works as intended.
Comment 3 sasha.libreoffice 2012-04-11 05:49:07 UTC
Reproduced in 3.5.2 on Fedora 64 bit
I placed cursor into cell B1 and freezed, than saved as ods and xlsx
Calc opens produced xlsx and looks strange. msOffice 2007 opens this xlsx and numbers of rows on left of screen disabled, nothing freezed. So, problem in FILESAVE to xlsx.

PS: msOffice 2007 opens mentioned above ods without freeze. And xlsx produced by msOffice 2007 Calc opens correctly.
Comment 4 gader 2012-05-18 05:16:33 UTC
*** Bug 49222 has been marked as a duplicate of this bug. ***
Comment 5 gader 2012-05-18 05:16:52 UTC
*** Bug 49886 has been marked as a duplicate of this bug. ***
Comment 6 gader 2012-05-18 05:28:15 UTC
Created attachment 61798 [details]
test file, broken UI, freeze at B2 cell
Comment 7 gader 2012-05-18 05:28:52 UTC
Created attachment 61799 [details]
broken UI screenshot
Comment 8 gader 2012-05-18 05:29:17 UTC
I can confirm that on 3.2.2-3.5.3
test-xlsx-lo.xlsx - test file, broken UI, freeze at B2 cell.
test-xlsx-lo.png  - broken UI screenshot.
Comment 9 Esteban 2012-05-18 07:07:20 UTC
Confirmed with both LibreOffice (Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80) and 3.5.2.x (Build ID unknown) while using Windows 7 Home Premium, 64-bit, Service Pack 1. I initially reported it as Bug 49886, which has now been marked as a duplicate.
Comment 10 sasha.libreoffice 2012-09-06 10:05:34 UTC
*** Bug 37595 has been marked as a duplicate of this bug. ***
Comment 11 Jim Avera 2012-10-02 20:48:50 UTC
Also confirmed in rc on Win7.

I am also attaching another test case which may be simpler to use:
  1.  Open the attached test.ods
  2.  File->SaveAs .xlsx
  3.  File->Reload (screen is then corrupted)
Comment 12 Jim Avera 2012-10-02 20:50:23 UTC
Created attachment 68008 [details]
Possibly-simpler test case (open this; SaveAs .xlsx; File->Reload)
Comment 13 DB 2013-01-17 14:41:45 UTC
Every version of LibreOffice I've used loses Freeze settings in both .xls and .xlsx files. I've tried every new release to see if this is fixed. This is the single most annoying feature of LO. It's almost guaranteed to fail with large files, indicating that the data structures storing this information are lost in the save process. 

A related problem is cell format codes (cell types) appear to get lost. I use LIBXL to read the .xls files, and it fails to identify the correct cell type. It could be LIBXL; however, if I cut & paste like cells and reenter the information in the LO spreadsheet, that fixes the problem. 

These problems are random. LO and Excel will read the files and work fine, except for the setting being lost. Because it's random, I have found no way to provide a test case that reproduces the problems.
Comment 14 Fa 2013-05-08 08:03:53 UTC
Confirmed also in on WinXP-SP3; "freeze" change in "split" after saving a sheet as xlsx, with strange effects on the row/column headers.

Comment 15 ign_christian 2013-08-07 02:47:19 UTC
Following this bug description; open the attached ods, saving as xlsx, then close & reopen that xlsx. I can't reproduce that on LO (Win7 32bit), perhaps it's been fixed regarding Bug 49120.

Please REOPENED if that still happen on latest stable release & after resetting user profile.
Comment 16 ign_christian 2013-08-07 03:03:31 UTC
*** Bug 57324 has been marked as a duplicate of this bug. ***
Comment 17 sasha.libreoffice 2013-08-07 06:20:57 UTC
And Excel 2010 opens produced xlsx document freezed correctly.
So, this side of problem also solved.
Comment 18 Rubem 2013-09-02 14:06:02 UTC
Created attachment 85062 [details]
This file still displays crazy.
Comment 19 ign_christian 2013-09-03 09:20:18 UTC
Hi Rubem, feel free to REOPENED this bug if you could reproduce same problem with latest LO release ( or & after you do reset user profile.
Comment 20 sasha.libreoffice 2013-09-06 07:07:11 UTC
Created attachment 85308 [details]
screenshot in 4.1 on Fedora (RFR) 64 bit. Row titles on left side of screen are corrupted
Comment 21 sasha.libreoffice 2013-09-06 07:09:04 UTC
Thanks for attachment.
Reproduced problem in LO 4.1.1 on WinXP 32 bit and Fedora 64 bit
Comment 22 ign_christian 2013-09-06 07:27:31 UTC
Perhaps we should raise importance because of the regression
Comment 23 Bernhard 2013-09-20 07:22:17 UTC
reproduced on Version (Build ID: 400m0(Build:2)) Ubuntu 13.04 (raring)
Comment 24 Kohei Yoshida 2014-05-17 15:25:34 UTC
Just tested this with 4.2.5 and it is no longer reproducible.