How do I remove the contextual tabs in the spreadsheet?

[Larissa]

Hi,

I would like to customize the spreadsheet for my application. But I can't figure out how.

I would like to remove the contextual tabs, the undo/redo buttons, the toolbar and the formula bar.

But it may be useful to keep the "header" where these "components" are right now.

How can I do that?

Thanks.

[Larissa]

Found a way to "remove" the "header".

 

$("#spreadsheet").kendoSpreadsheet();

    // remove spreadsheet header
    var widget = $('#spreadsheet').data('kendoSpreadsheet');
    widget._view.formulaBar.element[0].style.display = 'none';
    widget._view.tabstrip.element[0].style.display = 'none';

 

Visually is ok. I'm gone to see if it doesn't affects the functionality.

[Patrick | Technical Support Engineer, Senior]

Hi Larissa,

Please take a look at this Telerik Dojo which illustrates how to hide those elements.  

You can hide the toolbar by setting it to false in the widget.
If you wanted to hide the sheetsbar, you can set that to false too.

The Formula Bar involves some custom jQuery, and resizing the spreadsheet.  Here's one way to remove it:

var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var formulaBar = spreadsheet.element.children()[0];
formulaBar.remove();
spreadsheet.resize();

Hopefully, this helps steer you in the right direction.

Regards,
Patrick
Telerik

 

 

[Larissa]

It works great. I didn't found this on the documentation because I was looking in the wrong place.

Thank you so much.

[Patrick | Technical Support Engineer, Senior]

Hello Larrissa,

Glad everything is working great!  

Regards,
Patrick
Telerik