Rules Engine functionality

Note: The former Rules Engine with accelerators is obsolete. Accelerator definitions are automatically removed in a later version. The rules are calculated with the current rules engine.

Rules Engine calculates the entire range of cells that the rule is required to execute. This data is fetched as a block in as few operations as possible. The fetch requests all the cells, whether empty or not. Only the non-empty cells return data and only this data is processed.

Sometimes it is not clear where the data comes from without executing the rule. This is the case with conditional rules; that is, with rules containing the IF function. For example, if the location of a target cell depends on whether the evaluation of a condition is true or false, then it cannot be clear where the data is supposed to come from. This problem is solved by fetching the data for the evaluation of all conditions first. It continues with two sub-queries, one for the cases where the condition is true and the other one for where the condition is false.