Options – Formulae

The Formulae section of the Options window contains settings relating to the operation and functionality for displaying and checking formulae within a project.

Options – Formulae window

General

Option Description
Automatic Formula Font Attributes Allows you to set the font colour (Foreground), line highlight colour (Background) and font styling attributes (Bold, Italic, Underline) for all calculations using a pre-defined formula.

Pre-defined Example: =Sum(), =St().

Automatic Inline Calculation Font Attributes Allows you to set the font colour (Foreground), line highlight colour (Background) and font styling attributes (Bold, Italic, Underline) for all calculations using an inline calculation.

Inline Example: =(2*(110/5)).

Reset to Default Returns all font attribute options in this window to their default values.
Apply Font Attributes to Current Project Applies any Font Attributes changes to the currently opened project.
Lines Addressed by Formula Lines that are referenced by the selected formulae are highlighted with the defined Foreground Colour.
Formula Error Checking The Formula Error Checking provides the ability to define the level of error checking on any formula entered.

The levels available are:

  • No Error Checking:
    No indication of problems within formulae or calculations will appear
  • Check for missing Operators:
    Errors such as =(5 (7 + 6)) are identified as an error due to the missing operator between the number 5 and ( characters
  • Check for missing Operators, and Operators and Numbers, outside of the brackets:
    Previous error and errors such as =(5 * 7) + (4 * 6) are detected. The formula should be written =((5 * 7) + (4 * 6)) with brackets enclosing the whole calculation.
Updated on November 14, 2018

Was this article helpful?

Related Articles

Leave a Comment