How to hide columns or rows in spread v11

How to hide columns or rows in spread v11

Posted by: viswanath.malepati on 31 January 2018, 6:32 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 January 2018, 6:32 am EST

  In V9 to hide any column, we used to do the following:

  sheet.getColumns(startIndex, endIndex).visible(false);

  but, in v11 get columns is deprecated and we have to use getRange.

  So i treid following:
  
  sheet.getRange(0,0,3,1,3).visible(false)

  and its not working.

  So, how do we hide columns/rows in v11?

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 1 February 2018, 1:08 am EST

  Found the way: sheet.getRange(-1, 0, -1, 1).visible(false)

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2018, 5:43 am EST

  Hello,

  That is correct, thanks for letting us know.

  Thanks,
  
  Deepak Sharma