Spreadsheet: bug with hideColumn()?

Hi,

When you have several hidden columns and you ask to display one of these columns ($$(“ssheet”).hideColumn(2, false);), other columns are displayed while they were hidden, often the previous columns. Is that normal?

In my application, there are check boxes at the top of the spreadsheet, to show or hide each column. But it’s not working well. For example, if the first three columns are hidden and the user wants to display the fourth column, the first three columns will also be displayed, which is not wanted.

Of course, there is a workaround: each time you display a column, you check the status of the other columns, and hide some columns if needed, but it’s not practical.

Olivier

Hi @olivier

Yes, it’s normal behaviour (if we hide a lot of columns, we show them together).

To achieve the result you need, you can use this workaround:

https://snippet.webix.com/mi2yci2i

And don’t forget to update your checkboxes after column are shown/hidden via Spreadsheet interface.

Thank you Dima!