ONLYOFFICE Calculation Error Reference
Choose a targeted ONLYOFFICE error investigation with controlled examples and explicit verification limits.
Scope: ONLYOFFICE Spreadsheet Editor English function documentation checked October 21, 2026. The help pages are not pinned to an installed build. Record whether you use free Desktop Editors or a hosted editor, its version and platform; these examples do not certify older builds, mobile editions or desktop/server parity. No application was executed for this reference. Use a disposable workbook; expected results are documentation-based checks, not native observations.
Choose the investigation, not a blanket fallback
These references cover selected documented calculation-error families. They are not a complete catalogue of every failure, file-format issue or version-specific behavior. Read the actual formula before choosing a branch.
- #DIV/0!: diagnose the denominator: A cost-per-unit or other ratio has a zero divisor.
- #VALUE!: distinguish conversion from search: A text amount cannot be converted, or a substring is absent.
- #NUM!: inspect the numeric domain: A real square root receives a negative input.
Capture enough evidence to verify a repair
Keep the original workbook unchanged. In a separate copy, record the exact error, formula, direct inputs and expected meaning of the result. Test one ordinary input, one boundary and one intentionally invalid input. A displayed number is not proof that a repaired formula references the correct data.
The worked exercises use harmless synthetic values. Their expectations are not screenshots or fresh execution results. Check the scope on each reference before applying it to your installed build, and do not extend a documented example into a claim about every platform.
An error handler is a reporting decision, not a diagnosis. A zero fallback can conceal an unavailable amount or broken dependency. Keep exceptional records visible until their cause and intended treatment are understood.
For symptoms other than these selected errors, start with general troubleshooting. For a particular function’s complete arguments, use the function guides.