Add toolbar (enable/disable) commands

[Jack]

Is there a way to add commands to the SpreadSheet toolbar?

I am especially thinking about the enable/disable range button.

In a template/document scenario, one would want:

- to build templates where some cell ranges have to be disabled;

- to make documents based on such templates where disabled ranges (possibly including formulas) cannot be changed.

In case this is an oversight (enable/disable seems to be the only range property that cannot be set via the toolbar), please log a defect for a fix in a future version.

 

[Alex Gyoshev]

Hello Jack,

You can use the following code to add a custom tool to the toolbar:

    toolbar: {
        home: kendo.spreadsheet.ToolBar.fn.options.tools["home"].concat([
            {
                type: "button",
                text: "Foo",
                spriteCssClass: "k-icon k-font-icon k-i-cog",
                click: function(e) {
                    window.alert("custom tool");
                }
            }
        ])
    }

This reuses the currently defined tools in the "Home" toolbar, and adds a custom button, via the Toolbar item configuration.

Regards,
Alex Gyoshev
Telerik

 

 

[TESI]

Hi Alex,

how to do this with Typescript? "ToolBar" object doesn't exist in kendo.spreadsheet namespace...

 

Regards

[Ianko]

Hi,

As this is missing from the TypeScript definitions you can workaround that by casting to any type: 

var spreadsheetNS = <any>kendo.spreadsheet;
var tools = spreadsheetNS.ToolBar.fn.options.tools["home"].concat([
  {
      type: "button",
      text: "Foo",
      spriteCssClass: "k-icon k-font-icon k-i-cog",
      click: (e: any) => {
          console.log(e);
          window.alert("custom tool");
      }
  }
])

$("#sel").kendoSpreadsheet({
  toolbar: {
    home: tools
  }
})

Regards,
Ianko
Progress Telerik

[TESI]

thank you so much!