Disable the new spreadsheet button

Question

Is there a way to disable the new spreadsheet button? I haven't found it in the options.

I then tried to use the actionBegin event and cancel it, but the result is that the sheet is still created and the layout of the sheet names gets corrupted, due to a new sheet with no name.

function ejSpreadsheet_actionBegin(args) {

if (args.isNewSheet) {

args.cancel = true;

}

Can this be done?

Thank you

Sangeetha Priya Murugan · Accepted Answer

Hi ShareValue, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported requirement and it can be achievable in our Spreadsheet, by setting the allowInsert property as false as like below. 
 
Code example: 




 
  $(function () { 
            $("#Spreadsheet").ejSpreadsheet({      
              allowInsert:false,                      
        } 
 
 
Sample Link: https://jsplayground.syncfusion.com/0j23qrpj 
 
API Link: https://help.syncfusion.com/api/js/ejspreadsheet#members:allowinsert 
 
Please check the above sample and get back to us if you need further assistance. 
 
Regards, 
Sangeetha M

ShareValue · Answer

It was right in front of me, and I didn't see it.Thank you

Sangeetha Priya Murugan · Answer

Hi ShareValue 
 
Thank you for your update. 
 
We are happy to hear you. Please feel free to contact us, if you need any further assistance on this. 
  
Regards, 
Sangeetha M