Neil Evans
Rank: #5718
104Views
2Comments
[Advanced Excel] After Protecting Sheet Formatting Cells To Be Unlocked is Ignored
Question
Forge
Advanced Excel
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


0
0
on 2020-01-23
Copy link to comment
Carmen
Rank: #13978

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

0
0
on 2020-09-17
Copy link to comment
Pedro Marques
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

1
0
on 2020-11-16
Copy link to comment