WordWrap issues

WordWrap issues

Posted by: peter.jenerette on 11 August 2025, 3:57 pm EST

• 

  peter.jenerette

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 August 2025, 3:57 pm EST

  no sample needed.

  1. using Excel set any cell toe WordWrap.
  2. In Excel, Enter or paste long text into cell.
  3. Note row height increases to accommodate text for the existing width.
  4. Open same workbook in SpreadJS, row height does not auto size for WordWrap like excel.

  Searching forums suggests using code to set a row autoheight flag, but there is no way for a user to set this type of flag in excel. SpreadJS should detect wordwrap and assume row height may need to adjust for text in cell.

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 12 August 2025, 5:37 am EST

  Hi,

  As I understand, you are referring to Excel’s behavior where, after entering or pasting text, the cell is automatically word-wrapped and resized. In SpreadJS, this does not happen.

  In SpreadJS, word wrapping and auto-resizing are two separate functionalities. Unlike Excel, SpreadJS does not automatically resize word-wrapped cells because it preserves user-made changes rather than adjusting them automatically.

  In Excel, when text spans multiple lines and doesn’t fit in a cell, word wrap and resizing are applied automatically. In SpreadJS, however, these actions are not triggered automatically—the text is preserved without altering the cell’s layout.

  That said, SpreadJS provides APIs to replicate Excel’s behavior. You can handle the ValueChanged event or the ClipboardPasted event so that whenever a value is entered or pasted, you can programmatically apply word wrap and/or resize.

  • Forum discussion on word wrap behavior when a value is entered: https://developer.mescius.com/forums/spreadjs/autosize-rows-when-cell-is-wrap-text

  • Forum discussion on pasted value word wrap behavior: https://developer.mescius.com/forums/spreadjs/cell-does-not-expand-when-copy-wrapped-text

  Regards,
  
  Priyam