ROMAN in Collabora Office: Choose Classical or Simplified Roman Numerals

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=ROMAN(Number [; Mode])

Mode is optional and ranges from 0 to 4. Higher values allow greater simplification. The dedicated source explicitly gives all five outputs for 999 and establishes an empty-text result for zero.

The guide uses integer inputs within the documented interval. Fractional truncation, numeric-text or Boolean coercion, invalid modes and exact error codes are not established by the short Collabora page.

Roman numerals are output labels here. Retain the original numeric value for sorting, arithmetic and validation instead of relying on the alphabetical order of the rendered text.

Enter only the numeric column in A2:A7. Put =ROMAN(A2;0) in B2 and fill down.

For 42, XL represents forty and II represents two. For 2026, MM represents two thousand, XX represents twenty and VI represents six.

These are independently constructed classical forms under the documented zero-mode contract. The larger endpoint is a valid documented input, but this tutorial does not extend the function beyond 3999 using overlines or another notation.

Put 999 in D2 and modes 0, 1, 2, 3 and 4 in E2:E6. In F2 use =ROMAN($D$2;E2) and fill down.

The character counts are independently checked with the displayed strings. More simplification does not mean that every adjacent mode must shorten every value: modes 0 and 1 both have six characters in this example.

The simplified forms are the product’s documented output conventions. A reader expecting classical Roman numerals may not recognize IM, so choose the mode according to the report’s audience and specification.

Enter positive section numbers 4, 9 and 42 in H2:H4. In I2 use:

="Section "&ROMAN(H2;0)

Fill down. Expected labels are Section IV, Section IX and Section XLII. Keep H numeric and use it as the sort key if the report needs numeric section order.

The visible labels are not a replacement for that key. For example, the alphabetical comparison of IX and V is not the same as the numeric comparison of nine and five.

The documented =ROMAN(0) result is empty text, not the character zero and not a proof that a cell is physically empty. For a report that needs an explicit zero label, use:

=IF(K2=0;"0";ROMAN(K2;0))

With K2 containing numeric zero, the expected result is the text 0. With K2 containing four, the expected result is IV. IF makes this display policy explicit.

This is a selection rule, not a claim about whether every branch is evaluated internally. Keep K2 within the documented integer range for the nonzero controls.

Use =LEN(F2) beside the mode table to check lengths 6, 6, 4, 4 and 2. LEN counts these plain Latin characters; it does not evaluate the numeral’s numeric meaning.

The dedicated page does not supply a reverse parser or establish aliases with other functions. Original numeric inputs remain the strongest audit trail. Invalid-input outcomes and native rendering were not executed; the 999 mode table and zero behavior are documented controls, while the other examples are independent classical-numeral calculations.

• Collabora Office 26.04: ROMAN.
• Editorial testing standards.

Complete dedicated product documentation reviewed. Outputs are independent decimal, positional, character or type models, or explicit vendor controls; no native Collabora execution. Formulas use English names and semicolon separators. Optional-argument brackets describe syntax and are not typed into working formulas.