Posted 22 November 2021, 8:44 pm EST
I have usecase where i need to get scroll bars position of a sheet, is there any way to get them.
Forums Home / Spread / SpreadJS
Posted by: seshareddy.kamaganiguntla on 22 November 2021, 8:44 pm EST
Posted 22 November 2021, 8:44 pm EST
I have usecase where i need to get scroll bars position of a sheet, is there any way to get them.
Posted 23 November 2021, 9:13 pm 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