Bug 156434 - [EDITING] Freeze Rows and Columns are lost when sheet is moved/copied to another document
Summary: [EDITING] Freeze Rows and Columns are lost when sheet is moved/copied to anot...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
Reported: 2023-07-23 21:22 UTC by LeroyG
Modified: 2023-07-28 20:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description LeroyG 2023-07-23 21:22:24 UTC
As in summary.

Steps to Reproduce:
1. Freeze rows and/or columns in a sheet
2. Move/copy the sheet to another/new document (choose menu Sheet - Move or Copy Sheet, or in the contextual menu for the sheet tab)

Actual Results:
Freeze is lost.

Expected Results:
Freeze remains in place.

Reproducible: Always

User Profile Reset: No

Additional Info:
Freeze remains when the sheet is duplicated or moved/copied to the same document.

Freeze is lost when complete rows/columns (same or all) are selected, copied and pasted (Ctrl+C, Ctrl+V) into a new sheet. That could be debatable because the new sheet could already have frozen rows/columns.

Version: / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 danomois 2023-07-26 22:52:18 UTC
Hi LeroyG,

First I've confirmed this bug so marking it New.

I also searched for duplicates and found plenty of references to bugs around the Freeze rows/columns command but nobody has pointed this out.

It's interesting - to this day excel has a bug such that opening a second window viewing the same spreadsheet disables freeze rows/columns. But that works for calc!

This is different and I know how annoying this issue is so bug for sure.

One last point for any secondary reviewers or developers - the help page for this command (below) is ok but limited. I could not find any reference to what is supposed to happen to freeze rows/columns when duplicating sheets, copying to new sheets, etc.

Version I used was:
Version: (X86_64) / LibreOffice Community
Build ID: 77fca616e0bd79e0b405fd0b3543cf8e94e15df3
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 LeroyG 2023-07-28 17:47:51 UTC
Reproducible with:

Version: (x86)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
Locale: es-AR (es_MX); UI-Language: en-US
Calc: threaded