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

EdxSpreadSheetCannotChangePartOfArrayError Class

The exception class for errors that occur on an unauthorized change of an array formula result cell range.

#Declaration

Delphi
EdxSpreadSheetCannotChangePartOfArrayError = class(
    EdxSpreadSheetError
)

#Remarks

An array formula is a formula expression whose result occupies a cell range. This result cell range is protected from accidental changes in any spreadsheet document regardless of its worksheet protection settings. To edit a cell within the result range, an end user must press the Ctrl+Shift+Enter key combination to confirm a value change in an active in-place cell editor.

The EdxSpreadSheetCannotChangePartOfArrayError exception occurs when an end user confirms a value change in an array formula’s result cell range without pressing the Ctrl+Shift+Enter key combination.

#Inheritance

TObject
Exception
EdxException
EdxSpreadSheetError
EdxSpreadSheetCannotChangePartOfArrayError
See Also