Link Search Menu Expand Document

SSpread.TopLeftChange Event

Occurs when scrolling a spreadsheet with keys or scroll bars and changing the leftmost or top row displayed.

The following child objects are attached to the Event object.

Type Name Description
Number BlockCol Leftmost column number of cell block
Number BlockRow Row number at the top of the cell block
Number BlockCol2 Rightmost column number of cell block
Number BlockRow2 Row number at the bottom of the cell block
Number CurCol Column number of the cell pointed to by the mouse pointer
Number CurRow Row number of the cell pointed to by the mouse pointer

The event also occurs when setting the LectCol and TopRow properties.

Example of usage<br<>

Function OnTopLeftChange(e) {
    Col = e.OldLeft;
    Row = e.OldTop;
    BackColor = $STD;
    Col = e.NewLeft;
    Row = e.NewTop;
    BackColor = $RED;
}

Related Item
LeftCol, TopRow property