Display an Equation Without Confusing It with a Cell Formula in ONLYOFFICE

Quick answer

An inserted equation is a mathematical annotation in its own box. A worksheet formula such as =B2/C2 calculates a result in a cell. Use an equation to explain a calculation, but do not assume typed numbers in the equation track the worksheet inputs.

This guide follows the official equation instructions for a local workbook in the free Desktop Editors. The help is rolling documentation checked on 21 October 2026. No installed version, native rendering, screenshot or save/reopen test was performed. Web, mobile and older-version parity are not established.

Create a live ratio calculation

Start a disposable XLSX workbook named equation-vs-formula.xlsx. Enter:

Cell	Entry
A1	Measure
B1	Actual
C1	Target
D1	Ratio
A2	Practice units
B2	120
C2	80
D2	=B2/C2
A4	Annotation below is manually entered, not a live result

The independently calculated result in D2 is 1.5. Keep C2 nonzero for this exercise. Save before adding an object so the cell-only starting point is recoverable.

Build a fraction annotation

1. Select an empty location such as A6, below the calculation.
2. Open Insert → Equation and choose the Fractions category, then a stacked fraction template.
3. Click its numerator placeholder and type 120; click the denominator placeholder and type 80.
4. Click outside the equation and inspect the whole fraction. Neither placeholder should remain empty.

The vendor describes equation templates as editable placeholders in a movable box. Select the box border to reposition it, rather than selecting its internal text. Leave the input table and the warning in A4 unobscured. Use the report-object arrangement guide if several objects overlap.

This walkthrough deliberately uses the gallery, not a typed LaTeX or linear-expression recipe. Do not infer an input mode from the appearance of a setting in a different release.

Run a stale-annotation test

Change B2 from 120 to 160, leaving C2 at 80. D2 should now calculate 2 because 160 divided by 80 is 2. Inspect the actual formula text in D2: it should still be =B2/C2, not a typed 2.

Now inspect the equation object. You typed its numerator as the literal number 120, so this exercise has not established any connection from that placeholder to B2. Treat a displayed 120/80 as a stale annotation, not evidence that D2 is wrong. Change the numerator yourself to 160 if you want the annotation to describe the revised input. The annotation and the calculated result have different maintenance requirements.

Finally restore B2 to 120 and restore the annotation numerator to 120. Verify D2 returns to 1.5. This paired reset prevents the report from containing a correct calculation alongside a mathematically plausible but outdated explanation.

Edit or remove only the intended object

If you need to correct a number, place the insertion point inside its placeholder. If you want to remove the entire annotation, select the equation’s border and press Delete, as documented in the equation reference. Do this only in the disposable file, then check that B2, C2 and D2 still contain their original inputs and formula. Removing a drawing object is not the same task as clearing the calculation cells.

For a retained version, keep the annotation, save and close the workbook, then reopen it yourself. Check the fraction, the warning label, the formula text and the 1.5 result. If the report will be printed or exported, inspect that output separately for clipping; on-screen placement does not prove that a printed fraction is legible.

Troubleshooting boundaries

• Typing changes a cell instead of the fraction: select the equation and its intended placeholder before entering the replacement value.
• Dragging changes the selection inside the fraction: target the outer box border when you intend to move the whole object.
• The ratio changed but the annotation did not: compare the literal numerator with B2. This guide creates no live link between them.
• A conversion prompt appears for an old equation: stop and preserve a copy. Legacy equation conversion and cross-application fidelity are outside this new-object exercise; do not convert every equation just to follow these steps.

All numerical expectations here were calculated independently. Native insertion, editing, object deletion, reopen persistence and printed appearance remain reader verification steps, not reported test results.