SSClearData, SSClearDataRange Functions
Applies To
fpSpread DLL control
Description
Delete the data from the specified cell or block of cells.
Syntax
BOOL SSClearData(HWND hWnd, SS_COORD Col, SS_COORD Row);
BOOL SSClearDataRange(HWND hWnd, SS_COORD Col, SS_COORD Row, SS_COORD Col2, SS_COORD Row2);
BOOL TSpread::ClearData(SS_COORD Col, SS_COORD Row);
BOOL TSpread::ClearDataRange(SS_COORD Col, SS_COORD Row, SS_COORD Col2, SS_COORD Row2);
Parameters
The following parameters are available:
Parameter | Description |
---|---|
hWnd | Window handle of the fpSpread control |
Col | Column number of cell or column number of upper-left cell of the block if specifying a block for the SSClearDataRange function |
Row | Row number of cell or row number of upper-left cell of the block if specifying a block for the SSClearDataRange function |
Col2 | Column number of lower-right cell of the block if specifying a block for the SSClearDataRange function |
Row2 | Row number of lower-right cell of the block if specifying a block for the SSClearDataRange 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 Col, Row, Col2, and Row2 parameters, see Using Column and Row Properties.
Remarks
Use the SSClearDataRange function to delete the data from a block of cells.
These functions clear only the data from the specified cell or block of cells, leaving all the formatting unchanged. For example, if the cleared cell is a button cell, it remains a button cell.
If you want to clear the data and the current formatting, call the SSClear or SSClearRange function.
Return Value
TRUE if the function completes successfully; FALSE otherwise.
See Also
SSClear, SSClearRange, SSSetSheet functions
ActiveX Correspondence
ClearRange method