Autosize rows when cell is wrap text

Autosize rows when cell is wrap text

Posted by: dean.kinnear on 11 August 2025, 3:40 pm EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 August 2025, 3:40 pm EST

  Is there anyway to get rows to autosize automatically when cell is formatted as wrap text, like Excel does?
  
  

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 12 August 2025, 4:53 am EST - Updated 12 August 2025, 4:58 am EST

  Hi,

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

  In Excel, when text spans multiple lines and doesn’t fit in a cell, the application will automatically apply word wrap and resize the cell. In SpreadJS, however, word wrapping and resizing are not triggered automatically—it simply preserves the text without adjusting cell layout.

  That said, SpreadJS provides APIs to replicate Excel’s behavior. You can handle the ValueChanged event, and within that event, apply word wrap and auto-resizing programmatically—so you don’t have to do it manually each time.

  Sample:
  
  https://jscodemine.mescius.io/share/UHkjg9TWIkWfXW41RA8FoQ/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  spread.bind(GC.Spread.Sheets.Events.ValueChanged, (e, args) => {
      args.sheet.suspendPaint();
      args.sheet.suspendCalcService();
      args.sheet.getCell(args.row, args.col).wordWrap(true);
      args.sheet.autoFitRow(args.row);
      args.sheet.resumeCalcService();
      args.sheet.resumePaint();
  });

  GIF:

  References:

  • Word wrap: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.CellRange#wordwrap

  • AutoFitRow: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#autofitrow

  • ValueChanged event: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Events#valuechanged

  Regards,
  
  Priyam