TopRowChanged イベント

先頭の行が変更されたときに発生します。

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.TopRowChanged = function(sheet, sheetName, oldTopRow, newTopRow) { };

TopRowChanged = function ( 
   sheet : Worksheet,
   sheetName : string,
   oldTopRow : number,
   newTopRow : number
) { };

パラメータ

sheet: イベントを発生させたシート。
sheetName: シートの名前。
oldTopRow: 変更前の一番上の行のインデックス。
newTopRow: 変更後の一番上の行のインデックス。

使用例

This example synchronizes vertical and horizontal scrolling for sheet 1 and sheet 2.

Javascript

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

This example synchronizes vertical and horizontal scrolling for sheet 1 and sheet 2.

Javascript

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

参照

Events タイプ