23 days to give it a try before you buy! Download now. The best deals on licenses are coming soon Download now. The best deals on licenses are coming soon

Reset SpreadSheet, JavaScript Programming Example of How to Reset SpreadSheet

JavaScript Programming Example of How to Reset SpreadSheet

Reset your SpreadSheet in one mouse click. See the coding sample showing how you can add the appropriate buttons to the toolbar. Don't hesitate to use this piece of code in your projects.

JS Code

webix.ready(function(){
  webix.ui({
    view:"spreadsheet",
    id:"ss",
    toolbar: "full",
    data:{
      data:[
        [3,2,"Webix"],
        [3,3,"SpreadSheet"] ,
      ]
    },
    subbar:{
      view:"toolbar", css:"webix_ssheet_toolbar", elements:[
        { view:"button", value:"reset to 5x10", width:240, click:function(){
          $$("ss").config.columnCount = 5;
          $$("ss").config.rowCount = 10;
          $$("ss").reset();
        }},
        { view:"button", value:"reset to 10x20", inputWidth:240, click:function(){
          $$("ss").config.columnCount = 10;
          $$("ss").config.rowCount = 20;
          $$("ss").reset();
        }}
      ]
    }
  });
});