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