Calc Guide

Figure 324: Calc calculation options
Iterative references section
Iterative references are formulas that are continuously repeated until
the problem is solved. In this section you can choose the number of
approximation steps carried out during iterative calculations and the
degree of precision of the answer.
Iterations
Select this option to enable iterations. If this options is not selected,
an iterative reference causes an error message.
Steps
Sets the maximum number of iteration steps.
Minimum Change
Specifies the difference between two consecutive iteration step
results. If the result of the iteration is lower than the minimum
change value, then the iteration will stop.
Date section
Select the start date for the internal conversion from days to numbers.
12/30/1899 (default)
Sets 12/30/1899 as day zero.
01/01/1900 (StarCalc 1.0)
Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0
spreadsheets containing date entries.
Chapter 14 Setting up and Customizing Calc 405