104
Views
2
Comments
[Advanced Excel] After Protecting Sheet Formatting Cells To Be Unlocked is Ignored
Question
Forge component by Carlos Freitas
69
Published on 27 Aug 2019

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


Rank: #13978

Same problem here, has anyone come up with a solution?

Rank: #486

Hi,

I had the same problem while trying to protect the header of a worksheet.

The workaround used was uploading (as a resource) an excel sheet with the first row locked, and then fill the data in that worksheet, as shown in the oml attached.


Hope this helps,

Pedro

excel.oml