TdxSpreadSheetTableView.CanInsert(TdxSpreadSheetCellsModification) Method

Identifies if users can insert columns or rows to the worksheet.

Declaration

function CanInsert(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 insert cell data; otherwise, False.

Remarks

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

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

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

Otherwise, the CanInsert function returns False.