Spread 8.0 Documentation
GetFirstValidCell, ScriptGetFirstValidCell Methods
Support Options
ActiveX Reference > ActiveX Methods > GetFirstValidCell, ScriptGetFirstValidCell Methods

Glossary Item Box

GetFirstValidCell, ScriptGetFirstValidCell Methods


See Also    DLL    Example

Applies To

fpSpread control

Description

Returns the first cell in the sheet that allows the user to move the focus to it.

Syntax

C++

void CSpreadSheet::GetFirstValidCell (long* Col, long* Row);

Visual Basic

fpSpread.GetFirstValidCell(Col As Long, Row As Long)

Note: The ScriptGetFirstValidCell 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 first valid cell is not always cell A1. 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 ScriptGetFirstValidCell method. ScriptGetFirstValidCell method parameters that are not passed "ByVal" are declared as variants.

Return Type

Returns the coordinates of the first valid cell in the Col and Row parameters.

See Also

CellType, ColWidth, EditModePermanent, Lock, RowHeight, ScriptEnhanced, Sheet properties

GetLastValidCell method

DLL Correspondence

SSGetFirstValidCell function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.