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)
Undo's the last action
Undo's the freezing action
User Profile Reset: No
Confirm with Version: 126.96.36.199.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
and Version 188.8.131.52.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.
Created attachment 188880 [details]
Google sheets have undo-able freezing actions