Apache OpenOffice Calc learning centre

Apache OpenOffice Calc Practical Tutorials

Choose a practical Apache OpenOffice Calc task below. Check the guide’s version, prerequisites and verification notes before following the steps.

For individual formulas, browse the Apache OpenOffice Calc function directory.

10 practical tutorials

Data cleanup

Review Duplicate Rows without Deleting OpenOffice Calc DataMark matching records with case-sensitive helper formulas in Apache OpenOffice Calc, distinguish duplicate groups from later copies and preserve originals.Intermediate · Apache OpenOffice Calc

Data entry and validation

Create a Drop-Down from Another Sheet in OpenOffice CalcBuild a named-range dropdown with Data Validity in Apache OpenOffice Calc, reject invalid typing and update the source list safely.Beginner · Apache OpenOffice Calc

Data management

Sort Whole Records Safely in OpenOffice CalcSort a complete labeled table in Apache OpenOffice Calc without separating related columns, then verify records and filter the results.Beginner · Apache OpenOffice Calc

Formula troubleshooting

Fix Formula Text Instead of Results in OpenOffice CalcDiagnose formula display mode, text-formatted cells and leading apostrophes in Apache OpenOffice Calc, with a small repair test.Beginner · Apache OpenOffice Calc

Freeze panes and navigation

Freeze Heading Rows and Identifier Columns in OpenOffice CalcKeep heading rows and identifier columns visible together using Window Freeze in Apache OpenOffice Calc, with boundary and scrolling checks.Beginner · Apache OpenOffice Calc

Import and data cleanup

Import Semicolon CSV with Decimal Commas in OpenOffice CalcImport semicolon-delimited UTF-8 data with decimal commas, preserve identifiers as text and verify numeric totals in OpenOffice Calc.Beginner · Apache OpenOffice Calc

Number, date and currency formatting

Preserve Product IDs and Format Values in OpenOffice CalcKeep long product identifiers and leading zeros as text, and distinguish number display from stored values in Apache OpenOffice Calc.Beginner · Apache OpenOffice Calc

Pivot tables and analysis

Count Records by Month with OpenOffice Calc Pivot TablesCreate a monthly record count in Apache OpenOffice Calc, group dates by years and months, refresh the source and verify a sales-summary benchmark.Intermediate · Apache OpenOffice Calc

Printing and PDF output

Repeat Printed Headings and Check PDF Output in OpenOffice CalcRepeat heading rows on every printed page in Apache OpenOffice Calc, define the print range and verify a multipage PDF.Beginner · Apache OpenOffice Calc

Sheet and cell protection

Protect Formulas but Allow Inputs in OpenOffice CalcUnlock input cells, retain protected formula cells and enforce sheet protection in Apache OpenOffice Calc with a two-row calculation test.Beginner · Apache OpenOffice Calc