Description: Freezing a cell doesn't get into the action stack. Steps to Reproduce: 1. Select some cells 2. View > Freeze row 3. Click undo (Ctrl + Z) Actual Results: Undo's the last action Expected Results: Undo's the freezing action Reproducible: Always User Profile Reset: No Additional Info: .
Confirm with Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 244f9cf66bc36f229ccb5712bc8d80166b92266d CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
I'm not sure there is a bug here. There is no real action (to undo), just as in many other cases such as: * Resize window * Split window * Print preview * scroll (up/down, right/left) * View grid lines Most (if not all) items related to View and/or Window (and some others too) do not add a new "action" that could later-on be undone. Are there other spreadsheet tools that behave differently?
Freezing action is a "real action" because it's saved to the .ods file. Resizing window, zooming in, or zooming out are not saved because they're only relevant for the current session, unlike freezing rows/cols.
(In reply to AvidSeeker from comment #3) > Freezing action is a "real action" because it's saved to the .ods file. > Resizing window, zooming in, or zooming out are not saved because they're > only relevant for the current session, unlike freezing rows/cols. The cell/position, visible "home" cell/position, zoom factor, view grid and many other settings are saved in the file but do not add any item to the (potentially) "undo" list. Let's not get off-topic. We should leave this request for developer's evaluation. In the meantime, my question from comment 2 is still relevant: Are there other spreadsheet tools that behave differently?
(In reply to ady from comment #4) > Most items related to View...do not add a new action Yes I agree. What I'm saying that freezing a row or a column is not *completely* related to views. It has a semantic meaning and change to the spreadsheet. When a column is frozen, it is regarded as a "key" column. This is the equivalent of having <h1> in an HTML file. True that <h1> changes the view of the text, but it also has semantic meaning on the actual heading text. This is like saying applying <h1> only changes view, and so it's not a "real action".
> Are there other spreadsheet tools that behave differently? Here's a recording of Google sheets with undo-able freezing actions. https://i.imgur.com/eEWYNdL.mp4
Created attachment 188880 [details] Google sheets have undo-able freezing actions