Calculate

Defines the calculation settings for spreadsheets. Defines the behavior of spreadsheets with iterative references, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.


Iterative References

Defines the number of approximation steps carried out during iterative calculations. In addition, you can specify the degree of precision of the answer.

Iterations

Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions. If the Iterations box is not selected, an iterative reference in the table will cause an error message.

Steps

Sets the maximum number of iteration steps.

Minimum Change

Specifies the difference between two iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop.


General

Use Case Sensitive Comparisons Between Cell Contents

Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.

Decimal Places

Defines the number of decimals to be displayed for numbers with the Standard number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.

Calculation Precision Based on Displayed Cell Value

Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not selected, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.

Search Criteria = and <> Must Apply to Whole Cells

Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When the Search criteria = and <> must apply to whole cells box is selected, StarOffice Calc behaves exactly as MS Excel when searching cells in the database functions.

Enable Regular Expressions in Formulas

Specifies that regular expressions are enabled when searching and also for character string comparisons.

Automatically Find Column and Row Labels

Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators.

Jump to Top of Page Back to top