FIXED Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; no final supported release is established.
• Scope: English desktop Calc with semicolon-separated formulas. The observed locale was English (USA), default currency USD.
• Checked: October 14, 2026. Eight ordinary examples were recalculated in 4.1.16 on Linux x86-64, Build 9816. Saved types, strings or numeric values, and both controls were checked.

FIXED returns a rounded number as text with a chosen count of decimal places. It normally includes locale-specific thousands grouping, while the optional third argument suppresses that grouping. The result remains text even when it looks like an ordinary number. Release implementation.

=FIXED(Number[;Decimals[;NoThousands]])

• Number: numeric value to format.
• Decimals: optional precision, default 2; the implementation floors it and checks −15 through 15.
• NoThousands: optional FALSE. TRUE suppresses the grouping separator.

Negative Decimals rounds to tens, hundreds and larger positions; the final text uses zero fractional digits.

All eight formulas were recalculated. The middle column is a numeric reference; the final column is the saved string. Quotation marks delimit the text here and are not part of the cell value. Exact symbols and separators are scoped to the observed English (USA), default USD settings.

The default example rounds 1234.567 to two decimals. The example with NoThousands=1 has the same rounded amount, 1234.57, but omits grouping. This changes the string presentation, not the numerical precision.

At Decimals=−1, the numeric rounded amount is 1230. At Decimals=0, it is 1235. The exact positive and negative half examples at zero decimals produce the amounts 13 and −13. Compare the native text column with the numeric reference rather than treating a grouping separator as part of the number’s mathematical value.

The implementation first rounds at the selected decimal scale, then generates a locale-aware number-format string. This separates the mathematical rounding operation from decimal marks, grouping symbols and negative formatting.

For a numeric calculation pipeline, prefer a numeric rounding function and apply cell formatting separately. A FIXED result is suitable for a deliberate text label, but a numeric-looking string can be ignored or parsed differently by another function or software product. Preserve the original numeric data when exporting both a value and a display label.

The tested third argument is numeric 1, interpreted as TRUE and therefore disabling grouping. Other optional-argument forms, blank cells and invalid precision were not executed. The source handles omitted precision with its default; it does not make every malformed input a valid number.

Exact text is scoped to the observed locale. A comma may be a thousands separator in one locale and a decimal separator in another. No universal cross-locale parsing claim is made. Binary floating-point arithmetic before this function can also affect cases near a rounding boundary; the ordinary examples are not a proof of exact decimal accounting arithmetic.

DOLLAR, round, TEXT.

• Function-specific release implementation

The generated ODF was opened in the native application, hard-recalculated and saved separately. Its informational “Not all attributes could be read” load warning was retained. Both stale and uncached SUM controls refreshed correctly. The original XLSX was not executed, and this generated-ODF test does not establish manual entry or execution in another release or locale.