Collabora Office Calc learning centre

Collabora Office Calc Practical Tutorials

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

For individual formulas, browse the Collabora Office Calc function directory.

10 practical tutorials

CSV import

Import a Semicolon CSV in Collabora Online Without Changing DatesSet the delimiter and preserve date strings and long IDs as text before import; verify the result and avoid irreversible conversion.Beginner · Collabora Office Calc

Collaborative filtering

Filter Collabora Online Without Changing Other Editors’ ViewsUse a personal Sheet View where your Collabora Online deployment supports it, and check isolation with a small two-editor test.Beginner · Collabora Office Calc

Conditional formatting

Highlight Overdue Dates in Collabora Online CalcUse a formula rule with blank, text-date and completed-task guards; test against a fixed reference date before switching to TODAY.Intermediate · Collabora Office Calc

Cross-sheet consolidation

Combine Department Sheets by Matching Labels in Collabora Office CalcConsolidate differently ordered department summaries by row and column labels, with an explicit linked-results test.Intermediate · Collabora Office Calc

Data entry and validation

Create and Maintain a Shared Drop-Down List in Collabora CalcUse Data Validity with a named source range, test invalid entries, and maintain shared choices without assuming paste is blocked.Intermediate · Collabora Office Calc

Data management

Create and Reuse Named Ranges in Collabora Online CalcDefine a readable range name, check its absolute reference and scope, and distinguish it from a database range.Intermediate · Collabora Office Calc

Formula troubleshooting

Fix Err:509 After Pasting a Formula into Collabora CalcDiagnose missing operators first, then check function separators and reference syntax without blindly replacing commas.Beginner · Collabora Office Calc

Pivot tables and analysis

Fix Missing New Rows in a Collabora Online Pivot TableDistinguish refreshing changed values from expanding the pivot source range, using a checkable sales example.Intermediate · Collabora Office Calc

Printing and PDF output

Export Only Selected Cells to PDF in Collabora Online CalcUse the PDF options and a controlled print range, then inspect the PDF for omitted and accidentally included content.Intermediate · Collabora Office Calc

Sheet and cell protection

Protect Formulas and Leave Input Cells Editable in Collabora CalcUnlock the input range before protecting the sheet, then verify formula protection and editable inputs after reopening.Beginner · Collabora Office Calc