Hi,
I am assuming I am setting this up correctly
My requirement is to lock the header row and block users from adding or removing columns.
I have protected the sheet and left the allowInsertColumns and allowDeleteColumns as default(false)
set the other allows to true
used the CellFormat_ApplyToRange to set the locked state to false for row 2 column 1 to end of column/row
in the resulting spreadsheet all rows/columns are still locked
when I unprotect sheet and check protection they are in a locked state.
It seems the locked state of the format is being ignored