LibreOffice Calc Features
Choose a category below to find a practical feature tutorial. This reference covers the accepted guides listed here, not every feature supported by this program.
Ranges and names
Data management
Sort Whole Records and Filter a Data Range in LibreOffice CalcSort complete Calc records by two keys, use AutoFilter and an AND filter, and reconcile visible totals without losing row identity.Filter with an AND or OR Criteria Range in LibreOffice CalcBuild an Advanced Filter criteria block, copy matching records into a separate area, and reconcile exact IDs after changing AND and OR conditions.Import an XML Record Snapshot with Mapped Cells in LibreOffice CalcMap repeated XML records into Calc, check the extra header row and numeric totals, and distinguish a one-time snapshot from a refreshable link.Open JSON and Tabular XML Directly in LibreOffice CalcOpen small JSON and XML record files, verify fields and numeric types, and choose direct import rather than manual XML Source mapping.
Charts and visualization
Create a Column or Line Chart and Maintain Its Source in LibreOffice CalcCreate a four-month Orders chart in Calc, verify category and series ranges, extend it to May, and compare column and line views. Add a nonadjacent Planned series and display a chart data table.Compare mixed-scale series with a combination chartA worked Calc example to compare mixed-scale series with a combination chart, with source checks, changed inputs and recovery.Create and interpret chart trendlines and error barsA worked Calc example to create and interpret chart trendlines and error bars, with source checks, changed inputs and recovery.Create pivot charts linked to pivot summariesA worked Calc example to create pivot charts linked to pivot summaries, with source checks, changed inputs and recovery.Use bubble, net or stock charts for appropriate dataA worked Calc example to use bubble, net or stock charts for appropriate data, with source checks, changed inputs and recovery.Create and Compare Grouped Sparklines in LibreOffice CalcCreate one in-cell chart per data row, share a meaningful vertical scale, and test blank and hidden values without changing the source data.Create and Check a QR Code in a LibreOffice Calc ReportGenerate a Calc QR code from harmless practice text, distinguish its stored payload from a cell formula, and verify edits before printing or sharing.Construct a Box Plot with Min–Max Whiskers in LibreOffice CalcBuild a positive-data box plot from stacked columns and cell-range error bars, with an explicit quartile method and independently checked endpoints.
Cell formatting and layout
Make Long Labels Readable in LibreOffice CalcMake a readable Calc task table with wrapping, restrained borders and consistent alignment, then test added rows and whole-record sorting.Embed, Link and Anchor Worksheet Images in LibreOffice CalcKeep a worksheet photo with its record, choose embedded or linked storage, and check image proportions, sharing and printed output.
Number, date and currency formatting
Collaboration and review
File compatibility
Data entry and editing
Fill Date Series and Custom Lists in LibreOffice CalcGenerate weekly dates, control sequence endpoints, repeat a custom workflow list and distinguish a filled value series from copied formulas in Calc.Paste Values, Formats and Transposed Data in LibreOffice CalcUse Calc Paste Special to freeze formula results, copy formatting without replacing formulas, and transpose a clear block with an auditable destination.Find and Replace Within Selected Cells in LibreOffice CalcReplace exact text in a selected Calc range, protect formulas and other sheets, verify changed cells, and recover from a deliberately wrong search scope.Fill Reproducible Random Test Data in LibreOffice CalcUse Calc's seeded random-fill tool to create a fixed test fixture, compare a repeat run, and check bounds without inventing a guaranteed sequence.Link a Checkbox to a Model Input in LibreOffice CalcConnect a form checkbox to a dedicated Boolean cell, use it in a calculation, and diagnose design mode, text reference values and broken links.Validate Row-Specific Quantities with a Custom Rule in LibreOffice CalcUse a relative Custom validity formula to limit each quantity to its row's capacity, then audit existing values when the limits change.Apply Paste Special Arithmetic Safely in LibreOffice CalcApply matched numeric adjustments with Calc Paste Special, check subtraction and division direction, and prevent blank multipliers from clearing amounts.Control AutoInput and AutoCorrect in LibreOffice CalcSeparate Calc typing suggestions from automatic replacements, test a small replacement rule, and restore settings without losing existing exceptions.Insert, Delete or Clear Cells Safely in LibreOffice CalcCompare clearing a value, shifting a single cell and inserting a whole row with a small Calc record table and dependent-formula checks.
Workbook organization
Organize Calc Worksheets Without Losing Reference ChecksRename, reorder, copy, hide and restore worksheets in LibreOffice Calc, then audit cross-sheet formulas and named ranges with a reversible change test.Edit Matching Cells Across Grouped Sheets in LibreOffice CalcApply a shared label and rate to selected worksheets, protect an excluded sheet, then ungroup and prove subsequent edits remain local.
Navigation
Navigate Distant Cells and Split Views in LibreOffice CalcUse Calc Navigator to jump to sheets, named ranges and chart objects, then compare distant cells with split panes and remove the split safely.Create and Repair Hyperlinks in LibreOffice CalcCreate named text hyperlinks, edit destinations without losing labels, and test relative file links after moving a practice folder.
Styles and templates
Create Reusable Cell and Page Styles in LibreOffice CalcBuild named Calc cell styles and a separate page style, test inheritance and direct-format overrides, and keep report layout changes scoped to one sheet.Create and Reuse a Workbook Template in LibreOffice CalcSave a clean Calc workbook as an OTS template, create independent monthly reports, update the master safely, and reverse an optional default-template change.
Pivot tables and analysis
Data analysis
Create Subtotals and Expandable Outlines in LibreOffice CalcInsert grouped Calc subtotals, inspect outline levels, prevent double-counted grand totals, and safely remove and rebuild summaries after source changes.Consolidate Department Sheets by Matching Labels in LibreOffice CalcCombine differently ordered department tables using Calc row and column labels, reconcile missing labels, and compare a static consolidation with linked output.Run a Chi-Square Independence Check in LibreOffice CalcPrepare an observed count table for Calc's chi-square tool, check expected counts and degrees of freedom, and distinguish independence from goodness of fit.
Analysis and modeling
Build one- and two-variable sensitivity tablesA worked Calc example to build one- and two-variable sensitivity tables, with source checks, changed inputs and recovery.Compare samples with hypothesis-test toolsA worked Calc example to compare samples with hypothesis-test tools, with source checks, changed inputs and recovery.Measure correlation and fit regression modelsA worked Calc example to measure correlation and fit regression models, with source checks, changed inputs and recovery.Optimize a constrained model with Solver in LibreOffice CalcA worked Calc example to optimize a constrained model with Solver, with source checks, changed inputs and recovery.Summarize and sample data with Statistics toolsA worked Calc example to summarize and sample data with Statistics tools, with source checks, changed inputs and recovery.
Pivot analysis
Calculate pivot percentages and running comparisonsA worked Calc example to calculate pivot percentages and running comparisons, with source checks, changed inputs and recovery.Filter pivot fields and drill into summary recordsA worked Calc example to filter pivot fields and drill into summary records, with source checks, changed inputs and recovery.
Workbook workflows
Compare and merge reviewed workbook copiesCompare and merge reviewed workbook copies. A controlled example with expected outcomes, changed-input checks and recovery.Smooth time series and inspect frequency contentA worked Calc example to smooth time series and inspect frequency content, with source checks, changed inputs and recovery.
What-if analysis
Compare Saved Scenarios in LibreOffice CalcA worked Calc example to compare saved scenarios, with source checks, changed inputs and recovery.Find a Required Input with Goal Seek in LibreOffice CalcA worked Calc example to solve a single target with Goal Seek, with source checks, changed inputs and recovery.
References and calculation
Control recalculation and diagnose circular referencesControl recalculation and diagnose circular references. A controlled example with expected outcomes, changed-input checks and recovery.Create editable array-formula results safelyCreate editable array-formula results safely. A controlled example with expected outcomes, changed-input checks and recovery.Insert and refresh a linked external data tableInsert and refresh a linked external data table. A controlled example with expected outcomes, changed-input checks and recovery.Link external workbooks and manage update promptsLink external workbooks and manage update prompts. A controlled example with expected outcomes, changed-input checks and recovery.Link spreadsheet results into other office documentsLink spreadsheet results into other office documents. A controlled example with expected outcomes, changed-input checks and recovery.Inspect Nested Formulas with Calc's Function WizardBuild a small IF formula, inspect its SUM argument and boundary result, and distinguish the Function Wizard from the sidebar Functions deck.
Formulas and analysis
Create a document-owned Basic custom functionCreate a document-owned Basic custom function. A controlled example with expected outcomes, changed-input checks and recovery.Record and replay a document-owned macro in LibreOffice CalcRecord and replay a document-owned macro. A controlled example with expected outcomes, changed-input checks and recovery.
Sharing, safety and accessibility
Improve spreadsheet readability and keyboard navigationImprove spreadsheet readability and keyboard navigation. A controlled example with expected outcomes, changed-input checks and recovery.Recover earlier document versions and protect file accessPractice recovery of stored Calc versions, protect an ODS copy with an opening password, and inspect Description and Custom Properties before a document handoff.Use shared-file editing and resolve save conflictsUse shared-file editing and resolve save conflicts. A controlled example with expected outcomes, changed-input checks and recovery.
Automation and productivity
Customize and Restore a Calc Toolbar and Keyboard WorkflowCustomize toolbars, shortcuts and interface variants. A controlled example with expected outcomes, changed-input checks and recovery.Choose a Calc scripting language and understand ScriptForgeDistinguish Calc scripting languages, ScriptForge services and UNO objects using a read-only example with explicit runtime and testing limits.
Data preparation
Enter and correct records with Data FormEnter and correct records with Data Form. A controlled example with expected outcomes, changed-input checks and recovery.Import and refresh a registered Base sourceImport and refresh a registered Base source. A controlled example with expected outcomes, changed-input checks and recovery.Preview Data Provider transformations in LibreOffice CalcPrepare a local CSV Data Provider import, check transformation order and distinguish a documented refresh command from verified refresh behavior.