The LibreOffice documentation team is proud to announce the immediate availability of the Calc Guide 26.2.
Whether you’re a beginner or an expert, this guide covers all aspects of the LibreOffice Calc spreadsheet module—from creating simple shopping lists to performing advanced data analysis and complex calculations.
“We examine the Calc guide from the end user’s perspective—covering step-by-step instructions, explanations of the spreadsheet’s internal workings, and illustrating the use cases where each feature applies” said Olivier Hallot, Documentation Coordinator and Guide Lead for Calc.
The guide’s formatting and book assembly for publication received special attention from the team. We undertook a significant reformatting and style cleanup, made possible by a set of sanity-check automation macros tied to the book template—developed by B. Antonio Fernandez. These tools greatly simplified the task of removing manual formatting and ensuring consistency in references.
This guide is the result of teamwork by LibreOffice Community volunteers. We extend special thanks to Regina Henschel, Dione Maddern, Ed Olson, and B. Antonio Fernandez.
The 26.2 edition of the Calc Guide updates the content from the 25.8 and 26.2 releases of LibreOffice Calc and includes the following changes, in addition to improvements in the English text and overall content:
- Chapter 1 – Introduction: added information on CSV import.
- Chapter 2 – Entering and Editing Data: natural sort details.
- Chapter 6 – Creating Charts and Graphs: added information on data table for graphs in format menu.
- Chapter 8 – Printing, Exporting, Emailing, and Signing: update PDF features, export dialogs and versions.
- Chapter 9 – Using Formulas and Functions: added information on quick naming ranges,
- Chapter 12 – Linking Data: direct import of XML and JSON files
- Chapter 15 – Calc as a Database: added information on Data provider and new database related functions. Moved sort data to chapter 2.
- Appendix A – Keyboard Shortcuts: the keyboard shortcuts tables were reorganized to list entries by task rather than by key.
The Calc Guide is available in PDF, ODT format and can be read on line as web pages. To access the Guide, readers can use the following
- From LibreOffice software, choose Help > User Guides.
- From your browser, visit https://books.libreoffice.org