Identifying Errors

Errors in Cells

Resolver One uses a colour-coded cross to indicate an error in a cell:

X: Cycle Error

The references to cells or ranges are cyclical so that there is no absolute defined value, for example A10 = B4, B4 = A10.

X: Duplicate Header Error

There are two or more rows with the same Header name, or columns with the same Header name.

X: Zero Division Error

There has been an attempt to divide by zero.

X: Formula Error, Type Error or another type

"Formula Error" indicates a problem with the structure/syntax of a formula.

"Type Error" indicates an object of an unexpected type e.g. text, when a numerical value would be expected.

The red cross also indicates other, rarer, errors.

X: Array formulae error

For example, the user is trying to unpack (see unpacking arrays documentation) something that isn't unpackable (for example, a number).

For specific details, hover the mouse over the cell.

Errors in User Code

Resolver One indicates coding errors in three ways:

• Warning triangle in the left margin next to the error. For specific details, hover the mouse over this triangle.
• Red highlight at the side of the scroll bar to the right of the coding pane.
• Red highlight applied to the first line of code containing an error when you click outside the coding pane.

Errors in Worksheet Formulae

Resolver One indicates errors in worksheet formulae using a coloured corner in the top left-hand side of the worksheet:

The warning square is colour-coded identically to crosses indicating cell errors (see above). For specific details, hover the mouse over the coloured corner.