SSDelRow, SSDelRowRange Functions

Applies To

fpSpread DLL control

Description

Deletes the specified row or rows.

Syntax

BOOL SSDelRow(HWND hWnd, SS_COORD Row);

BOOL SSDelRowRange(HWND hWnd, SS_COORD Row, SS_COORD Row2);

C++

BOOL TSpread::DelRow(SS_COORD Row);

BOOL TSpread::DelRowRange(SS_COORD Row, SS_COORD Row2);

Parameters

The following parameters are available:

Parameter	Description
hWnd	Window handle of the fpSpread control
Row	Row number of row to delete
Row2	Row number of last row to delete if specifying a range for the SSDelRowRange function

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. To determine the settings you want for the Row and Row2 parameters, see Using Column and Row Properties.

Remarks

Use the SSDelRowRange function to delete a range of rows.

When using the SSDelRowRange function, make sure that the value of the Row parameter is less than the value of the Row2 parameter.

The SSDelRow and SSDelRowRange functions do not change the maximum number of rows specified by the SSSetMaxRows function. When you use the SSDelRow or SSDelRowRange functions to delete a row, a blank row is automatically added at the end of the sheet.

Return Value

TRUE if the function completes successfully; FALSE otherwise. The function returns FALSE if the row or rows to be deleted are beyond the last row that contains data.

ActiveX Correspondence

DeleteRows method