Documentation/Publications

From The Document Foundation Wiki
Jump to: navigation, search

This is a downloads page for official LibreOffice documentation as provided by the documentation team. Everything on the official website page usually appears here a few days earlier.

Feel free to join the team. See this page: First steps with the Documentation Team.

User Guides

These guides are intended for LibreOffice end users. They are written by members of the Documentation Team. You are encouraged to let us know about any mistakes you find. To do so, please write to us at documentation@global.libreoffice.org.

Chapters are added to the list below as they are published. If you wish to help us with the Base Guide or with updates to any of the other user guides, please refer to the Documentation development page.

Printed copies can be purchased from the Friends of OpenDocument's store at Lulu.com. Profits from sales of these books are used to benefit the community.

Books for LibreOffice versions 3.x are on a separate page.

Getting Started with LibreOffice



Separate chapters:       4.0.x (2013) 4.2.x (2014) 5.0.x (2016) 5.1.x (2016)
  Preface ODT or PDF   ODT or PDF   ODT or PDF   ODT or PDF  
  1   Introducing LibreOffice ODT or  PDF ODT or  PDF ODT or  PDF   ODT or  PDF  
  2 Setting Up LibreOffice ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  3 Using Styles and Templates ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  4 Getting Started with Writer ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  5 Getting Started with Calc ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  6 Getting Started with Impress ODT or PDF ODT or PDF ODT or PDF
  7 Getting Started with Draw ODT or PDF ODT or PDF ODT or PDF
  8 Getting Started with Base ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  9 Getting Started with Math ODT or PDF ODT or PDF ODT or PDF ODT or PDF
10 Printing, Exporting, and Emailing   ODT or PDF ODT or PDF ODT or PDF ODT or PDF
11 Graphics, Gallery, and Fontwork ODT or PDF ODT or PDF ODT or PDF ODT or PDF
12 Creating Web Pages ODT or PDF ODT or PDF ODT or PDF ODT or PDF
13 Getting Started With Macros ODT or PDF ODT or PDF ODT or PDF ODT or PDF
14 Customizing LibreOffice ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  A Keyboard Shortcuts ODT or PDF ODT or PDF ODT or PDF ODT or PDF
  B Open Source, Open Standards,
  OpenDocument
ODT or PDF ODT or PDF ODT or PDF ODT or PDF
 Complete Getting Started Guide  4.0.x 4.2.x 5.0.x 5.1.x
Getting Started: Full book ODT or PDF ODT or PDF ODT or PDF
  * Printed copy (for purchase) 4.0 Book 4.2 Book 5.0 book

LibreOffice Writer Guide



Separate chapters:       4.0.x 4.2.x 5.x
  Preface ODT or  PDF     ODT or  PDF 9pg 29 Oct    
  1   Introducing Writer ODT or  PDF   ODT or  PDF  27pg  29 Oct
  2 Setting up Writer ODT or PDF ODT or PDF 33pg 29 Oct
  3 Working with Text ODT or PDF ODT or PDF 51pg 29 Oct
  4 Formatting Pages ODT or PDF ODT or PDF 46pg 29 Oct
  5 Printing, Faxing, Exporting,
  and E-mailing
ODT or PDF ODT or PDF 24pg 29 Oct
  6 Introduction to Styles ODT or PDF ODT or PDF 32pg 29 Oct
  7 Working with Styles ODT or PDF ODT or PDF 36pg 29 Oct
  8 Working with Graphics ODT or PDF -- Renamed in 4.2 --
  Working with Images 'New' in 4.2 ODT or PDF 34pg 29 Oct
  9 Working with Tables ODT or PDF ODT or PDF 28pg 29 Oct
10 Working with Templates     ODT or PDF ODT or PDF 13pg 29 Oct
11 Using Mail Merge ODT or PDF ODT or PDF 30pg 29 Oct
12 Tables of Contents, Indexes,  
  and Bibliographies
ODT or PDF   ODT or PDF 35pg 29 Oct  
13 Master Documents     ODT or PDF ODT or PDF 21pg 29 Oct
14 Working with Fields ODT or PDF   ODT or PDF 27pg 29 Oct  
15 Using Forms in Writer ODT or PDF   ODT or PDF 24pg 29 Oct  
16 Customizing Writer ODT or PDF ODT or PDF 18pg 29 Oct
  A Keyboard Shortcuts ODT or PDF ODT or PDF 16pg 29 Oct
2013  2014 
The complete Writer Guide: 4.0.x 4.2.x 5.x
Writer Guide: Full book ODT or PDF ODT or PDF 482p 2 Oct
  * Printed copy (for purchase) 4.0 Book 4.2 book

LibreOffice Calc Guide

Because there is no book for v3.5, the v3.4 chapters are retained here.



Separate chapters:       3.4.x
4.1.x 5.x
  Preface. ODT or  PDF     ODT or  PDF  10pg 11 Aug        
  1   Introducing Calc. ODT or  PDF   ODT or  PDF 28pg 11 Aug    
  2 Entering, Editing,
  and Formatting Data.
ODT or PDF ODT or PDF 44pg 11 Aug    
  3 Using Charts and Graphs. ODT or PDF ODT or PDF 42pg 13 Aug    
  4 Using Styles and Templates. ODT or PDF ODT or PDF 22pg 14 Sep    
  5 Using Graphics in Calc. ODT or PDF ODT or PDF 23pg 25 Nov    
  6 Printing, Exporting, & E-mailing. ODT or PDF ODT or PDF 28pg 29 Dec    
  7 Formulas and Functions. ODT or PDF ODT or PDF 37pg 21 Sep    
  8 Using Pivot Tables. ODT or PDF ODT or PDF 25pg 12 Nov    
  9 Data Analysis. ODT or PDF ODT or PDF 22pg  20 Sep    
10 Linking Calc Data. ODT or PDF ODT or PDF 25pg 23 Sep    
11 Sharing and Reviewing. ODT or PDF ODT or PDF 15pg 24 Sep    
12 Calc Macros. ODT or PDF ODT or PDF 16pg 28 Nov    
13 Calc as a Simple Database. ODT or PDF ODT or PDF 27pg 28 Nov    
14 Setting Up & Customizing Calc.   ODT or PDF ODT or PDF 32pg 28 Nov    
  A Keyboard Shortcuts. ODT or PDF ODT or PDF 9pg 25 Nov    
  B Calc Functions. ODT or PDF ODT or PDF 52pg 24 Nov    
  C Calc Error Codes. ODT or PDF ODT or PDF 7pg 28 Nov    
 
  2012  2013
The complete Calc Guide: 3.4.x
4.1.x 5.x
Calc Guide: Full book ODT or PDF   ODT or PDF 438p 29 Nov    
  * Printed copy for purchase 3.4 Book 4.1 book
 
 

LibreOffice Math Guide



      The Complete Math Guide:       3.5.x
4.0.x 4.4.x
Math Guide: Full book ODT or  PDF   ODT or  PDF   ODT or  PDF  90pg  22 Mar 15  
  * Printed copy (for purchase) 3.5 Book 4.0 Book Coming soon
 

LibreOffice Impress Guide



Separate chapters:       3.5.x
4.0.x 4.2.x
  Preface ODT or  PDF     ODT or  PDF     ODT or  PDF 8pg 19 Aug    
  1   Introducing Impress. ODT or  PDF   ODT or  PDF   ODT or  PDF  21pg  18 May
  2 Using Slide Masters,
  Styles, and Templates.
ODT or PDF ODT or PDF ODT or PDF 24pg 18 May
  3 Adding and Formatting Text. ODT or PDF ODT or PDF ODT or PDF 36pg 19 May
  4 Adding and Formatting Pictures.   ODT or PDF ODT or PDF -- Renamed in 4.2 --
  Adding and Formatting Images.   'New' in 4.2 'New' in 4.2 ODT or PDF 19pg 19 May
  5 Managing Graphic Objects. ODT or PDF ODT or PDF ODT or PDF 36pg 20 May
  6 Formatting Graphic Objects. ODT or PDF ODT or PDF ODT or PDF 30pg 18 July
  7 Including Spreadsheets,
  Charts, and Other Objects.
ODT or PDF ODT or PDF ODT or PDF 22pg 26 July
  8 Adding and Formatting
  Slides, Notes, and Handouts.
ODT or PDF ODT or PDF ODT or PDF 24pg 28 July
  9 Slide Shows. ODT or PDF ODT or PDF ODT or PDF 21pg 14 Aug
10 Printing, E-mailing, Exporting,
  and Saving Slide Shows.
ODT or PDF ODT or PDF ODT or PDF 20pg 17 Aug
11 Setting up and
  Customizing Impress.
ODT or PDF ODT or PDF ODT or PDF 22pg 21 Aug
  A Keyboard Shortcuts. ODT or PDF ODT or PDF ODT or PDF 9pg 22 Aug
 
  2012  2013  2014 
The complete Impress Guide: 3.5.x
4.0.x 4.2.x
Impress Guide: Full book ODT or PDF ODT or PDF ODT or PDF 282p 24 Aug
  * Printed copy (for purchase) 3.5 Book 4.0 Book 4.2 book
 

LibreOffice Draw Guide



Separate chapters:       3.5.x
4.1.x 4.3.x
  Preface. New in 4.1     ODT or  PDF     ODT or  PDF 8pg 26 Aug    
  1   Introducing Draw. ODT or  PDF   ODT or PDF ODT or PDF  14pg  12 Sep
  2 Drawing Basic Shapes. ODT or PDF ODT or PDF ODT or PDF 16pg 25 Sep
  3 Working with Objects
  & Object Points.
ODT or PDF ODT or PDF ODT or PDF 28pg 7 Oct
  4 Changing Object Attributes. ODT or PDF ODT or PDF ODT or PDF 37pg 10 Dec
  5 Combining Multiple Objects. ODT or PDF ODT or PDF ODT or PDF 14pg  13 Dec
  6 Editing Pictures
  (Raster Graphics).
ODT or PDF ODT or PDF ODT or PDF 24pg 17 Dec
  7 Working with 3D Objects. ODT or PDF ODT or PDF ODT or PDF 21pg 19 Dec
  8 Organization Charts,
  Flow Diagrams and More.
ODT or PDF ODT or PDF ODT or PDF 12pg 20 Dec
  9 Adding and Formatting Text. ODT or PDF ODT or PDF ODT or PDF 28pg 30 Dec
10 Advanced Draw Techniques. ODT or PDF Now Ch11
10 Printing, Exporting, E-mailing.     New in 4.1 ODT or PDF ODT or PDF 12pg 31 Dec
11 Advanced Draw Techniques. 'New' in 4.1 ODT or PDF ODT or PDF 32pg 20 Jan
  A Keyboard Shortcuts. — New in 4.3 — ODT or PDF 10pg 20 Jan

2012  2013  2014–2015 
   The complete Draw Guide:     3.5.x
4.1.x 4.3.x
Draw Guide: Full book ODT or PDF ODT or PDF ODT or PDF 242p 26 Jan
  * Printed copy (for purchase) 3.5 Book 4.1 book 4.3 book

LibreOffice Base Handbook

Translated from the German. Note: Books for v3.5-3.6 and v4.0 are identical except for covers, ISBN, and copyright pages.  Base itself was fairly static during that time-frame.



Separate chapters:       3.5-3.6 (2013) 4.0 (2013) 5.0 (2015)
DRAFT
Preface ODT or  PDF 8pg     -- minor changes --   ODT or  PDF    
  1   Introduction ODT or  PDF   9pg   -- minor changes --   ODT or  PDF  
  2 Creating a Database ODT or PDF  14pg   -- no change --   ODT or PDF  
  3 Tables ODT or PDF 29pg   -- no change --   ODT or PDF  
  4 Forms ODT or PDF 63pg   -- no change --   ODT or PDF  
  5 Queries ODT or PDF 30pg   -- no change --   ODT or PDF  
  6 Reports ODT or PDF 24pg   -- no change --   ODT or PDF  
  7 Linking to Databases ODT or PDF 28pg   -- no change --   ODT or PDF  
  8 Database Tasks ODT or PDF 12pg   -- no change --   ODT or PDF  
  9 Macros ODT or PDF 33pg   -- no change --   ODT or PDF  
10 Database Maintenance ODT or PDF 8pg   -- no change --   ODT or PDF  
  A Appendix ODT or PDF 17pg   -- no change --   ODT or PDF  
Database used in Base Handbook 3.5-4.0 (without macros)
Database used in Base Handbook 3.5-4.0 (with macros)
Zip file of databases used in Base Handbook 5.0
 
The complete Base Handbook:     3.5-3.6   4.0 5.0
Base Handbook: Full book ODT or PDF 260p   ODT or  PDF   260p     
  * Printed copy (for purchase) 3.6 Book 4.0 Book
       

See also:

LibreOffice Base Guide

Note. Some of these chapters are unfinished drafts.



Separate chapters:       3.4.x 4.x
  1   Introducing Base ODT or  PDF   53pg   13 Dec 2011    ODT or  PDF   45pg   5 Jan 2014
  2   Planning & Designing your Database   ODT - draft   66pg 14 Dec 2012    ODT - draft   66pg 16 Jan 2014   
  3   Data Input and Removal ODT - draft   64pg 30 Sep 2012    Replaced by other chapters
  3   Tables: Data Input & Removal New for v4.2 ODT - draft   34pg 26 Jan 2014
 

Desktop Reference Cards

These come in both A4 and US letter sizes, ready for printing and optional lamination.

LibreOffice 4.0 Reference Cards

Reference Card Letter ODT Letter PDF A4 ODT A4 PDF
Writer, Calc, Impress ODT PDF ODT PDF
Writer, Calc, Draw ODT PDF ODT PDF
Writer, Calc, Base ODT PDF ODT PDF
Writer, Calc, Math ODT PDF ODT PDF
Writer, Impress, Draw ODT PDF ODT PDF
Writer, Impress, Base ODT PDF ODT PDF
Writer, Impress, Math ODT PDF ODT PDF
Writer, Draw, Base ODT PDF ODT PDF
Writer, Draw, Math ODT PDF ODT PDF
Writer, Base, Math ODT PDF ODT PDF
Calc, Impress, Draw ODT PDF ODT PDF
Calc, Impress, Base ODT PDF ODT PDF
Calc, Impress, Math ODT PDF ODT PDF
Impress, Draw, Base ODT PDF ODT PDF
Impress, Draw, Math ODT PDF ODT PDF
Draw, Base, Math ODT PDF ODT PDF

LibreOffice 3.4-3.6 Reference Cards

Reference Card Letter ODT Letter PDF A4 ODT A4 PDF
Writer, Calc, Impress ODT PDF ODT PDF
Writer, Calc, Draw ODT PDF ODT PDF
Writer, Calc, Base ODT PDF ODT PDF
Writer, Calc, Math ODT PDF ODT PDF
Writer, Impress, Draw ODT PDF ODT PDF
Writer, Impress, Base ODT PDF ODT PDF
Writer, Impress, Math ODT PDF ODT PDF
Writer, Draw, Base ODT PDF ODT PDF
Writer, Draw, Math ODT PDF ODT PDF
Writer, Base, Math ODT PDF ODT PDF
Calc, Impress, Draw ODT PDF ODT PDF
Calc, Impress, Base ODT PDF ODT PDF
Calc, Impress, Math ODT PDF ODT PDF
Impress, Draw, Base ODT PDF ODT PDF
Impress, Draw, Math ODT PDF ODT PDF
Draw, Base, Math ODT PDF ODT PDF

How-tos and Tutorials

More coming soon.

Feature Comparisons

LibreOffice vs. Microsoft Office

This page compares the features of LibreOffice 5.1 and Microsoft Office 2016. It separates major and minor feature differences and also includes LibreOffice extensions. The comparison highlights differences and therefore does not display any features which are present in both office suites.

This spreadsheet compares MS Excel and LO Calc functions. Provided by Zeki Bildirici <zeki@ozgurlukicin.com>. It is a work in progress. A new updated version of the spreadsheet is in the making.

LibreOffice vs. Apple's iWork

Installation Guides

We're collecting links to info here.

Windows

Linux

Mac OS X

Tips for Advanced Users

FAQ (Frequently Asked Questions)

There is a good FAQ at

It was originally created by the French Team, in French. The translations into English are continuing, but most of it is complete. More questions and answers may be added later.

Video Tutorials

Some of the many third-party tutorials on LibreOffice are listed here: Documentation/Other Documentation and Resources#Video Tutorials

Other Documentation and Resources

Lists of third party guides, video tutorials, and other publications have been moved to this wiki page: Documentation/Other Documentation and Resources.