Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetTableView.CanModifyDataInArea(string,TdxSpreadSheetCellsModificationMode) Method

Identifies if it is possible to change values within the specified cell range.

#Declaration

Delphi
function CanModifyDataInArea(const AArea: string; const AMode: TdxSpreadSheetCellsModificationMode): Boolean; overload;

#Parameters

Name Type
AArea string
AMode TdxSpreadSheetCellsModificationMode

#Returns

Type
Boolean

#Remarks

Both overloaded function variants return True if the target cell range contains no protected cells; otherwise, False. Use the AMode parameter to check if it is possible to make a specific change to cells within an array formula result area. This parameter value is ignored if the target cell range does not intersect an array formula’s result. Refer to the TdxSpreadSheetCellsModificationMode type description for details.

The first and second overloaded CanModifyDataInArea function variants accept the target cell range and a reference (as a string in the A1 format) to the target cell range, respectively.

Note that a cell is protected if:

See Also