WordWrap + auto size row

Posted by: eduardolopez on 10 September 2017, 10:58 am EST

  • Posted 10 September 2017, 10:58 am EST

    Rows, columns and cells support WordWrap but not they way I was expecting. How can I auto size the row height based on cell contents, after text has been entered --à la Excel?

    Thank you,
    Eduardo Lopez
  • Marked as Answer

    Replied 10 September 2017, 10:58 am EST


    Apologies for the delayed response. Once the wordwrap is set then in order to auto size the row you need to set CanUserResize property to true as given in code below then double-click the bottom edge of the row header to resize the row.

         mySpread.Sheets[0].Columns[0].CanUserResize = true;
    for (int i = 0; i < mySpread.ActiveSheet.Rows.Count - 1; i++)
    mySpread.Sheets[0].Rows[i].CanUserResize = true;
    mySpread.Sheets[0].SetRowResizable(i, true);
    mySpread.Sheets[0].SetColumnResizable(0, true);

    Please go through this link for the same:-


    Hope it helps.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels