CONVERT Function in ONLYOFFICE Spreadsheet Editor: Units, Prefixes and Practical Examples

=CONVERT(number, from_unit, to_unit)

All three arguments are required. Tokens for unrelated dimensions cannot be converted (for example, meters to seconds). The official help explicitly says the two units must belong to the same measurement type. It does not specify a universal exact error string for every invalid token or out-of-family combination, so those remain editor test cases.

The full official table also lists pressure, force, power, magnetism, and less common engineering units; see the source’s complete unit and prefix registry instead of assuming an unlisted spelling is recognized.

ONLYOFFICE documents decimal prefixes including k = 10³, c = 10⁻², m = 10⁻³, and M = 10⁶; "km", "cm", "kg" and "mg" are constructed from prefix + permitted base token. Binary prefixes include ki = 2¹⁰, Mi = 2²⁰ and Gi = 2³⁰. Not every prefix/unit combination has been tested in a running editor, and the official reference is the authority on recognized base tokens. Do not interchange "M" and "m" or assume capital "K" means kilo: "K" is listed as Kelvin.

1. Create a new blank ONLYOFFICE Spreadsheet Editor workbook. In A1:D1, type Value, From unit, To unit, Result.
2. Enter the numeric inputs in column A and the literal unit tokens (without including quote characters in the cell) in B and C as shown below. Example: B2 should contain mi, not "mi".
3. Enter =CONVERT(A2,B2,C2) in D2, and copy the formula down to D15. The directly entered hard-coded equivalents are shown for audit.
4. Compare the spreadsheet results with the independent expected values, allowing ordinary floating-point rounding or displayed-decimal differences. Any actual discrepancy must be recorded as a native test finding.

All outputs above are independent conversion expectations, not values seen in ONLYOFFICE. Fractional decimals are shown to approximately 10–12 significant digits; native precision and rendering must be checked. To test a direct literal formula, for example enter =CONVERT(1,"mi","m") in a separate blank cell; its independent mathematical expectation is 1609.344.

Change both unit tokens without rewriting formulas. Store user-supplied numeric amounts in A, input units in B and desired units in C, then use =CONVERT(A2,B2,C2) in D. Copy D down. This helps avoid repeated manual multiplication by hard-coded constants. A controlled list of official tokens in B/C lowers typo risk; validation-list UI behaviour is separate from CONVERT and was not tested.

Temperature is not simple scaling. To interpret Celsius and Fahrenheit, use documented "C" and "F" rather than multiplying Celsius by 1.8 alone; the freezing-point example requires a +32 offset. The independent calculation is C = (F − 32) × 5/9.

Validate inputs before relying on them. Add a separate flag cell such as =IF(A2="","Missing amount","Check units") for user review before conversion. The IF function’s separate official documentation applies; the flag is illustrative and must be checked in the target version. Because CONVERT does not turn a valid mass unit into a time unit, handle category mismatches intentionally rather than treating the result as a valid measurement.

Distinguish physical conventions. The official tokens intentionally distinguish "gal" (U.S. gallon) and "uk_gal" (U.K. gallon), as well as "mi" and "Nmi". For regulated, billing, laboratory or safety-critical applications, confirm the applicable reference standard and measurement tolerance before adopting spreadsheet conversions.

No maximum accepted magnitude, exact floating-point implementation, or version-specific prefix matrix is established by the cited help page; such limits must remain unverified instead of being guessed.

• CONVERT official unit and prefix table — syntax and admissible tokens.
• IF — use the catalogue to locate the official IF entry before extending validation patterns.
• Inserting functions — function picker and syntax conventions.
• Advanced settings — region, formula language and numeric separators.

This guide is based on the current, unversioned English ONLYOFFICE help pages on 2026-10-13 (UTC) and independent numerical reasoning. The sample values below are expected values, not results observed in a running ONLYOFFICE Spreadsheet Editor. No screenshot, workbook execution, web edition test, Desktop edition test, or historic version support test was performed. Use the official function catalogue.

Edition and compatibility: ONLYOFFICE’s documentation describes the current Docs Spreadsheet Editor; its Desktop changelog and Docs changelog are distinct records. None of the cited function pages establishes a first-supported Desktop or web version for this function; do not infer universal historical compatibility or claim that an XLSX exported to another spreadsheet program evaluates identically. Where a function returns an array, the current ONLYOFFICE array-entry guide explicitly describes selecting the complete output range, entering the formula and pressing Ctrl+Shift+Enter. Do not manually type the surrounding { }. In some editions, dynamic-array behaviour may differ and must be tested.

Formula language and separators: The examples use English names, A1-style references, a decimal point, and commas between arguments. The official function-entry guide shows these conventions. The Advanced Settings guide documents configurable formula language, region and numeric separators; it does not provide a verified translation or formula argument separator for every locale. Change regional settings as appropriate and verify the resulting formula entry in the target edition rather than blindly substituting commas with semicolons.