Calc Guide

01/01/1904
Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are
imported in a foreign format.
Other options
Specify a variety of options relevant to spreadsheet calculation.
Case sensitive
Specifies whether to distinguish between upper and lower case in
texts when comparing cell contents. The EXACT text function is
always case-sensitive, independent of the settings in this dialog.
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.
Precision as shown
Specifies whether to make calculations using the rounded values
displayed in the sheet. Charts will be shown with the displayed
values. If this 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 this option is
selected, Calc behaves exactly like MS Excel when searching cells in
the database functions.
This search: Has this result:
win Finds win, but not win95, os2win, or upwind
win.* Finds win and win95, but not os2win or upwind
.*win Finds win and os2win, but not win95 or upwind
.*win.* Finds win, win95, os2win, and upwind
If this option is not selected, the win search pattern acts like .*win.*
—the search pattern can be at any position within the cell when
searching with the Calc database functions.
Enable regular expressions in formulas
Specifies that regular expressions are enabled when searching and
also for character string comparisons. This relates to the database
functions, and to VLOOKUP, HLOOKUP and SEARCH.
406 OpenOffice.org 3.x Calc Guide