Spread 8.0 Documentation
SSGetFirstValidCell Function
Support Options
DLL Reference > DLL Functions > SSGetFirstValidCell Function

Glossary Item Box

SSGetFirstValidCell Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Returns the coordinates of the first valid cell in the sheet.

Syntax

C

BOOL SSGetFirstValidCell(HWND hWnd, LPSS_COORD lpCol, LPSS_COORD lpRow);

C++

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

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