Bug 156434

Summary:	[EDITING] Freeze Rows and Columns are lost when sheet is moved/copied to another document
Product:	LibreOffice	Reporter:	LeroyG <iavs.leroy>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	buzea.bogdan
Priority:	medium
Version:	6.4.7.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	109182

Description LeroyG 2023-07-23 21:22:24 UTC

Description:
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: 7.4.3.2 / 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.
https://help.libreoffice.org/latest/en-US/text/scalc/guide/line_fix.html?&DbPAR=SHARED&System=UNIX

Version I used was:
Version: 24.2.0.0.alpha0+ (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: 6.4.7.2 (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

Comment 3 LeroyG 2024-06-05 13:34:48 UTC


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