Conditions for Executing Workbook Scripts on Result Entry

When a workbook cell's content is changed but before any update is persisted, any related event scripts, first from the generic workbook script (defined by the WORKBOOK_SCRIPT application preference), and then from the scheme workbook script for each scheme opened in the workbook, in the order in which the schemes are displayed in the workbook, are run to perform custom logic. This can be used to validate the data entered into the current cell and prohibit entry. Refer to the Workbook API.

When a workbook cell's content is changed and after any update is persisted, any related event scripts, first from the generic workbook script (defined by the WORKBOOK_SCRIPT application preference), and then from the scheme's Workbook Script for each scheme opened in the workbook, in the order in which the schemes are displayed in the workbook, are run to perform custom logic. This can be used to execute post-change functionality on other cells. Refer to the Workbook API.