Posted 1 August 2022, 6:04 pm ESTHello,
I currently face an issue where I need to be to copy paste a full row that contains some locked cells.
I have provided a minimal example here:
It consists of three columns, where one column is completely locked.
When trying to copy/paste a full row it throws the InvalidOperation error:
The cell you are trying to change is protected and therefore read-only
When only copy/pasting the unlocked cells it works fine.
I tried to hook into the ClipboardPasting listener to be able to set the sheet.options.isProtected to false (and setting it to true in ClipboardPasted again), but it seems the InvalidOperation cancels the event and the ClipboardPasting listener does not get triggered.
The ideal scenario would be to skip the locked cells on pasting, because they are automatically filled based on values in some unlocked cells. (Actually I have already that code in place in the ClipboardPasting listener, but as it is not triggered I am not able to do so).
BTW is there some consulting services that you offer for investigating current painpoints that we face with the framework?
Thanks in advance.