Syntax highlighting

<< Click to Display Table of Contents >>

Syntax highlighting

If Syntax highlighting is enabled, cells will be colorized according to their content. For example, cells containing an error are displayed in red; cells containing a formula are displayed in green, etc.

This is useful for visualizing which cells contain formulas, fixed values, etc., and where errors occur.

Enabling and disabling syntax highlighting

To enable syntax highlighting, choose the ribbon command View | Syntax highlighting syntax_high_icon (in the View group).

If you click on this command again, it will be disabled.

What the foreground color indicates

When syntax highlighting is enabled, cell contents are displayed in the following foreground colors:

Cell content

Foreground color

Error value

Red

Formula

Green

Fixed positive number

Dark blue

Fixed negative number

Light blue

Fixed logical value

Brown

Fixed text string

Black

What the background color indicates

Cells containing an error are displayed in red foreground color and shaded in one of the following background colors: The background color indicates the error type:

Foreground color

Error type

White

Formula returns an error value. The calculation in this cell returns an error value (caused, for example, by a division by zero).

 

Tip: If you click the cell, an error message is displayed in the status bar (see Error values). Correct the formula accordingly.

Cyan

Syntax error in formula. The calculation in this cell has a syntax error (caused, for example, by a missing parenthesis or missing arguments).

 

Tip: If you click the cell, an error message is displayed in the status bar. Correct the formula accordingly. If you don't correct the formula, it will be replaced by the text string #NULL! when the document is saved!

Light gray

Function not exportable. The calculation in this cell uses an arithmetic function that cannot be saved in the currently chosen file format.

 

Tip: Replace the function by a function that is compatible with the chosen file format. For more information, see the corresponding function description in this manual.

Magenta

Function possibly imported erroneously. The calculation in this cell uses a PlanMaker 97 arithmetic function whose syntax or function might be incompatible with recent versions of PlanMaker. This error only occurs for time functions when importing documents created with PlanMaker 97.

 

Tip: See corresponding function description in this manual.

Yellow

Function unknown. The calculation in this cell uses an arithmetic function unknown to PlanMaker. This error might occur when importing documents created with other applications (e.g. Microsoft Excel).

 

Tip: Replace the function with a corresponding PlanMaker function. For a list of all PlanMaker functions, see Functions from A to Z.