FLOOR.XCL in Collabora Office: Use Legacy Excel-Compatible Floor Rules

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Complete function-specific documentation and independent arithmetic controls; no native Collabora test was performed.

=FLOOR.XCL(number;significance)

Both arguments are required; there is no mode argument. The documented sign combinations are:

The section does not establish a precise error label for the invalid combination. Examples use English function names with semicolon separators.

=FLOOR.XCL(22;6)
=FLOOR.XCL(-22;6)
=FLOOR.XCL(-22;-6)

Expected numeric results are 18, -24 and -18. The positive-input, negative-step formula =FLOOR.XCL(22;-6) is a documented error case.

Unlike FLOOR.MATH, XCL does not simply ignore the significance sign. That difference is essential when diagnosing an imported formula.

For a magnitude of 24 and a step magnitude of six:

=FLOOR.XCL(24;6)
=FLOOR.XCL(-24;6)
=FLOOR.XCL(-24;-6)

Expected results are 24, -24 and -24. All inputs already lie on the allowed grid. A test containing only these values would miss the policy difference visible at -22.

Include at least one nonmultiple on each side of zero in a migration checklist.

Enter -31, -25 and -19 in A2:A4:

=FLOOR.XCL(A2;6)
=FLOOR.XCL(A2;-6)

Expected positive-step outputs are -36, -30 and -24. Negative-step outputs are -30, -24 and -18. The former move away from zero, the latter toward zero.

Neither column is nearest-multiple rounding in general. For -31, -30 is closer, but the positive-step FLOOR.XCL rule still produces -36.

Two independent quantities are 11 and 11, and only groups of six may be used:

=FLOOR.XCL(11;6)+FLOOR.XCL(11;6)
=FLOOR.XCL(11+11;6)

Expected usable totals are 12 and 18. Separate processing gives two complete groups; pooled processing gives three. The correct formula depends on whether the underlying quantities may be combined.

This is a positive-domain capacity model. Negative examples above are separate signed-arithmetic controls, not a claim that negative inventory represents a valid physical batch.

Collabora’s help describes FLOOR.XCL as an interoperability function for Excel 2007 or older. It says exported FLOOR.XCL references become Excel FLOOR, while imported Excel FLOOR references become Collabora FLOOR.XCL.

That mapping is documentation evidence, not an executed export/import test here. XCL remains documented in Collabora Office 26.04; the legacy target does not make the function retired.

Do not omit significance based on the optional argument of another FLOOR variant. Zero-step behavior, text/Boolean conversion, exact native errors and extreme-value precision remain unverified. Preserve the original formula and a small signed control table when evaluating a real migration.

• Collabora Office 26.04: FLOOR.XCL.
• Editorial testing standards.

The complete function section was reviewed. Worked results are independently checked expectations; native execution and unlisted edge cases remain unverified.