Browse

Practical guides for alternative spreadsheets

Find the spreadsheet answer you need

Working formulas, troubleshooting and data-analysis tutorials for LibreOffice Calc, Gnumeric, OpenOffice, Calligra Sheets, PlanMaker, ONLYOFFICE, Apple Numbers and Zoho Sheet.

Choose your spreadsheet software

LibreOffice Calc

Functions, practical tutorials and troubleshooting.

Gnumeric

Scientific formulas, numerical tools and statistics.

OpenOffice Calc

Classic Calc functions and spreadsheet reference.

Calligra Sheets

Functions, regex text processing and KDE workflows.

PlanMaker 2026

Functions, dynamic arrays, pivot tables and data cleanup.

ONLYOFFICE

Dynamic arrays, criteria and database functions.

Apple Numbers

Table-aware lookups, text tools and conditional formulas.

Zoho Sheet

Cloud workbooks, ranking and linked data functions.

Compare function guides across eight programs

Find a function such as COUNTIFS or REGEXP, open the relevant software-specific guide, and see what has actually been tested versus merely documented.

Open the function comparison tool →

Solve common spreadsheet problems

Browse solutions by task →
CSV opens in one columnChoose the correct separator and import fields reliably. Leading zeros disappearPreserve product codes, ZIP codes and identifiers. COUNTIF returns zeroFind hidden spaces, criteria mismatches and data-type issues. Count between datesUse date boundaries to count rows accurately.

Popular function guides

Full LibreOffice A–Z →
SUM in LibreOffice CalcThe SUM function in LibreOffice Calc adds numbers, cell ranges, or mixed arguments. Learn syntax, examples, common errors, and … COUNTIF in LibreOffice CalcThe COUNTIF function in LibreOffice Calc counts cells that meet a single condition. This guide explains syntax, operators, … COUNTIFS in LibreOffice CalcThe COUNTIFS function in LibreOffice Calc counts cells that meet multiple conditions across one or more ranges. This guide … VLOOKUP in LibreOffice CalcLearn the VLOOKUP function in LibreOffice Calc: Vertical search and reference to indicated cells. MID in LibreOffice CalcThe MID function in LibreOffice Calc extracts a substring from the middle of a text string, starting at a specified position and … REGEX in LibreOffice CalcUse REGEX in LibreOffice Calc to extract matched text, replace patterns, remove characters, and work with regular expressions.
More function libraries: OpenOffice A–Z Gnumeric A–Z

Specialist analysis and alternative tools

Gnumeric analysis

Learn regression, scientific techniques and optimization with reproducible datasets.

Browse Gnumeric tutorials →

Calligra Sheets

Practical techniques for the KDE spreadsheet application.

Browse Calligra lessons →

PlanMaker 2026

Learn data import, cleaning and analysis in PlanMaker.

Browse PlanMaker lessons →

Advanced LibreOffice functions

Explore all functions →
FILTERAn explanation of LibreOffice Calc FILTER, including tested formulas, examples, expected results and common mistakes. SORTAn explanation of LibreOffice Calc SORT, including tested formulas, examples, expected results and common mistakes. LETAn explanation of LibreOffice Calc LET, including tested formulas, examples, expected results and common mistakes. XLOOKUPLearn the XLOOKUP function in LibreOffice Calc: Extended vertical search and reference to indicated cells.