Apache OpenOffice 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.
Conditional formatting
Ranges and names
Charts and visualization
Create and Maintain a Chart in OpenOffice CalcBuild an Apache OpenOffice Calc chart with the Chart Wizard, verify categories and series, and extend its source data.Add trendlines and error bars to a chartAdd a linear fit and explicit measurement-error bars to an XY chart, then test the distinction between trend and uncertainty.Compare values with scatter and combination chartsChoose a numeric X axis for uneven measurements, then build a column-and-line comparison with clearly labeled scales.
Cell formatting and layout
Collaboration and review
Workbook organization
Organize Sheets and Navigate with Navigator in OpenOffice CalcRename, move and copy Apache OpenOffice Calc sheets, check formula dependencies, and navigate to a named range.Build an Internal Navigation Index in OpenOffice CalcCreate document hyperlinks to two local sheets and verify destinations, edits and link removal independently of calculations.
Data management
Extract Unique Records with Standard Filter in OpenOffice CalcExtract unique complete records with Standard Filter, preserve source rows, and verify copied results after edits and range growth.Create an Advanced Filter from a Criteria Range in OpenOffice CalcUse an Apache OpenOffice Calc criteria range for AND and OR filters, copy matching records safely and rerun without stale rows.Copy Filtered Rows Without Moving Hidden Records in OpenOffice CalcCheck copied filter results against row IDs and totals, and distinguish filtering from manually hiding rows before sharing an extract.Use a Registered Base Data Source in OpenOffice CalcRegister a local spreadsheet through Base, select its records in Calc, and check an eight-row sales report without assuming automatic refresh.
Pivot tables and analysis
Data analysis
Create Subtotals and Expandable Outlines in OpenOffice CalcCreate regional subtotals, expand and collapse outline groups, check totals, and rebuild from clean source records.Consolidate Department Sheets by Matching Labels in OpenOffice CalcConsolidate differently ordered department tables by row and column labels, compare linked results, and verify range growth.
What-if analysis
Reach a Target with Goal Seek in OpenOffice CalcSolve a one-variable profit model with Goal Seek, check the target independently, and reject impossible or impractical results.Switch Between What-If Scenarios in OpenOffice CalcStore named price-and-volume assumptions, switch scenarios safely, and avoid overwriting the baseline through Copy back.
Data entry and editing
Fill Series and Custom Lists in OpenOffice CalcCreate a numeric fill series, copy constants and cycle a custom packing list in Apache OpenOffice Calc, with endpoint and recovery checks.Paste Values, Formats and Transposed Data in OpenOffice CalcFreeze formula results, paste only formatting and transpose a separate table in Apache OpenOffice Calc without losing destination formulas.Find and Replace Within Selected Data in OpenOffice CalcLimit Find and Replace to selected cells in Apache OpenOffice Calc, audit exact matches and distinguish formula, value and regex searches.Split Existing Text into Columns in OpenOffice CalcSplit existing semicolon-delimited cells in Apache OpenOffice Calc while preserving text IDs, quoted fields and blank fields.Control AutoInput and AutoCorrect in OpenOffice CalcDistinguish column completion from AutoCorrect, prevent unwanted dash substitutions, and verify exact text before restoring your preferences.Insert, Delete or Clear Cells in OpenOffice CalcCompare clearing contents with structural cell, row and column edits in Apache OpenOffice Calc, and check record alignment and formula ranges.
Styles and templates
Create and Reuse a Workbook Template in OpenOffice CalcBuild a clean Apache OpenOffice Calc template, create independent reports, revise the master and restore a changed default.Use Separate Page Styles for Report Sheets in OpenOffice CalcGive an OpenOffice Calc summary and detail sheet different print layouts, avoid shared page-style changes and verify an exported report.Add Safe Report Headers and Page Numbers in OpenOffice CalcSet explicit report identity, sheet-name and page fields in Apache OpenOffice Calc headers and footers, then inspect output for unwanted file paths.Copy and Retire Custom Cell Styles in OpenOffice CalcTransfer a custom cell style to another Calc workbook, verify its use, and replace old assignments before deleting an unwanted definition.
Workbook workflows
Compare and merge workbook revisionsCompare an untracked revision with its original and merge tracked copies without confusing the direction of review.Run one- and two-variable Multiple Operations tablesBuild one- and two-input sensitivity tables with Multiple Operations, keeping the row and column input cells straight.Use graphics and drawing objects in a reportAnchor report graphics deliberately, test their response to inserted rows, and keep visual annotations separate from the data.
Automation and productivity
References and calculation
Control recalculation and investigate circular formulasSeparate stale calculation from circular references, test hard recalculation and use iteration only for a deliberate convergent model; inspect date origin separately with a fixed numeric serial.Insert linked sheets and refresh external tablesInsert a linked worksheet and a named external range, then check which source edits reach each destination.Link an external spreadsheet and manage broken pathsCreate a formula link between two ODS files, verify saved-source updates, and repair a moved source without trusting stale values.Link spreadsheet summaries into WriterInsert a linked Calc OLE object into Writer, distinguish it from an embedded copy, and verify an edited source total.Use array formulas without corrupting the result rangeEnter and edit a fixed-size Calc array formula while protecting the full output range from partial changes.
Formatting and layout
Analysis and modeling
Sharing, safety and accessibility
Protect file contents with encryptionCreate an opening-password-protected ODS copy and verify that it requires the password without confusing encryption with edit protection.Save and restore document versionsStore annotated versions inside an ODS file, inspect an older read-only version, and recover it without losing the original history.Use shared-file editing and resolve conflictsUnderstand traditional shared Calc files, rehearse a save conflict, and verify the retained values before continuing.
Formulas and analysis
Record and replay a document-owned macro in OpenOffice CalcRecord a harmless Paste Special macro inside an ODS document and replay it with explicit clipboard and selection prerequisites.Create a Document-Owned Basic Function in OpenOffice CalcStore a Basic worksheet function in an ODS document, handle scalar and range inputs, and diagnose library-loading problems after reopening.
Formula auditing
Trace a Wrong Result with Detective in OpenOffice CalcTrace a wrong total to its actual input with Detective, correct the cause, and verify every dependent result.Check Formula Arguments with the Function Wizard in OpenOffice CalcSelect separate ranges, inspect a nested calculation and catch a subtotal counted twice with OpenOffice Calc's Function Wizard; also try the Function List Sidebar and Last Used category.