A way to automatize autoFitRow

A way to automatize autoFitRow

Posted by: oleksandr.sydorenko on 5 February 2018, 7:27 am EST

• 

  oleksandr.sydorenko

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 February 2018, 7:27 am EST

  Hey guys.
  
  I’m aware of ```
  
  autoFitRow

  
  My question - is there a way to automatize it somehow? I want this method to be applied for every row on table initialization and also any time when user paste something in the cell that exceeds row height.
  
  Example from the Google Sheets http://recordit.co/BYc51ZcbMN
  As you can see row height adjusts automatically on the paste event here.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 February 2018, 3:21 am EST

  Hello,

  You can call AutoFitRow method in EditEnded and ClipboardPasted events respectively:

  http://help.grapecity.com/spread/SpreadSheets11/SpreadJS~GC.Spread.Sheets.Events~EditEnded_EV.html
  
  http://help.grapecity.com/spread/SpreadSheets11/SpreadJS~GC.Spread.Sheets.Events~ClipboardPasted_EV.html

  Thanks,
  
  Deepak Sharma

• 

  oleksandr.sydorenko

  • Post Options:
  • Link
    Copy

  Posted 6 February 2018, 7:06 am EST

  Got you, thanks for the reply.
  
  So it means that if I want to autoFit all rows with content after table initialized I need to iterate through all rows and apply autoFitRow for each of them, correct?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 February 2018, 3:32 am EST

  Hello,

  That is correct, you would need to loop through each row and call autiFitRow() method to resize the rows.

  Thanks,
  
  Deepak Sharma