You can use events when the top row or column changes when scrolling.
This example uses the TopRowChanged and LeftColumnChanged events.
JavaScript |
Copy Code
|
---|---|
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3}); spread.addSheet(); var sheet1 = spread.getSheet(0), sheet2 = spread.getSheet(1); sheet1.bind(GC.Spread.Sheets.Events.TopRowChanged, function (sender, args) { //Set the displayed top row of sheet1 to sheet2 (vertical scroll synchronization). sheet2.showRow(args.newTopRow, GC.Spread.Sheets.VerticalPosition.top); }); sheet1.bind(GC.Spread.Sheets.Events.LeftColumnChanged, function (sender, args) { //Set the displayed left column of sheet1 to sheet2 (Horizontal scroll synchronization). sheet2.showColumn(args.newLeftCol, GC.Spread.Sheets.HorizontalPosition.left); }); |