How to change height of all rows

How to change height of all rows

Posted by: razeris563 on 28 July 2021, 8:59 am EST

• 

  razeris563

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 July 2021, 8:59 am EST

  Hey guys, i am trying to change the height of all rows but unfortunately i wasn’t able to find how. The best i could find was this: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~setRowHeight.html?highlight=setrowheight%2C

  Where in .setRowHeight(), the first parameter is the row Index. But in my scenario i would have to somehow put a range of all rows and not just 1 index to make every row height bigger.

  Thank you a lot for any tips and answers!

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 29 July 2021, 6:17 am EST

  Hi Simon,

  There could be a two-way to achieve the required functionality. The first would be use the getRange method for selecting the entire rows and then use the height method for setting the height. Please refer to the following code snippet.

  
  let sheet = spread.getSheet(0);
  sheet.suspendPaint();
  sheet.getRange(0,-1,sheet.getRowCount(),-1).height(100)
  sheet.resumePaint();
  
  

  The second approach would be to set the defaults.rowHeight property. Pleae refer to the following code snippet and let us know if you face any issues.

  
  spread.getSheet(0).defaults.rowHeight = 80
  
  

  getRange: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~getRange.html

  height: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.CellRange~height.html

  Regards
  
  Avinash

• 

  razeris563

  • Post Options:
  • Link
    Copy

  Posted 29 July 2021, 6:20 am EST

  Thank you Avinash!