SSGetFirstValidCell Function
Applies To
fpSpread DLL control
Description
Returns the coordinates of the first valid cell in the sheet.
Syntax
BOOL SSGetFirstValidCell(HWND hWnd, LPSS_COORD lpCol, LPSS_COORD lpRow);
BOOL TSpread::GetFirstValidCell(LPSS_COORD lpCol, LPSS_COORD lpRow);
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| hWnd | Window handle of the fpSpread control |
| lpCol | Pointer to variable that receives column number of first valid cell |
| lpRow | Pointer to variable that receives row number of first valid cell |
Remarks
This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.
Use this function to determine the first cell that can receive focus (become active). You can then reset the active cell to be the first valid cell.
The first valid cell is usually cell A1. However, if the SSSetBool function SSB_EDITMODEPERMANENT option is on, noneditable and locked cells are not valid. Therefore, the last valid cell might not be the cell A1. A cell is also not valid if its height or width is set to zero.
Return Value
TRUE if the function completes successfully; FALSE otherwise.
See Also
SSGetLastValidCell, SSSetSheet functions
ActiveX Correspondence
GetFirstValidCell method