DOLLARFR Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this is a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight ordinary reference formulas were recalculated from generated ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent arithmetic were checked.

DOLLARFR converts an ordinary decimal value into a numeric fractional-price encoding. The fractional digits represent a numerator under the supplied denominator. The output is still a number, so a separate number format may be needed to retain the intended digit positions visually. Release implementation.

DOLLARFR(DecimalPrice;Denominator)

• DecimalPrice: required ordinary decimal value.
• Denominator: required positive integer fraction denominator. Use the same denominator when decoding the result with DOLLARDE.
• The function does not choose a currency, perform an exchange-rate conversion or round to a permitted trading increment.

The native column contains saved 4.1.16 results; independent references use high-precision arithmetic and the stated source rules. Values are shown to twelve decimal places where needed.

=DOLLARFR(1.125;16) returns 1.02, representing 1+2/16. =DOLLARFR(1.3125;32) returns 1.1, which is conventionally displayed as 1.10 to keep the two numerator positions visible. It represents 10/32, not 1/32.

For denominator 8, =DOLLARFR(100.125;8) gives 100.1, representing 100+1/8. Use a one-decimal display for that encoding and a two-decimal display for denominators such as 16 or 32, while keeping the denominator recorded separately.

Write the decimal input as integer+f, using truncation toward zero for the integer part. With k chosen so 10^k is the smallest power of ten at least as large as the denominator, the encoding is integer + f*denominator/10^k. For 1.25 and denominator 16, f*16=4 and the result is 1.04.

Negative inputs preserve the signed fraction: −1.125 with denominator 16 becomes −1.02. Decoding with DOLLARDE and the same denominator reverses the arithmetic within floating-point precision. Changing the denominator after encoding changes the quote’s interpretation.

Use a positive whole denominator. The source rejects nonpositive denominators, but those invalid cases were not part of the native fixture. It does not check that the encoded numerator is an integer, so an arbitrary decimal input may produce more fractional digits than a conventional quote allows.

Do not treat the output as an ordinary decimal price in later arithmetic unless that is intentional. Decode first when ordinary decimal calculations are needed. Cell formatting changes presentation only; it cannot supply a missing denominator or establish a market’s quotation policy.

DOLLARDE, DOLLAR, round.

• Function-specific release implementation

The generated ODF produced the informational load warning “Not all attributes could be read.” The sheet was hard-recalculated and saved separately. All eight ordinary function identities, inputs and results were reconciled; a stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7. This establishes the stated examples, not every workbook style or invalid input. Other explanatory identities are independent calculations. The authoring-tool XLSX was not executed in OpenOffice, and its preview values are not the native results reported here.