Aspose.Cells GridJs - Disable adding new worksheet

Aspose.Cells Product Family
,
1

Hello,
I am looking for a way to disable the ability to add new worksheets in edit mode.
On the bottom menu bar, there is a plus icon that allows users to add new worksheets.
I would like to disable this icon so that users cannot add additional sheets.
Is there any property available for this purpose, or maybe some workaround to achieve this?

2

@klep

To disable the ability to add new worksheets in Aspose.Cells GridJs, you can use the allowAddSheet property. Setting this property to false will hide the plus icon in the bottom menu bar, preventing users from adding new sheets.

Here’s a simple example of how to implement this:

var grid = new GridJs({
    // other configurations
    allowAddSheet: false
});

Ensure to review the GridJs API documentation for any additional settings that may be relevant to your specific use case. If you require further customization, the API provides various options to tailor the grid’s behavior.

3

This option does not work in my case. There is also no information about it in the documentation Working with GridJs Client Side|Documentation

4

@klep,

Thanks for sharing your requirements.

Aspose.Cells.GridJs does follow MS Excel standards and MS Excel, by default, allows users to add worksheets in the workbook unless you protect the workbook/worksheet. Anyways, we will check if we could support your requirements to disable adding new worksheets in Aspose.Cells.GridJs in normal mode.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-2015

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@klep
Here is a workaround. Please try the following code:

//find the div which contains the button for add worksheet
let bottomDiv=document.getElementsByClassName('x-spreadsheet-bottombar-actions')[0];
//just delete the add button
bottomDiv.removeChild(bottomDiv.firstChild);

we will add this tip to the online document soon.