How to Delete undo and redo buttons from the spreadsheet

[Saifulla]

I want to delete the controls(buttons like undo, redo, save,etc..) from the spreadsheet and want to add my own controls like textbox and some custom buttons. can some one suggest me how can I achieve this, I am using telerik for the first time.

Thank You.

[Veselin Tsvetanov]

Hello Saifulla,

You could define which buttons to be displayed on the Spreadsheet Home tab by configuring the toolbar.home option of the widget. As per the Undo and Redo buttons, which could not be removed by configuration, you could use the following CSS rules:

.k-spreadsheet .k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
  display: none;
}

.k-tabstrip-top.k-spreadsheet-tabstrip .k-tabstrip-items {
  padding-left: 5px !important;
}

Here you could find a small Dojo sample implementing the above.

As per adding your own controls to the Spreadsheet toolbar, here is how that could be done. Basically you will need to add a custom Tool to the list of tools.

Regards,
Veselin Tsvetanov
Progress Telerik

[Saifulla]

Thanks for the answer sir, one more question actually i am creating my own custom buttons , and adding some java script functions. On clicking the button i want to call those functions. Is it possible?

 

[Veselin Tsvetanov]

Hello Saifulla,

Yes, the following Dojo demonstrates how to attach a click handler to a custom Spreadsheet toolbar button:

$("#spreadsheet").kendoSpreadsheet({
  toolbar: {
    home: [
      ["bold", "italic"],
      "format",
      {
        type: "button",
        text: "Custom",
        spriteCssClass: "k-icon k-font-icon k-i-cog",
        click: function() {
          window.alert("custom tool");
        }
      }
    ]
  }
});

Regards,
Veselin Tsvetanov
Progress Telerik

[Saifulla]

Thanks for the replay sir, one last question I am trying to create a dynamic html table generator. For that i need all cells to be deleted so i can create dynamic table based on user input. How can i do this??

 

Thanks a lot sir.

[Veselin Tsvetanov]

Hi Saifulla,

I am not quite sure that I fully understand what exactly is the required scenario. If you would like to create a Spreadsheet with no cells initially loaded on the page and dynamically define the number of rows and columns, that would not possible. You will need to initialize a new widget with the proper rows and columns options set.

If the above is not the case in question, I would like to ask you to explain a bit in detail what would you like to achieve.

Regards,
Veselin Tsvetanov
Progress Telerik