Spreadsheet Column Configuration

[Marc]

Hi,

I'm trying to save a users spreadsheet column configuration so that when they come back to a page the second time, the columns are the same as when they left. I'm using local storage to save twp attributes ( dataSource.options.schema.model.fields, spreadSheet.options.sheets[0].columns). There is only ever 1 sheet.

However - I cannot see any attribute in either of these objects which indicate a column is hidden. Is this something which is available? Or is the hiding done via the css display property?

Thanks,

Marc

 

[Boyan Dimitrov]

Hello Marc,

I am afraid that there is no setting on sheet columns level to indicate whether a specific column should be hidden or not. I assume that you are hiding columns using the Kendo UI SpreadSheet sheet hideColumn method. In this case I would suggest to store the hidden columns indexes somewhere (different key in the localstorage) and hide them programatically when spreadsheet is loaded. 

Regards,
Boyan Dimitrov
Telerik by Progress

[Marc]

Hi Boyan!

Thanks - that is exactly the solution I have already come up with, great minds eh!

Thanks,

Marc