How to freeze columns and rows in multiple sheets

[russelld]

I use Librecalc to make a spreadsheet with multiple sheets, ie 31 sheets for each day of the month.
How can I freeze the top row and left hand columns to all 31 sheets at the same time?
I have tried selecting all the sheets with shift+click on the first and last sheet and applied “View>Freeze Columns and Rows” and only the current sheet gets frozen row and column, the rest of the sheets remain unchanged. I also have tried the shortcut for “Frozen Columns and Rows” i.e “Alt+v, r” and again, only the current sheet has frozen columns and rows, the rest of the sheets are unchanged.
Thanks in advance for your help with this!

Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Debian package version: 4:7.4.7-1+deb12u5
Calc: threaded

[fpy]

@russelld

all 31 sheets

you can iterate on freezeAtPosition()
e.g. BASIC+Calc: How to Freeze Rows and Columns - #2 by mauricio

and would probably make sense to insertNewByName at the same time

[russelld]

fpy, thankyou for the suggestion!