hide spreadsheet ribbon and menu

[nax123]

Hi ,

is there a way to only show spreadsheet grid i.e. hide menu and ribbon?

[Silambarasan I]

Hi Rein, 

 

Thank you for using Syncfusion products. 

 

Yes. Your requirement ‘To show only grid section in Spreadsheet’ has been achieved by setting the ‘showRibbon’, ‘allowFormulaBar’ & ‘showPager’ API’s to false.  We have prepared a sample to demonstrate this in JS Playground.  Please refer the following code example. 

 

Sample: https://jsplayground.syncfusion.com/4xqsitns 

 

 

$("#Spreadsheet").ejSpreadsheet({ 

    showRibbon: false, //To hide Ribbon 

    allowFormulaBar: false, //To hide FormulaBar 

    showPager: false, //To hide pager 

    enableContextMenu: false, //To disable context menu 

    //... 

}); 

 

 

Help DOC Links: 

https://help.syncfusion.com/api/js/ejspreadsheet#members:showribbon 

https://help.syncfusion.com/api/js/ejspreadsheet#members:showpager 

https://help.syncfusion.com/api/js/ejspreadsheet#members:allowformulabar 

 

Regards, 

Silambarasan 

[nax123]

Thanks, for some reason I was looking at sheet object and therefore could not find these properties

[Silambarasan I]

Hi Rein, 

 

Thanks for your update. Kindly get back to us if you need any further assistance on this. We will be happy to help you out. 

 

Regards, 

Silambarasan