• Integrity Errors
  • A cell CLPxx has a name that conflicts with the naming convention
  • A cell group xxx is not in use
  • A cell UDxxx has a name that conflicts with the naming convention for user defined data
  • A cell xx specifies its width as Column Width but is not a table cell
  • FMTDATESTR function
  • A header/footer has been assigned to use either "Previous attached header/footer"
  • A table cell has a R/RC/RR/RCR/RCTOTAL/RRTOTAL calculation out of range
  • An instance of cell xx is set to Use Paragraph Font but is contained in a font range covering just the cell
  • An instance of table cell xxx.xx is located outside table xxx
  • An instance of table cell xxx.xx refers to non-existent table xxx
  • Cell xx is an accumulator cell and is not located in the Main Document
  • Cell xx is an accumulator total but is not located in the Carry Forward Header
  • SDATETOJ function
  • Cyclic roll forward reference detected
  • Duplicated cell number xx is found
  • Duplicated table name xxx appears in Freeze and main document
  • Header/Footer xx has been assigned for Subsequent pages, but the Last page of the range is using
  • Header/footer xx has been assigned to the last page of a range but Subsequent pages
  • Headers/footers xx and xy have been assigned for Subsequent pages, but the Last page of the range
  • Headers/footers xx and xy have been assigned to the Last page of a range, but Subsequent pages
  • Map/Account/LS (group) number xxx linked in cell xx is nonexistant or has no accounts
  • Map/Account/LS xxx is never linked
  • Overlapping sort sections between paragraphs xx and yy / Partial sections between paragraphs xx and yy
  • Paragraph in Table xxx (Row x, Col x), which is not the last paragraph in the row, has set keep-with-next
  • Paragraph sorting label: xx is used in 2 or more sections
  • Style normal has a following style indent that doesn't exist
  • Table xxx (Row x, Col x) contains a cell xxx.xx belonging in a different column in this table
  • Table xxx (Row x, Col x) contains a cell xxx.xx belonging in a different column not currently in this table
  • Table xxx (Row x, Col x) contains a cell xxx.xx belonging in a different row in this table
  • Table xxx (Row x, Col x) contains a cell xxx.xx belonging in a different row not currently in this table
  • Table xxx contains a cell xxy.xx belonging to non-existent table xxy
  • Table xxx contains a cell xxy.xx belonging to table xxy
  • Table xxx. Very tall wide-table set to wrapping
  • The following cells are multiply linked to External Data ID xxx using different Load Calculations
  • The following cells are multiply linked to External Data ID xxx
  • The height of header xx, assigned to Subsequent pages, is less than the height of header xy, assigned to the Last page
  • The parameter of action " " in the " " cell event of Cell xx in Table xxx (Row x, Col x) has a R calculation out of range
  • The resulting cell from a R() calculation of a non-table cell doesn't exist
  • The xx field of Cell xx in Table xx (Row x, Col x) has a xx calculation which contains a circular reference
  • The xx field of Cell xx in Table xx (Row x, Col x) has a xx in which the start cell number is bigger than the end cell number
  • xxx balance of Map/Account/LS number xxx is linked x times

The xx field of Cell xx in Table xx (Row x, Col x) has a xx calculation which contains a circular reference

A function in the specified cell relies on a range of cell numbers to perform its calculation. The cell in question is also included in the specified range.

For example, in a table cell, the calculation RCTOTAL(-2, 1) attempts to calculate the total of the cells in the range beginning with the cell two columns to the right and ending with the cell to the left of the cell in question. As the total is calculated, the same equation is called again which forms the circular reference.

To correct this problem:

Ensure the cell containing the equation does not fall within the range of the equation.

Note:

• This diagnostic error may also appear if the circular reference is located in the conditional cells of an action. For example, if the same equation of RCTOTAL(-2, 1) appears in the skip condition of an event action, an integrity check error will appear. To provide more information, though, the error will appear as:

  The "<fieldname>" parameter of action "<actionname>" in the "<eventname>" cell event of Cell <cellnumber> in Table <tablenumber> (Row <rownumber>, Col <columnnumber>) has a <functionname> calculation which contains a circular reference.

Related Topics

• Document Diagnostics List