How to lock cell and row?

I want to implement functionality where user can not insert row or column before column 1 and row 1.Is there any one for doing that?



  • edited August 8

    Hey @priyatama, I assume you are talking about spreadsheet here. You can use the getSelectedItem method to get the current row/column, after that you can use undo() to revert the operation since we can't prevent it before it happens (as far as I know).

    Here is an example with row 1 and column 1 both locked: Please note that this method will only work with a context menu.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion