DOLLARDE 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.

DOLLARDE converts a fractional-price encoding into an ordinary decimal number. The digits after the decimal point encode a numerator under the supplied denominator; they are not already the decimal value of that fraction. Despite its name, the calculation does not exchange currencies or select a currency symbol. Release implementation.

DOLLARDE(FractionalPrice;Denominator)

• FractionalPrice: required encoded number, with an integer portion and encoded fractional digits.
• Denominator: required positive integer, such as 16 or 32. The source receives this argument as an integer.
• Choose a display format that preserves the intended fractional digit positions when reading or exporting a quote.

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.

=DOLLARDE(1.02;16) interprets the two fractional digits 02 as 2/16 and returns 1.125. =DOLLARDE(1.10;32) interprets 10/32 and gives 1.3125. Numerically 1.10 equals 1.1, so the denominator and chosen digit width are essential to its meaning.

With denominator 8, one decimal digit is used: =DOLLARDE(100.1;8) gives 100+1/8=100.125. It does not mean 100.1 as an ordinary decimal quote.

Let d be the denominator and k the smallest nonnegative integer with 10^k≥d. Split the input into its integer part truncated toward zero and its signed fractional part f. The result is integer + f*10^k/d. Thus d=16 or 32 uses k=2, d=8 uses k=1, and d=100 still uses k=2.

The signed split matters: DOLLARDE(-1.02;16)=-1.125. The inverse operation DOLLARFR uses the same denominator and scale. For the exact intended values, DOLLARFR(DOLLARDE(1.02;16);16) recovers 1.02 apart from floating-point rounding.

The source requires Denominator>0. Zero or negative denominators are outside the supported domain; those invalid calls were not executed here. Fractional denominator conversion was also not tested, so supply a whole integer.

The function performs arithmetic on the encoded number rather than validating a market’s quotation rules. It does not prove that a numerator is an allowed tick or that a price is commercially valid. Keep the denominator attached to the data, and distinguish the decoded value from text formatting or currency conversion.

DOLLARFR, 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.