spreadsheet question

Hi, webix team

1. about fomat
   How to set fomat for multi-cell or entire column?
   I have found the related discussion about setFomat.
   https://forum.webix.com/discussion/32774/spreadsheet-format-an-entire-column
   Is this issue have new solution?

2. progressBar cannot be hidden
   I use “webix.extend($$(“spreadsheet”), webix.ProgressBar);”, then I click the import from excel on toolbar. The progressBar will show permanently. How to resolve it?
   https://snippet.webix.com/pu1o20nk

3. Multi-cell selection
   Can spreadsheet use ctrl-click and shift-click to select multiple cells? Like this datatable sample(multiselect:true). https://snippet.webix.com/d95757be

4. show/hide toolbar
   How to implement the show/hide toolbar with menu button(show-toolbar)?
   If I the toolbar is shown, the toolbar will be hiden. If I the toolbar is hiden, the toolbar will be shown.
   https://snippet.webix.com/4xzk1p0v

Looking for your reply, thanks!

Please reply me, thanks!

Hi @Karena

1. This functionality was fixed and now you can set number formats in data and via spreadsheet.setFormat() function .

2. You can attach onBeforeLoad and onAfterLoad events of the spreadsheet’s datatable and use showProgress() and hideProgress() functions: Code Snippet

3. In spreadsheet shift-click feature was already implemented, but it has a little bit another sense - when you make a selection with a shift, so the group of cells are selected. We have in plans to implement ctrl-click feature, but so far I can’t provide a precise time estimate.

4. You can get toolbar object with help of $$("ssheet").queryView({view:"toolbar"}) and use hide() and show() functions.
   Please, check this snippet: Code Snippet