EdxSpreadSheetCannotChangePartOfArrayError Class

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

Declaration

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.