Disable add/remove rows/columns/sheet in Spreadsheet

[Ryabinin]

Hi!

What is the best way to disable add/remove rows/columns/sheet in Spreadsheet for some user groups?

I know, that I can hide/disable controls for adding/deleting/renaming sheet. Is there more elegant solution?

Also I know, that I can disable individual cells (that prvents remove whole row/column end for last row/column aslo prevent adding another row/column) - so I can disable whole last row and last column (so I need at least one extra empty row). Is there more elegant solution?

[Martin]

Hello, Ryabinin,

You can use the Sheet methods to add/remove rows. To insert/delete/rename a sheet, you can use the Spreadsheet methods. Currently there is no built-in method to disable a row/column, but you can add custom logic to use the Range enable method.

Let me know if you have any further questions.

Regards,
Martin
Progress Telerik

[Ryabinin]

Hello, Martin,

Thank you. I am found insertColumn/insertRow/deleteColumn/deleteRow events - I can use prefentDefault to disable action.

My next question: how to customize context menu (remove: delete entry) on rows and columns?

[Martin]

You can set a custom class for the item with the code below and then use CSS to hide it:

 $("[data-action='delete-column']").addClass("hidden")

.hidden{
    display:none;
}