Compare Spreadsheet Functions Across Eight Programs
Looking for a function such as COUNTIFS, XLOOKUP, REGEXP, or SORT in an alternative spreadsheet program? Search the available function guides by name and compare which ones we’ve documented across eight software libraries.
The grid below updates from the actual published Hugo function pages at every site build. It includes direct links to the relevant software-specific guides, their cited official references where available, and editorial verification status.
Search published function guides
Loading documented functions…
| Function | LibreOffice | OpenOffice | Gnumeric | Calligra | PlanMaker | ONLYOFFICE | Numbers | Zoho |
|---|---|---|---|---|---|---|---|---|
| Enable JavaScript to filter the comparison table. You can still use each software's A–Z directory. | ||||||||
A link means a guide is published here—not that a function is native-tested. Empty coverage does not mean the function is unavailable in that application. Results show up to 40 names at a time; refine your search to see more.
Important differences you should know
| Task | Calligra Sheets | PlanMaker 2026 | Important distinction |
|---|---|---|---|
| Match text with a regular expression | REGEXP | Check the PlanMaker function reference | Calligra REGEXP extracts the matching substring. Do not assume another application’s REGEX function has the same parameters. |
| Replace numbers in a string | REGEXPRE | Check the PlanMaker function reference | Calligra uses the separate REGEXPRE function for replacement, unlike its extraction function. |
| Look up a product price | VLOOKUP | XLOOKUP | Calligra VLOOKUP defaults to sorted/approximate mode; set FALSE for an exact match on an unsorted table. PlanMaker XLOOKUP defaults to exact matching. |
| Count rows meeting two conditions | Not yet covered in this library | COUNTIFS | A missing Calligra guide is not proof that Calligra lacks COUNTIFS. Check your installed version and KDE’s reference. |
| Sort data with a formula | Consult the Calligra functions manual | SORTM or SORT | PlanMaker SORTM has its own array-entry and file-compatibility considerations; SORT returns a dynamic sorted output. |
We deliberately report coverage of our guides, not a certified vendor-by-vendor support matrix. “Not researched here” means we have not published a suitable guide; it does not mean “unsupported.”
How to read the results
A Guide available result links to an article on this site; it is not a declaration that all versions of that spreadsheet support every argument shown. A Not researched here result means no corresponding published guide exists yet. Native formula testing is explicitly identified separately from documentation checks. This distinction matters most for advanced array, regex, and database functions.
For real workbooks, also consider argument separators, matching defaults, spill behavior, file-format conversion, and version-specific additions. Our editorial testing standards explain what documentation-checked versus application-tested means.