How to adjust width of the columns?

6 posts, 0 answers
  1. Michael
    Michael avatar
    6 posts
    Member since:
    Jun 2015

    Posted 07 Jul Link to this post

    How to increase/decrease width of the columns in the spreadsheet manually?
  2. Patrick
    Admin
    Patrick avatar
    171 posts

    Posted 07 Jul Link to this post

    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
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Kendo UI is VS 2017 Ready
  4. Michael
    Michael avatar
    6 posts
    Member since:
    Jun 2015

    Posted 07 Jul in reply to Patrick Link to this post

    Is possible to resize columns width by user on GUI? 
  5. Patrick
    Admin
    Patrick avatar
    171 posts

    Posted 08 Jul Link to this post

    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
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  6. Michael
    Michael avatar
    6 posts
    Member since:
    Jun 2015

    Posted 08 Jul in reply to Patrick Link to this post

    Thanks it works ! Can you please help me to get spreadsheet columns width to save dynamically by angular.
  7. Patrick
    Admin
    Patrick avatar
    171 posts

    Posted 11 Jul Link to this post

    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
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
Back to Top
Kendo UI is VS 2017 Ready