Investment Studio > Objects > Grid > Error codes
When the Grid object is set not
to show errors (
not depressed in the Grid toolbar; Show
errors item not checked in pop-up menu's Layout
submenu), cells without valid values are blank.
| Cells may display the special error code ##### independently of the Grid's "Show error" setting. Unlike the error codes listed below, ##### doesn't denote an invalid cell value. Instead, it means that the cell value can't be displayed within the current cell size (cell width for alphanumeric data, e.g. strings or numbers; height and width for images). |
When the Grid object is set to show errors, the following error codes are displayed in cells without a valid value:
| #ERR | Generic error, shown when no further information about the error is available. |
| #BUSY! | Computation of the cell's value hadn't been completed when the cell was drawn. |
| #N/A | Value (e.g. a function argument) not available. |
| #NAME? | The formula contains an unrecognized name (symbol, function). Check your spelling! |
| #(? | The formula contains an unmatched left parenthesis. |
| #?) | The formula contains an unmatched right parenthesis. |
| #{? | The formula contains an unmatched left curly bracket (array delimiter). |
| #?} | The formula contains an unmatched right curly bracket (array delimiter). |
| #OP? | An operator is missing in the formula, i.e. two values appear next to each other with no operator between them (e.g. "1 2" instead of "1 + 2"). |
| #DIV/0! | Division by zero. |
| #NULL! | The formula specifies an intersection of two cell ranges that do not intersect. |
| #NUM! | Invalid number, e.g. a numeric function argument outside the valid range or a numeric result that is too small, too large, or can't be found (e.g. when solving an equation). |
| #REF! | The formula contains an invalid cell reference. |
| #CIRC! | The cell contains a circular reference: its value depends on the value of another cell, which in turn depends on the value of the first cell (either directly or indirectly, i.e. through other cells). |
| #VALUE! | A function or operator is used with the wrong type or number of arguments. |