Set All Rows Auto Height

2 posts, 0 answers
  1. SierraDev20
    SierraDev20 avatar
    1 posts
    Member since:
    Jul 2019

    Posted 08 Nov 2019 Link to this post

    I'm attempting to load an Excel spreadsheet into the Spreadsheet control (which, I've been able to do dynamically). However, our spreadsheets have more than a single line of text and therefore need to have auto height set to the entire worksheet versus per row. How would we go about doing this? I've read the documentation about setting specific row(s) auto-height, but nothing for setting the entire worksheet to have auto-height rows.
  2. Peter Milchev
    Admin
    Peter Milchev avatar
    689 posts

    Posted 13 Nov 2019 Link to this post

    Hello,

    The Worksheets indeed does not have the auto row height functionality. The solution to that is to select a big range of rows on the client-side and set the wrap property to true, which will adjust the cell height, hence affect the whole row height.

    Another option is on the server-side to iterate over the generated cells and set the .Wrap property.

    There is also a feature request for the underlying Kendo UI Spreadsheet widget where you can follow the feature progress and cast your vote:

     

    Regards,
    Peter Milchev
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top