EdxSpreadSheetCannotChangePartOfArrayError Class
In This Article
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