How to default wordwrap on cells?

How to default wordwrap on cells?

Posted by: sundaydavid on 29 October 2019, 3:11 pm EST

• 

  sundaydavid

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 October 2019, 3:11 pm EST

  Hi, I’m trying to apply wordwrap to all cells but initializing is very slow, is there a better way to implement it other than this:

  activeSheet.getRange(0, 0,40, 15,
  
  GC.Spread.Sheets.SheetArea.viewport)
  
  .wordWrap(true);

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2019, 1:54 am EST

  Hi,

  For batch updates, please use the suspendPaint()/resumePaint() to improve performance. Please refer to the following code snippet:

  activeSheet.suspendPaint();
  activeSheet.getRange(0, 0,40, 15,GC.Spread.Sheets.SheetArea.viewport).wordWrap(true);
  activeSheet.resumePaint();
  

  You may refer to the following document which explains the working of suspendPaint/resumePaint for a better understanding:
  
  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#UsingsuspendPaintandresumePaint.html

  Regards
  
  Sharad