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
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
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
*** This bug has been marked as a duplicate of bug 117117 ***