SSpread.ShowCell Method

Explanation Scrolls the spreadsheet so that the specified cell appears in the specified position.
Scrolls the spreadsheet so that the specified cell appears in the specified position.

Call format ShowCell(col, row, position)

Return value None

Arguments col Column number

row Row number

position

Cell position
Specify the following values.

Constant	Value	Description
$PositionUpperLeft	0	Upper left
$PositionUpperCenter	1	Upper center
$PositionUpperRight	2	Upper right
$PositionCenterLeft	3	Center left
$PositionCenter	4	Center
$PositionCenterRight	5	Center right
$PositionBottomLeft	6	Bottom left
$PositionBottomCenter	7	Bottom center
$PositionBottomRight	8	Bottom right

Exception EXT-1 ShowCell argument is invalid

EXT-28 An error occurred in the ShowCell method

Example of use

    if (!IsVisible(10, 10, $FALSE)) {
        ShowCell(10, 10, $PositionUpperLeft);
    }

Related item LeftCol, TopRow properties
GetBottomRightCell, SetActiveCell methods
TopLeftChange event