FILTER Function in ONLYOFFICE Spreadsheet Editor: Examples and Syntax
FILTER in ONLYOFFICE Spreadsheet Editor: show only in-stock inventory using practical sample data, clear expected results, pitfalls and the official function documentation.
Reference checked: Examples have not been run in this spreadsheet application. How we verify guides
Quick answer: Show only in-stock inventory. A stock list includes items that cannot currently be sold. FILTER can return only the rows with positive quantities while preserving the two-column relationship.
This page covers the ONLYOFFICE Spreadsheet Editor implementation specifically. Its example values and expected results are original educational data, not screenshots or claims of a live application test.
Syntax and argument order
=FILTER(array, include, [if_empty])
The argument order above follows the official ONLYOFFICE Spreadsheet Editor documentation. Use the function name shown here, and replace placeholder arguments with ranges, cell references or criteria from your workbook.
Worked example with sample data
| Row | A: Item | B: Quantity |
|---|---|---|
| 2 | Tape | 5 |
| 3 | Clips | 0 |
| 4 | Pads | 7 |
| 5 | Pens | 2 |
Enter this formula in a free result cell (outside the input range):
=FILTER(A2:B5,B2:B5>0,"No stock")
Expected result: Tape / 5; Pads / 7; Pens / 2.
Why this result is correct: The Boolean test produces TRUE for quantities 5, 7 and 2. The zero-quantity row is excluded, and the returned result is an array rather than a single number.
A second example or variation
=FILTER(A2:B5,B2:B5>10,"No stock")
Expected result: No stock.
No quantity exceeds ten, so the optional fallback message is used.
Common mistakes and troubleshooting
Choose an output area with enough free cells for a potentially spilled array. Do not confuse a dynamic FILTER formula with the manual filter command in the toolbar.
Also check that the version of ONLYOFFICE Spreadsheet Editor you use supports this function. A formula pasted from another application can fail because of different syntax, date interpretation, array behavior or regional separators. If the result differs, first compare the small dataset above with the expected answer before substituting your real data.
Where this function helps
A stock list includes items that cannot currently be sold. FILTER can return only the rows with positive quantities while preserving the two-column relationship. Replacing the sample cells with your own ranges lets you reuse the same reasoning. On important spreadsheets, test with a few known rows, verify the final cell formatting and keep a separate copy of the source data.
Practical checks before reusing this formula
A FILTER result can occupy multiple output cells. Leave an empty output area rather than pasting it into a populated part of a worksheet, and check what happens when no rows satisfy the condition.
Verify the include array follows the source rows and that its booleans reflect the intended filter. A swapped operator changes the result set.
To compare this function with other spreadsheet programs, use our eight-software function comparison. A missing guide does not mean a function is unsupported in another product; check its official documentation.
Official reference and verification
- Official ONLYOFFICE Spreadsheet Editor — FILTER reference
- Verification status: Official documentation checked; example outcome independently reasoned or arithmetically checked where applicable. Not executed in ONLYOFFICE Spreadsheet Editor.
- No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.