Absolute and Relative Cell References in LibreOffice Calc
Understand A1, $A$1, A$1 and $A1 in LibreOffice Calc. Copy formulas safely and lock the right parts of a reference.
LibreOffice Calc learning centre
89 practical tutorials. Start with the ordered route, or browse every lesson by task and learning stage.
Learn how to solve specific Calc problems with worked examples, small practice datasets, and clear procedures. Each guide states what was checked in documentation or tested in the application. Start with CSV import issues, then explore formulas and data-cleanup workflows. These lessons complement the LibreOffice function A–Z directory.
New to the software? Begin with CSV files opening in one column or COUNTIF returning zero. Each tutorial links to the relevant official help documentation.
Suggested first steps
Use Calc desktop and work on copies of your files. Know how to select a cell and enter a value. Each lesson uses a separate example; version-specific menus and verification limits are stated below.
This is a short route through existing guides, not a complete course or a claim that every procedure was application-tested.
Enter and format a readable task table.
Calc desktop standard menus; Guide 26.2 and Help 26.8; native workflow/save-reopen unverified.
Distinguish stored numbers from currency, dates and duration displays.
Guide 26.2 and Help 26.8; English USA output conventions; documentation/arithmetic only, no native display or persistence test.
Copy a formula while retaining a shared rate.
Calc Help documentation; installed version/OS/locale may differ; no exact runtime established by this page.
Preserve complete order records and reconcile filtered totals.
Guide 26.2 and Help 26.8 desktop standard menus; native UI/save-reopen untested.
Check a bounded, readable exported report.
Page claims LibreOffice Community Calc 26.8.1.1 Linux en-US native one-page PDF test; provenance must be revalidated before surfacing a tested badge. Do not conflate with unrelated LibreOfficeDev 26.8 alpha tests or certify stable-channel availability.
Learning stages use the guide’s own difficulty label. Edition/platform filtering is classified only for the reviewed route above; other lessons remain unclassified, not unsupported. Read each guide’s version notes.
Understand A1, $A$1, A$1 and $A1 in LibreOffice Calc. Copy formulas safely and lock the right parts of a reference.
Separate Calc typing suggestions from automatic replacements, test a small replacement rule, and restore settings without losing existing exceptions.
Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8
Create 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.
Build a Calc status drop-down from a separate sheet, name its source range, add another option, and check invalid entries.
Generate a Calc QR code from harmless practice text, distinguish its stored payload from a cell formula, and verify edits before printing or sharing.
Create named text hyperlinks, edit destinations without losing labels, and test relative file links after moving a practice folder.
Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8
Save a clean Calc workbook as an OTS template, create independent monthly reports, update the master safely, and reverse an optional default-template change.
Build named Calc cell styles and a separate page style, test inheritance and direct-format overrides, and keep report layout changes scoped to one sheet.
Keep a worksheet photo with its record, choose embedded or linked storage, and check image proportions, sharing and printed output.
Generate weekly dates, control sequence endpoints, repeat a custom workflow list and distinguish a filled value series from copied formulas in Calc.
Replace exact text in a selected Calc range, protect formulas and other sheets, verify changed cells, and recover from a deliberately wrong search scope.
Define a Calc print range, choose landscape paper, control width and height scaling, and check the actual PDF before sharing it.
Choose the right CSV delimiter in LibreOffice Calc, fix files opening in one column, and check quoted commas before importing.
Repair garbled UTF-8 CSV text in LibreOffice Calc. Choose the proper character encoding and confirm accented text during import.
Fix LibreOffice Calc Err:509 using examples of missing multiplication operators and malformed arithmetic formulas.
Convert text numbers into values LibreOffice Calc can calculate using VALUE and ISNUMBER, while preserving codes with leading zeros.
Format currency, percentages, dates and durations in Calc while checking the stored numbers, locale, and precision settings.
Keep your header row visible while scrolling in LibreOffice Calc using Freeze Rows and Columns, with troubleshooting and print-header tips.
Use a formula-based conditional format to color every cell in a Calc task row, with the status column fixed and each row checked separately.
Compare clearing a value, shifting a single cell and inserting a whole row with a small Calc record table and dependent-formula checks.
Build a small IF formula, inspect its SUM argument and boundary result, and distinguish the Function Wizard from the sidebar Functions deck.
Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8
Preserve exact product codes in LibreOffice Calc by importing or pasting them as text, then check their type, length and characters before sharing.
Make a readable Calc task table with wrapping, restrained borders and consistent alignment, then test added rows and whole-record sorting.
Use Calc Navigator to jump to sheets, named ranges and chart objects, then compare distant cells with split panes and remove the split safely.
Build a two-area Calc template, unlock its quantity inputs, protect formula cells, and test editing and recalculation before sharing.
Remove duplicate values in LibreOffice Calc with Standard Filter, No duplications and a copy-to destination. Review duplicate rows with Data > Duplicates in 26.2.
LibreOffice Calc 26.2 English desktop documentation; latest Help labelled 26.8 checked separately; no exact-build or cross-platform execution claim
Sort complete Calc records by two keys, use AutoFilter and an AND filter, and reconcile visible totals without losing row identity.
Split names, IDs and delimited values into columns using LibreOffice Calc Text to Columns, without overwriting important data.
Prevent codes such as 03-04 from turning into dates when importing CSV into LibreOffice Calc, without losing the original text.
Use Calc Detective to follow a wrong total through formulas to its source, distinguish wrong inputs from formula errors, and verify a correction.
Apply matched numeric adjustments with Calc Paste Special, check subtraction and division direction, and prevent blank multipliers from clearing amounts.
A worked Calc example to build one- and two-variable sensitivity tables, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
A worked Calc example to calculate pivot percentages and running comparisons, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Keep an ODS master, build a small compatibility control workbook, and reconcile formulas, dates, names, charts and validation in an XLSX exchange copy.
Distinguish Calc scripting languages, ScriptForge services and UNO objects using a read-only example with explicit runtime and testing limits.
Free LibreOffice Calc desktop; Calc Guide 26.2, English Windows/Linux menus; ScriptForge API examples from Help labelled 26.8; documentation-qualified, not native tested
Compare and merge reviewed workbook copies. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
A worked Calc example to compare mixed-scale series with a combination chart, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
A worked Calc example to compare samples with hypothesis-test tools, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
A worked Calc example to compare saved scenarios, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Compare fictional offers using pack sizes, minimum quantities, shipping and changed-demand checks.
Combine differently ordered department tables using Calc row and column labels, reconcile missing labels, and compare a static consolidation with linked output.
Control recalculation and diagnose circular references. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Use COUNTIFS and DATE in LibreOffice Calc to count dates in a range, including dates with times and full calendar months.
Create a document-owned Basic custom function. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested
Create one in-cell chart per data row, share a meaningful vertical scale, and test blank and hidden values without changing the source data.
A worked Calc example to create and interpret chart trendlines and error bars, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Define scoped formula names and database record ranges in Calc, extend each explicitly, and verify totals and retained sort settings. Compare #Data, #Totals and #All selectors without double-counting.
Create editable array-formula results safely. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
A worked Calc example to create pivot charts linked to pivot summaries, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Insert grouped Calc subtotals, inspect outline levels, prevent double-counted grand totals, and safely remove and rebuild summaries after source changes.
Customize toolbars, shortcuts and interface variants. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Apply a shared label and rate to selected worksheets, protect an excluded sheet, then ungroup and prove subsequent edits remain local.
Enter and correct records with Data Form. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested
Extract invoice IDs and numeric values from mixed text using the LibreOffice Calc REGEX function, including handling no-match cases.
Use Calc's seeded random-fill tool to create a fixed test fixture, compare a repeat run, and check bounds without inventing a guaranteed sequence.
A worked Calc example to filter pivot fields and drill into summary records, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Build an Advanced Filter criteria block, copy matching records into a separate area, and reconcile exact IDs after changing AND and OR conditions.
A worked Calc example to solve a single target with Goal Seek, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Build a small Calc pivot table, reproduce a missing appended row, expand its source range, refresh it, and reconcile the totals.
Diagnose mixed text and numeric dates, convert ISO date text safely, sort whole records, and reconcile the result without losing the source values.
Understand LibreOffice Calc Err:502 and fix invalid function arguments, including mismatched COUNTIFS range sizes with tested examples.
Track dated cash movements, expose a temporary shortfall and audit the opening balance instead of trusting a positive ending total.
Group real dates by year and month and numeric values into tested bands in Calc pivots, reconcile boundary records, and refresh after changing a source value.
Map repeated XML records into Calc, check the extra header row and numeric totals, and distinguish a one-time snapshot from a refreshable link.
Import and refresh a registered Base source. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested
Improve spreadsheet readability and keyboard navigation. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Insert and refresh a linked external data table. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Fix COUNTIF returning zero despite matching cells in LibreOffice Calc. Check ranges, types, criteria, spaces and wildcard settings.
Connect a form checkbox to a dedicated Boolean cell, use it in a calculation, and diagnose design mode, text reference values and broken links.
Link external workbooks and manage update prompts. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Link spreadsheet results into other office documents. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
A worked Calc example to measure correlation and fit regression models, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Open small JSON and XML record files, verify fields and numeric types, and choose direct import rather than manual XML Source mapping.
A worked Calc example to optimize a constrained model with Solver, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Rename, reorder, copy, hide and restore worksheets in LibreOffice Calc, then audit cross-sheet formulas and named ranges with a reversible change test.
Use Calc Paste Special to freeze formula results, copy formatting without replacing formulas, and transpose a clear block with an auditable destination.
Prepare a local CSV Data Provider import, check transformation order and distinguish a documented refresh command from verified refresh behavior.
Free LibreOffice Calc desktop; Calc Guide 26.2, English Windows/Linux menus; supplemental online Help labelled 26.8; documentation-qualified, not native tested
Record and replay a document-owned macro. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested
Practice recovery of stored Calc versions, protect an ODS copy with an opening password, and inspect Description and Custom Properties before a document handoff.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Add a Calc cell comment, record two controlled edits, accept one and reject the other, and verify the final values after reopening.
Prepare an observed count table for Calc's chi-square tool, check expected counts and degrees of freedom, and distinguish independence from goodness of fit.
LibreOffice Calc 26.2 desktop, English menus; source-reviewed workflow, native execution unverified
A worked Calc example to smooth time series and inspect frequency content, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
A worked Calc example to summarize and sample data with Statistics tools, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Separate argument separators, decimal marks and sheet-reference syntax in Calc, then diagnose a pasted or imported Excel formula with a small control example.
A worked Calc example to use bubble, net or stock charts for appropriate data, with source checks, changed inputs and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified
Create a Calc XY scatter chart with numeric date X-values, format the axis as dates, and verify that irregular time gaps have proportional spacing.
Use shared-file editing and resolve save conflicts. A controlled example with expected outcomes, changed-input checks and recovery.
LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested
Use a relative Custom validity formula to limit each quantity to its row's capacity, then audit existing values when the limits change.
Build a positive-data box plot from stacked columns and cell-range error bars, with an explicit quartile method and independently checked endpoints.
LibreOffice Calc 26.2 desktop, English menus; source-reviewed workflow, native execution unverified
No tutorials match these filters. Clear filters to show every lesson.