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

Glossary Item Box

SSGetLastValidCell Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

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

Syntax

C

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

C++

BOOL TSpread::GetLastValidCell(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 last valid cell
lpRow Pointer to variable that receives row number of last 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 last cell that can receive the focus (become active). You can then reset the active cell to be the last valid cell.

The last valid cell is usually the cell in the last column and last row. 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 in the last column and last row. 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

SSGetFirstValidCell, SSSetSheet functions

ActiveX Correspondence

GetLastValidCell method

Copyright © GrapeCity, inc. All rights reserved.