Customize LibreOffice Calc Precision Settings

LibreOffice Calc allows users to fine-tune how formulas, numbers, and circular references are evaluated within spreadsheets. This guide provides an overview of the calculation precision settings available in LibreOffice Calc, explaining how each option functions and where to configure them to maintain numerical accuracy across your data sheets.

To access calculation precision settings, open LibreOffice Calc and navigate to Tools > Options > LibreOffice Calc > Calculate (on macOS: LibreOffice > Preferences > LibreOffice Calc > Calculate).

Precision as Shown

By default, LibreOffice Calc maintains internal floating-point values (up to 14–16 digits of precision) during calculations, even if the cell is formatted to display fewer decimal places.

Enabling Precision as shown forces Calc to truncate and calculate values using only the rounded digits visible on the screen. For example, if a cell contains 10.555 but is formatted to show two decimal places (10.56), Calc will calculate using 10.56 instead of the original underlying number.

Decimal Places

Located under the General calculations section, this setting allows you to specify the default number of decimal places displayed for numbers formatted with the “Standard” or “General” number format. Adjusting this value changes the default visual representation of numbers without altering their internal calculation precision, unless “Precision as shown” is also enabled.

Iterative References (Circular Calculations)

When formulas contain circular references (referring back to themselves directly or indirectly), you can enable iterative calculations to find an approximate solution through repeated loops:

• Iterations: Specifies the maximum number of recalculation cycles Calc will perform before stopping.
• Minimum Change: Defines the precision threshold for convergence. If the difference between the results of two consecutive iterations is smaller than this value, the calculation stops automatically.

Date Base Settings

Calculations involving dates rely on a serial number system mapped to a reference start date. While not strictly a decimal precision setting, choosing the correct base date ensures exact day and time calculation accuracy, particularly when sharing files across different spreadsheet programs:

• 12/30/1899 (default): Standard date origin used by modern spreadsheet software.
• 01/01/1900: Legacy spreadsheet compatibility base date.
• 01/01/1904: Standard base date used historically by older Mac spreadsheet applications.

Search Criteria and Text Matching Precision

Calc provides matching options that determine how strictly text and lookups (such as VLOOKUP or MATCH) are evaluated:

• Search criteria = and <> must apply to whole cells: Ensures lookups match entire cell strings rather than partial substrings.
• Enable regular expressions in formulas: Allows standard pattern-matching precision.
• Enable wildcards in formulas: Allows basic wildcard matching (*, ?) standard in other spreadsheet software.