ShowCell Method
Applies To
fpSpread control
Description
Scrolls the sheet so that the specified cell appears in the specified position, without changing the active cell.
Syntax
void CSpreadSheet::ShowCell(long lCol, long lRow, long nPosition);
fpSpread1.ShowCell(lCol As Long, lRow As Long, nPosition As PositionConstants)
Parameters
The following parameters are available:
| Parameter | Description | ||
|---|---|---|---|
| lCol | Column number | ||
| lRow | Row number | ||
| nPosition | Location at which to position the cell in the control | ||
| Value | Constant | Description | |
| 0 | PositionUpperLeft | Top left | |
| 1 | PositionUpperCenter | Top center | |
| 2 | PositionUpperRight | Top right | |
| 3 | PositionCenterLeft | Center left | |
| 4 | PositionCenter | Center | |
| 5 | PositionCenterRight | Center right | |
| 6 | PositionBottomLeft | Bottom left | |
| 7 | PositionBottomCenter | Bottom center | |
| 8 | PositionBottomRight | Bottom right | |
Remarks
Specify the column and row of the cell you want to position. Use the Position parameter to indicate the location where you want the cell to appear in the control. The sheet will scroll so that the specified cell appears in the position you specify.
This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.
This method has no effect on the location or positioning of the active cell. To set a cell to be the active cell, use the SetActiveCell method.
Return Type
None
See Also
Sheet property
SetActiveCell method
DLL Correspondence
SSShowCell function