Posted 23 January 2025, 5:26 am EST - Updated 23 January 2025, 5:33 am EST
Hi. I am using SpreadJS 14 with the Designer Component.
I have a protected sheet with protected cells on it.
On the Protect Sheet dialog I have unchecked the “Selected locked cells” option such that you should not be able to put focus on protected cells.
Mostly this works ok, but I have found that if you type the cell coordinates into the cell-name/reference input field (to the far left of the formula input field) then you can use this to force the focus onto a protected cell.
This matters because I will be a posting a separate issue with a backdoor I’ve found to allow a user to very easily unlock a locked cell once it has focus.
Thanks.
Mark