1.It is easy to hide column or set cells to blank before export sheet with webix.toExcel(“ss1”,options);
but,I don’t know how to do this before export all the sheets when open the dialog.please have a check with this demo https://snippet.webix.com/y7lu2xfm
2.in this demo,you can see i set a cell as a button. then i want to limit user to edit it(by input or paste) how can I do that by a easy way?
By the way, the webixbutton cannot be shown in webix-pro6.3,it is ok before 6.3.
3.in this demo,you can see I hide “add sheet button” and “sheet_arrow”,i wonder if there is a easier way to do this? set {readonly : true} can hide them,but it also make cells non editable that is not what i hope.
hi Dima_S,
I have two sheets named ‘tab 1’ and ‘tab 2’;
before I export all sheets,I want to setRangeValue for ‘tab 2’;
ssheet.getSheetData(“Tab 2”).setRangeValue(“A10:A13”, “12”) cannot work,you can see my demo based on yours.do you have some ideas? thx a lot! https://snippet.webix.com/yws9nk0q