Spread 8.0 Documentation
SSDelRow, SSDelRowRange Functions
Support Options
DLL Reference > DLL Functions > SSDelRow, SSDelRowRange Functions

Glossary Item Box

SSDelRow, SSDelRowRange Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Deletes the specified row or rows.

Syntax

C

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.

See Also

Deleting Columns and Rows

SSDelCol, SSDelColRange, SSSetSheet functions

ActiveX Correspondence

DeleteRows method

Copyright © GrapeCity, inc. All rights reserved.