Bug 49886 - FORMATTING: XLSX Window Freezing Bug. Does not save.
Summary: FORMATTING: XLSX Window Freezing Bug. Does not save.
Status: RESOLVED DUPLICATE of bug 40070
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-13 15:06 UTC by Esteban
Modified: 2012-05-18 06:56 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
RAR of the test files I used. (15.35 KB, application/rar)
2012-05-13 15:06 UTC, Esteban
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Esteban 2012-05-13 15:06:06 UTC
Created attachment 61588 [details]
RAR of the test files I used.

Problem description: XLSX Window Freezing Bug. A Frozen row cannot be saved. When opened, it opens as Split with GUI problems. Removing the Split is the only way to correct the GUI.

Steps to test:
1) I created new documents in the ODS, XLSX, and XLS formats.  This was done by selecting File->Spreadsheet. Sample data was entered and the top row was frozen by selecting Window->Freeze. I saved copies of each file type with the top row frozen.

2) The ODS file opens correctly with the top row frozen. It can be closed, open, and still remains frozen. I then editted the file content, saved it, closed it, and opened again. The top row remains frozen and the last view state was saved (selected cell and rows in the view).

3) The XLS file opens correctly with the top row frozen. It can be closed, open, and still remains frozen. I then editted the file content, saved it, closed it, and opened again. The top row remains frozen and the last view state was saved (selected cell and rows in the view).

4) The XLSX file does NOT open correctly. The top row and header (containing letters) GUI is intermixed. Vertical scroll doesn't help in correcting it. The Frozen check box no longer exists in the Window menu, rather, the Split check box is selected.  When unchecked, the GUI returned to a normal state after the vertical scroll make it to the top.

5) Resaving the XLSX file with the top row frozen again does not correct the problem. It repeats the problem.


Steps to test:
1) Perform step 1 above (for XLSX) and then steps 4 and 5.


Current behavior:
XLSX files cannot retain a frozen row. XLS and ODS files can retain a frozen row.

Expected behavior:
Frozen rows to be saved and existent upon next open without any bugs.

Platform (if different from the browser): 
Windows 7 Home Premium, 64-bit, Service Pack 1

LibreOffice Specs:
LibreOffice 3.5.3.2 
Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80

This problem exited with my previous 3.5.2 version as well.
Comment 1 gader 2012-05-18 05:16:52 UTC

*** This bug has been marked as a duplicate of bug 40070 ***
Comment 2 Esteban 2012-05-18 06:56:46 UTC
Goodness. I am glad you found this original bug listing. However, it's boggles my mind that this bug has been known for over a year! Ouch!