• 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 parameter of action " " in the " " cell event of Cell xx in Table xxx (Row x, Col x) has a R calculation out of range

Warns that a table cell with an event containing a relative column calculation as one of its parameters is referencing a column that is not valid. For example, if a table has only two columns, A and B, then a calculation in the event in column A that references RC(3) would be invalid since there is no column three columns to the right of column A in the table. Likewise, the calculation RCTOTAL (-1, 1) would also be invalid since there are no columns to the left of column A.

This diagnostic checks events in cells for the following functions: R, RC, RR, RCR, RCTOTAL, and RRTOTAL.

To correct this problem:

Locate the cell containing the event with the RC calculation and modify the parameter to refer to a relationship within the table. For example, in the example discussed above, change the calculation RC(3) in the event to RC(2) to reference an actual table column.

Related Topics

• Document Diagnostics List