DOLLARFR in Collabora Office: Encode Decimal Values as Fractional Quotations
Use Collabora DOLLARFR to represent ordinary decimal values in a fractional quotation convention, while keeping calculations on the decimal scale.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =DOLLARFR(1.125;16) has independently expected result 1.02, encoding one plus two sixteenths. The returned number is a quotation representation, not the original quantity reduced to 1.02.
Syntax and representation
=DOLLARFR(DecimalDollar; Fraction)
DecimalDollar is an ordinary decimal value. Fraction is the whole-number denominator used for the encoded fractional part. The dedicated Collabora help gives the complementary examples 1.125 becoming 1.02 for sixteenths and 1.1 for eighths.
The function does not convert a currency, choose an exchange rate or format a number as a general fraction string. It returns a numeric encoding whose decimal digits carry the fractional numerator according to the denominator convention.
Use positive integer denominators and a known input convention. The reproducible examples below use nonnegative values exactly on the selected fraction grid, so they do not depend on undocumented rounding of a fractional numerator.
Example 1: encode values on a sixteenth grid
Put 1, 1.125, 1.5 and 1.9375 in A2:A5. Put 16 in F2. Enter =DOLLARFR(A2;$F$2) in B2 and fill down.
Independent encoded outputs are 1.00, 1.02, 1.08 and 1.15 when displayed with two decimal places. Their fractional numerators are zero, two, eight and fifteen, each divided by sixteen.
A numeric result of 1 can display as 1.00 to make the quotation field consistent. Number formatting adds visible zeros; it does not turn the encoded field into an ordinary decimal amount suitable for arithmetic.
Example 2: use different denominator conventions
For the same decimal quantity 1.125, =DOLLARFR(1.125;8) targets 1.1, whereas =DOLLARFR(1.125;16) targets 1.02.
Those are two representations of the same quantity, not different conversion accuracy levels. Store the denominator in a separate labeled cell or column when quotations using multiple conventions appear together.
For thirty-seconds, =DOLLARFR(101.5;32) has independent target 101.16. The sixteen after the decimal point denotes sixteen thirty-seconds, which is one half, not sixteen hundredths.
Advanced application: calculate first and encode the final result
Suppose ordinary decimal values are 100.5 and 101.25. Their average is 100.875. Encoding that average in thirty-seconds gives =DOLLARFR(AVERAGE(100.5;101.25);32), independently 100.28, because 0.875 is 28/32.
The individual encodings are 100.16 and 101.08. Averaging those encoded numbers directly gives 100.62, which is not the proper quote representation of the average. The arithmetic must operate on decoded quantities, followed by a single representation step.
Keep the decimal calculation column even when only encoded quotes are shown in a report. That separation allows a reviewer to reproduce the calculation without reverse-engineering every quotation field.
Advanced application: choose a grid-rounding policy explicitly
If a source decimal is not exactly a multiple of 1/Fraction, decide whether the business rule requires rounding, flooring or retaining a finer value before encoding. DOLLARFR’s documentation does not establish a universal “nearest quoted tick” policy.
For a hypothetical nearest-sixteenth policy applied to 1.14, first use =ROUND(1.14*16;0)/16. The independent rounded quantity is 1.125, and encoding that result gives 1.02.
That is an explicit modeling choice, not a claim that every quotation system uses nearest rounding. Another rule can select a different grid point. Keep the original decimal value so the quantization loss remains visible.
Errors and troubleshooting
A round trip such as =DOLLARDE(DOLLARFR(1.5;16);16) targets 1.5 for this on-grid example. Use the same denominator in both functions and retain full stored precision.
Do not add or subtract the encoded results as if they were ordinary decimal amounts. Do not infer a correct denominator from a familiar-looking result. The examples avoid negative values and malformed denominators; exact native error messages, nonnumeric coercion and off-grid encoding behavior have not been tested in Collabora.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. The snapshot was retrieved on 2026-10-13 and hash-verified on October 15, 2026. Desktop help does not establish Online or mobile support. First introduced release and last functioning version are unknown; the dedicated evidence does not establish them.
No native Collabora or WPS run occurred. Worked values are independent mathematical expectations, not verification of every native error, coercion or numerical limit. Formulas use English names and semicolon separators.