TdxSpreadSheetTableView.CanDelete(TdxSpreadSheetCellsModification) Method

Identifies if users can delete cell data from the worksheet.

Declaration

function CanDelete(AModification: TdxSpreadSheetCellsModification): Boolean; overload; virtual;

Parameters

Name	Type	Description
AModification	TdxSpreadSheetCellsModification	Enumerates options that define how cell insert and delete operations affect adjacent cells.

Returns

Type	Description
Boolean	True if users can delete cell data; otherwise, False.

Remarks

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

• Cell delete operations are allowed (that is, the Spreadsheet control’s OptionsBehavior.Editing and OptionsBehavior.Deleting properties are set to True).

• Users can delete cell values (that is, the worksheet protection is disabled or the protected worksheet allows users to delete columns or rows).

Otherwise, the CanDelete function returns False.

Note

The CanDelete function only identifies if an ability to delete cell values is available. If you need to identify if users can delete both values and custom cell styles, call the CanClearCells function instead.