Automatic Recalculation

   Whenever automatic is in effect, entering data into a
   cell causes the worksheet to be recalculated in addition
   to the cell just entered. You may wish to turn this off
   when working with large worksheets, as the delay can
   be considerable. You may force a recalculation at any
   time by pressing F1. Remember that automatic mode applies
   only to directly entering new data into cells; unlike
   Lotus 123, the worksheet will not be recalculated after
   moving or copying a range, filling a range with values,
   replicating cells, or immediately after loading a file
   (presumably there's no need to, since the file ought to
   be up to date before it's saved). Hopefully, this will
   save you from waiting for needless recalculations, but it
   also places upon you the responsibility of forcing a
   recalculation when necessary.

Natural Order Recalculation

   Natural order means to recalculate the less dependent
   cells before the more dependent ones. That is, if a
   cell references and thus depends on the value of another
   cell, it would be good to compute the value of that
   referenced cell before using its value in a formula.
   That's precisely what natural order does, and it allows
   you to construct your worksheet without worrying about
   how the position of cells affects the order of recalcul-
   ation.

   Recalculation proceeds row-by-row when natural order has
   been turned off.

Circular References

   There is only one complication to natural order: circular
   cell references. A circular reference occurs when one
   cell refers to another cell that in turn refers back to
   the first. This can occur directly or indirectly (through
   a chain of cells), and it makes reconciliation of the
   worksheet impossible, since the values of the cells
   involved are constantly changing (it's the equivalent of
   an infinite loop in programming). When Opus encounters
   a circular reference, it will use the current value of
   the cell, so that cells are calculated only once.
   Generally, you should regard circular references as an
   error in worksheet construction, unless you purposefully
   create them (and understand the problem they present and
   ways to overcome the problems).

   Whenever a circular reference exists, Opus will display
   the Circ icon in the Panel. You may click on the icon
   to display the address of a cell involved in the
   circularity.

   Note: Unlike Lotus 123, the Circ icon will continue to
   be displayed when natural order is off.



