I’m continuing my efforts to import spreadsheets from numbers as numbers files, rather than having numbers export them as excel files, since both methods change the document appearance, and I’m finding it harder to figure out how to restore the things excel format loses.
In the course of this I discovered that when I read in a .numbers file, it loses any frozen header columns it may have had.
Is it worth while filing a bug about this, or would that be a case of we know we never implemented that?
Related comment. It took me about 5 tries to figure out how to refreeze, when more than one row or column was involved, even with the documentation in front of me. E.g. Freezing Rows or Columns as Headers
You need to select the cell just outside the area to be fixed in place, then go to the view menu and click on "Freeze row and columns, without clicking the toggle beside it.
I find that less than obvious. It’s not a style I’ve seen before, nor is it what I understood by “Choose View - Freeze Cells - Freeze Rows and Columns”, particularly when you can deactivate the freezing by clicking the toggle box beside “Freeze Row and Columns”
I note also that there is no “Freeze Cells” menu item with a sub item of “Freeze Rows and Columns” on libre office 25.8.4.2 There’s a “Freeze Cells” in the view menu and a separate “Freeze Rows and Columns”.
The former works for freezing a single row or a single column, but can’t handle multiples.