You are here: Features > Integrity Errors > 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

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

A function in the specified cell relies on a range of cell numbers to perform its calculation. The cell selected to begin the range has a greater number than the cell which ends is.

For example, in a table cell, the calculation RCTOTAL(-1, -2) attempts to calculate the total of the cells in the range between the cell directly to the left and the cell to the left of that. Instead, the function should read RCTOTAL(-2, -1) to total the cells from left to right as expected.

To correct this problem:

Examine the function in the cell specified and verify the range of cells involved begins and ends at appropriate cell numbers.

Note:

  • This diagnostic error may also appear if the discrepancy in cell numbers is located in the conditional cells of an action. For example, if the same equation of RCTOTAL(-1, -2) 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 in which the start cell number is bigger than the end cell number.

Related Topics