Get visible row and column in a viewport

Get visible row and column in a viewport

Posted by: shanmukha.vangaru on 12 April 2022, 11:33 pm EST

• 

  shanmukha.vangaru

  • Post Options:
  • Link
    Copy

  Posted 12 April 2022, 11:33 pm EST

  Hi,

  I need to get the top row and left column of the visible viewport. I am aware that using GetViewportTopRow() and GetViewportLeftColumn() would give me that but when I freeze the first two columns and land the user on different column by setting the activeCol attribute in json, GetViewportLeftColumn() is returning the index as 0 but I am expecting activeCol index. Is there a way to achieve it ?

  Regards,
  
  Shanmukha Vangaru

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 13 April 2022, 6:50 am EST

  Hi Shanmukha,

  You can use the getActiveColumnIndex method, getActiveRowIndex method to get the active column/row index for the sheet. You can also get the left/top cell index using sheet.toJSON().leftCellIndex and sheet.toJSON().topCellIndex.

  For example, you can refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/SyLpgYZeeUGvUHTo_87Xqg/

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

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

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

  Please let us know if you need further assistance on this.

  Regards

  Ankit