How to get Spreadjs Sheet Horizontal/Vertical scroll position

How to get Spreadjs Sheet Horizontal/Vertical scroll position

Posted by: seshareddy.kamaganiguntla on 23 November 2021, 5:44 am EST

• 

  seshareddy.kamaganiguntla

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 November 2021, 5:44 am EST

  I have usecase where i need to get scroll bars position of a sheet, is there any way to get them.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 24 November 2021, 6:13 am EST

  Hi,

  You may use the getViewportTopRow, getViewportBottomRow, getViewportLeftColumn and getViewportRightColumn method which returns the viewport top and bottom row index. Please refer to the following code snippet and let me know if you face any issues.

  
  var brow = activeSheet.getViewportBottomRow(1);
  var lcol = activeSheet.getViewportLeftColumn(1);
  var rcol = activeSheet.getViewportRightColumn(1);
  var trow = activeSheet.getViewportTopRow(1);
  alert(brow);
  alert(lcol);
  alert(rcol);
  alert(trow);
  /*for getting the x and Y position*/
  let rect = sheet.getCellRect(row,col)
  console.log(rect.x,rect.y)
  
  

  API References:

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

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

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

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

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

  Regards,
  
  Avinash