Bug 49222 - Spreadsheet with "Freeze Top Row" Opened and Saved in LibreOffice Loses Freeze
Summary: Spreadsheet with "Freeze Top Row" Opened and Saved in LibreOffice Loses Freeze
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: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-27 06:13 UTC by Eric Olsen
Modified: 2012-05-18 05:16 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Original Excel-created Spreadsheet with Frozen Top Row (9.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-04-27 06:13 UTC, Eric Olsen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eric Olsen 2012-04-27 06:13:26 UTC
Created attachment 60666 [details]
Original Excel-created Spreadsheet with Frozen Top Row

Simple spreadsheet created with Excel -- has top row frozen.  The pane XML from sheet1.xml is:

  <pane ySplit="1" topLeftCell="A2" activePane="bottomLeft" state="frozen"/>

Opened with LibreOffice 3.5.2.2, freeze is there.  Did no edits, just Save As with new filename, closed, and reopened with LO, freeze is gone.  Pane XML from LO-saved sheet1.xml is:

  <pane activePane="bottomLeft" topLeftCell="A2" xSplit="0" ySplit="1"/>

Frozen attribute is gone.

To replicate with attachment (frozen.xlsx):

1 - Open with LO; verify top row is frozen.
2 - Save As to new filename.
3 - Close LO.
4 - Open new file with LO.

--> top row no longer frozen
Comment 1 gader 2012-05-18 05:16:33 UTC

*** This bug has been marked as a duplicate of bug 40070 ***