Collapsing the Ribbon in the Spreadsheet

[Sarah Smith]

Hi

Is there a way to set the Ribbon on the spreadsheet control so it's collapsed by default?

Thanks

[Silambarasan I]

Hi Damien, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported query and your requirement ‘To enable the ribbon in a collapsed state’ can be achievable by using ‘collapse()’ client-side method from ejRibbon instance in Spreadsheet. Please refer the following code example. 

 

 

<div id="Spreadsheet"></div> 

 

$(function () { 

    $("#Spreadsheet").ejSpreadsheet({ 

        //... 

        loadComplete: "onLoadComplete" 

    }); 

}); 

 

function onLoadComplete(args) { 

    //Collapse ribbon option 

    $("#" + this._id + "_Ribbon").data("ejRibbon").collapse(); 

} 

 

 

Demo sample: 

https://jsfiddle.net/3s1Lgbam/ 

 

Regards, 

Silambarasan 

[Sarah Smith]

Worked a treat! 

Thanks a lot.

[Silambarasan I]

Hi Damien, 

 

Most welcome. Please get back to us if you need any further assistance. We are happy to help you out. 

 

Regards, 

Silambarasan