SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Frequently Used Events / Using Events when the Top Row or Column Changes
In This Topic
    Using Events when the Top Row or Column Changes
    In This Topic

    You can use events when the top row or column changes when scrolling.

    Using Code

    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);
    });