How to adjust width of the columns?

[Michael]

How to increase/decrease width of the columns in the spreadsheet manually?

[Patrick | Technical Support Engineer, Senior]

Hi Michael,

Please take a look at this Kendo UI Dojo by Progress which illustrates how to change the width of the columns in a Kendo Spreadsheet.

The configuration to set is sheets.columns.width.

Hope this helps!

Regards,
Patrick
Telerik by Progress

 

 

[Michael]

Is possible to resize columns width by user on GUI? 

[Patrick | Technical Support Engineer, Senior]

Hi Michael,

You can adjust the columns by dragging the edge of the column header.  You can see this behavior in the following short screencast.  Please try it out in the Kendo UI Dojo by Progress I sent.  

Hopefully this clears things.

Regards,
Patrick
Telerik by Progress

 

 

[Michael]

Thanks it works ! Can you please help me to get spreadsheet columns width to save dynamically by angular.

[Patrick | Technical Support Engineer, Senior]

Hello Michael,

One approach you can take to save the width size of the column is to use the methods toJSON and fromJSON.  toJSON will serialize the workbook based on its configuration while fromJSON will load the contents of the workbook.  Use the localStorage to store the data.

You can see the approach using AngularJS in this Kendo Dojo by Progress.

For more information, we have a great section in our documentation which goes over storing data as JSON.  

Regards,
Patrick
Telerik by Progress