TdxSpreadSheetTableView.CanClearCells(string) Method

Identifies if is possible to clear the specified cell range.

Declaration

function CanClearCells(const AArea: string): Boolean; overload;

Parameters

Name	Type	Description
AArea	string	A reference to the target cell range in A1 format.

Returns

Type	Description
Boolean	True if it is possible to clear the specified cell range; otherwise, False.

Remarks

The function returns True only if the following conditions are met:

• Cell edit operations are allowed (that is, the Spreadsheet control’s OptionsBehavior.Editing property is set to True).

• The specified cell range is editable (that is, the worksheet protection is disabled).

Otherwise, the CanClearCells function returns False.

Note

The CanClearCells function returns True if the worksheet is protected but the Style.Locked property is set to False for one or more cells in the target cell range.