GetLastValidCell, ScriptGetLastValidCell Methods
Applies To
fpSpread control
Description
Returns the last cell in the sheet to which the user can move the focus.
Syntax
void CSpreadSheet::GetLastValidCell (long* Col, long* Row);
fpSpread.GetLastValidCell(Col As Long, Row As Long)
| Note: The ScriptGetLastValidCell method uses the same syntax except method parameters that are not passed "ByVal" are declared as variants. For more information on Script methods, see Scripting Environment Usage. |
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| Col | Column number of cell |
| Row | Row number of cell |
Remarks
If the EditModePermanent property is set to True, locked and static text cells are not valid active cells; therefore, the last valid cell is not always the last cell in the sheet. A cell is also not valid if its height or width is set to zero.
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.
| Note: Call this method if you use the Spread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the Spread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and call the ScriptGetLastValidCell method. ScriptGetLastValidCell method parameters that are not passed "ByVal" are declared as variants. |
Return Type
Returns the coordinates of the last valid cell in the Col and Row parameters.
See Also
ScriptEnhanced, Sheet properties
GetFirstValidCell method
DLL Correspondence
SSGetLastValidCell function