This is a migrated thread and some comments may be shown as answers.

Spreadsheet Column Configuration

2 Answers 283 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 20 Jan 2017, 01:21 PM

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

 

2 Answers, 1 is accepted

Sort by
0
Accepted
Boyan Dimitrov
Telerik team
answered on 24 Jan 2017, 07:49 AM

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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Marc
Top achievements
Rank 1
answered on 24 Jan 2017, 07:50 AM

Hi Boyan!

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

Thanks,

Marc

Tags
Spreadsheet
Asked by
Marc
Top achievements
Rank 1
Answers by
Boyan Dimitrov
Telerik team
Marc
Top achievements
Rank 1
Share this question
or