Getting Started Guide 6.4
Manuais
Copyright
This document is Copyright © 2020 by the
LibreOffice Documentation Team. Contributors are listed below. You
may distribute it and/or modify it under the terms of either the GNU
General Public License (http://www.gnu.org/licenses/gpl.html),
version 3 or later, or the Creative Commons Attribution License
(http://creativecommons.org/licenses/by/4.0/),
version 4.0 or later.
All trademarks within this guide belong to their
legitimate owners.
Contributors
To this edition
Jean Hollis Weber
Andrew Jensen
Kees Kriek
Dan Lewis
Steve Fanning
Claire Wood
Pulkit Krishna
Roman Kuznetsov
To previous editions
Andrew Jensen
Amanda Labby
Cathy Crumbley
Dan Lewis
Dave Barton
Jean Hollis Weber
Jorge Rodriguez
Olivier Hallot
Paul Figueiredo
Peter Schofield
John A Smith
Martin Saffron
Steve Schwettman
Dave Barton
Hazel Russman
Ron Faile Jr.
Kevin O’Brien
Magnus Adielsson
Iain Roberts
JiHui Choi
Regina Henschel
Laurent Balland-Poirier
Christian Kühl
Florian Reisinger
Gisbert Friege (Dmaths)
Jochen Schiffers
Frédéric Parrenin
Bernard Siaud
Miklos Vajna
Valerii Goncharuk
Andrew Pitonyak
Feedback
Please direct any comments or suggestions about
this document to the Documentation Team’s mailing list:
[email protected]
- Note
Everything you send to a mailing list, including your email address
and any other personal information that is written in the message, is
publicly archived and cannot be deleted.
Publication
date and software version
Published May 2020. Based on LibreOffice 6.4.
Contents
Copyright 2
Preface 9
Who
is this book for? 10
What’s
in this book? 10
Where
to get more help 10
What
you see may be different 12
Using
LibreOffice on macOS 12
What
are all these things called? 13
Frequently
asked questions 14
Chapter
1 Introducing LibreOffice 15
What
is LibreOffice? 16
Advantages
of LibreOffice 17
Minimum
requirements 17
How
to get the software 18
How
to install the software 18
Extensions
and add-ons 18
Starting
LibreOffice 18
Parts
of the main window 19
Starting
new documents 25
Opening
existing documents 26
Saving
documents 26
Password
protection 27
Opening
and saving files on remote servers 29
Using
the Navigator 30
Undoing
and redoing changes 31
Reloading
a document 31
Using
document properties 31
Closing
a document 33
Closing
LibreOffice 33
Troubleshooting
LibreOffice in Safe Mode 34
Chapter
2 Setting up LibreOffice 36
Introduction 37
Choosing
options for all of LibreOffice 37
Choosing
options for loading and saving documents 50
Choosing
language settings 55
Choosing
Internet options 59
Controlling
LibreOffice’s AutoCorrect functions 60
Chapter
3 Using Styles and Templates 61
Introduction 62
What
are styles? 62
Applying
styles 63
Creating
and modifying styles 66
Creating
new (custom) styles 68
Copying
styles from a template or document (Writer) 70
Deleting
styles 70
What
are templates? Why use them? 71
Creating
a document from a template 71
Creating
a template 72
Editing
a template 74
Adding
templates obtained from other sources 74
Setting
a default template 75
Organizing
templates 76
Examples
of style use 79
Chapter
4 Getting Started with Writer 81
What
is Writer? 82
The
Writer interface 82
Changing
document views 86
Working
with documents 87
Working
with text 88
Formatting
text 98
Formatting
pages 105
Adding
comments to a document 109
Using
built-in language tools 110
Creating
a table of contents 111
Creating
indexes and bibliographies 112
Using
footnotes and endnotes 112
Working
with images (graphics) 112
Working
with tables of data 113
Printing
and exporting to PDF or EPUB 113
Using
mail merge 113
Tracking
changes to a document 113
Using
fields 114
Linking
and cross-referencing within a document 114
Using
master documents 117
Classifying
document contents 117
Creating
fill-in forms 117
Chapter
5 Getting Started with Calc 118
What
is Calc? 119
Compatibility
with other spreadsheet applications 119
Spreadsheets,
sheets, and cells 119
Calc
main window 120
Opening
a CSV file 123
Saving
spreadsheets 124
Navigating
within spreadsheets 126
Selecting
items in a spreadsheet 128
Working
with columns and rows 130
Working
with sheets 131
Viewing
a spreadsheet 134
Entering
data using the keyboard 136
Speeding
up data entry 140
Sharing
content between sheets 142
Validating
cell contents 143
Editing
data 143
Formatting
data 145
AutoFormatting
of cells 149
Using
themes 150
Using
conditional formatting 151
Hiding
and showing data 151
Filtering
data 152
Cell
protection 152
Sorting
records 153
Cell
comments 154
Using
formulas and functions 154
Analyzing
data 155
Pivot
tables and pivot charts 156
Printing 156
Chapter
6 Getting Started with Impress 161
What
is Impress? 162
Starting
Impress 162
Main
Impress window 163
Workspace
views 166
Formatting
a presentation 169
Adding
and formatting text 173
Adding
pictures, tables, charts, and media 178
Working
with master slides and styles 180
Adding
comments to a presentation 187
Creating
handouts 188
Creating
a photo album 189
Setting
up a slide show 190
Running
a slide show 193
Using
Impress Remote control 195
Chapter
7 Getting Started with Draw 196
What
is Draw? 197
Draw
main window 197
Working
with layers 201
Choosing
and defining colors 202
Drawing
basic shapes 204
Using
glue points and connectors 210
Drawing
geometric shapes 211
Selecting
objects 212
Moving
objects and adjusting object size 213
Editing
objects 214
Using
styles 217
Positioning
objects 217
Applying
special effects 219
Combining
multiple objects 223
Inserting
and editing images 224
Working
with 3D objects 225
Exporting
images 225
Inserting
comments in a drawing 225
Chapter
8 Getting Started with Base 226
Introduction 227
Planning
a database 228
Creating
a new database 229
Creating
database tables 231
Creating
a database form 240
Modifying
a form 244
Entering
data in a form 255
Creating
queries 258
Creating
reports 266
Accessing
other data sources 270
Using
data sources in LibreOffice 271
Chapter
9
Getting Started with Math 276
Introduction 277
Getting
started 277
Creating
formulas 279
Editing
formulas 283
Formula
layout 284
Changing
formula appearance 289
Formula
library 296
Formulas
in Writer 297
Formulas
in Calc, Draw, and Impress 303
Customization 304
Exporting
and Importing 309
Chapter
10 Printing, Exporting, Emailing and Signing Documents 311
Quick
printing 312
Controlling
printing 312
Previewing
pages/sheets before printing 321
Exporting
to PDF 322
Exporting
to EPUB format (Writer only) 328
Exporting
to other formats 330
Emailing
documents 330
Digital
signing of documents 331
Removing
personal data 333
Redaction
(Writer, Calc, and Impress) 334
Chapter
11 Images and Graphics 336
Introduction 337
Creating
and editing images 337
Adding
images to a document 337
Modifying,
handling, and positioning images 341
Managing
the LibreOffice Gallery 344
Creating
an image map 346
Using
LibreOffice’s drawing tools 346
Using
Fontwork 349
Generating
a QR code 352
Chapter
12 Creating HTML Files 353
Introduction 354
Relative
and absolute hyperlinks 354
Creating
hyperlinks 355
Saving
and exporting documents as HTML files 358
Creating,
editing, and saving HTML files using Writer/Web 364
Checking
a web page in a browser 365
Chapter
13 Getting Started with Macros 366
Introduction 367
Your
first macros 367
Creating
a macro 374
Macro
recorder failures 377
Macro
organization 378
How
to run a macro 382
Using
extensions 383
Writing
macros without the recorder 384
Overview
of BeanShell, JavaScript, and Python macros 384
Finding
more information 390
Chapter
14 Customizing LibreOffice 391
Introduction 392
Customizing
menu content 392
Customizing
toolbars 395
Assigning
shortcut keys 397
Assigning
macros to events 399
Adding
functionality with extensions 399
Adding
custom colors 400
Adding
fonts 402
Appendix
A Keyboard Shortcuts 403
Introduction 404
General
keyboard shortcuts 405
Navigating
and selecting with the keyboard 406
Controlling
dialogs 406
Controlling
macros 407
Managing
documents 407
Editing 407
Selecting
rows and columns in a database table opened by View > Data Sources
(Ctrl+Shift+F4) 408
Shortcut
keys for drawing objects 408
Defining
keyboard shortcuts 409
Further
reading 409
Appendix
B Open Source, Open Standards, OpenDocument 410
Introduction 411
A
short history of LibreOffice 411
The
LibreOffice community 411
How
is LibreOffice licensed? 412
What
is “open source”? 412
What
are “open standards”? 412
What
is OpenDocument? 412
File
formats LibreOffice can open 413
File
formats LibreOffice can save to 415
Exporting
to other formats 416
Getting
Started Guide
Preface
Who is this book for?
Anyone who wants to get up to speed quickly with
LibreOffice will find this Getting Started Guide valuable. You may be
new to office software, or you may be familiar with another office
suite.
What’s
in this book?
This book introduces the main components of
LibreOffice:
- Writer (word processing)
- Calc (spreadsheets)
- Impress (presentations)
- Draw (vector graphics)
- Base (database)
- Math (equation editor)
It also covers some of the features common to all
components, including setup and customization, styles and templates,
macro recording, and printing. For more detail, see the user guides
for the individual components.
Where
to get more help
This book, the other LibreOffice user guides, the
built-in Help system, and user support systems assume that you are
familiar with your computer and basic functions such as starting a
program, opening and saving files.
Help
system
LibreOffice comes with an extensive Help system.
This is the first line of support for using LibreOffice. Windows and
Linux users can choose to download and install the offline Help for
use when not connected to the Internet; the offline Help is installed
with the program on macOS.
To display the Help system, press F1
or select LibreOffice Help from the
Help menu. If you do not have the offline help installed on your
computer and you are connected to the Internet, your default browser
will open the online Help pages on the LibreOffice website.
The Help menu also includes links to other
LibreOffice information and support facilities.
- Note
The following options shown here prefixed by a ‡
sign are only accessible if your computer is connected to the
Internet.
- What's This? For quick tips when a toolbar is visible, place the mouse pointer over any of the icons to see a small box (“tooltip”) with a brief explanation of the icon’s function. For a more detailed explanation, select Help > What's This? and hold the pointer over the icon. In addition, you can choose whether to activate Extended Tips using Tools > Options > LibreOffice > General.
- User Guides ‡ Opens your default browser at the Documentation page of the LibreOffice website, https://documentation.libreoffice.org/en/english-documentation/. There you will find copies of User Guides and other useful information.
- Show Tip-of-the-Day Opens a small window with a random tip on how to use LibreOffice.
- Get Help Online ‡ Opens your default browser at the Ask LibreOffice forum of questions and answers from the LibreOffice community, https://ask.libreoffice.org/en/questions/.
- Send Feedback ‡ Opens your default browser at the Feedback page of the LibreOffice website, https://www.libreoffice.org/get-help/feedback/. From there you can report bugs, suggest new features and communicate with others in the LibreOffice community.
- Restart in Safe Mode Opens a dialog window where you will have the option to restart LibreOffice and reset the software to its default settings.
- Get Involved ‡ Opens your default browser at the Get Involved page of the LibreOffice website, https://www.libreoffice.org/community/get-involved/. There you can choose a topic of interest to help improve the program.
- Donate to LibreOffice ‡ Opens your default browser at the Donation page of the LibreOffice website, https://donate.libreoffice.org/. There you can choose to make a donation to support LibreOffice.
- License Information Outlines the licenses under which LibreOffice is made available.
- Check for Updates ‡ Opens a dialog window and checks the LibreOffice website for updates to your version of the software.
- About LibreOffice Opens a dialog window and displays information about the version of LibreOffice and the operating system you are using. This information will often be requested if you ask the community for help or assistance with the software. (On macOS this item is under the LibreOffice menu.)
Other free online support
The LibreOffice community not only develops
software, but provides free, volunteer-based support. In addition to
the Help menu links above, there are other online community support
options available, see the table below.
Free
LibreOffice support
FAQs
Answers
to frequently asked
questions
https://wiki.documentfoundation.org/Faq
https://wiki.documentfoundation.org/Faq
Mailing
lists
Free
community support is provided by a network of experienced
users
https://www.libreoffice.org/get-help/mailing-lists/
https://www.libreoffice.org/get-help/mailing-lists/
Questions
& Answers and
Knowledge Base
Knowledge Base
Free
community assistance is provided in a Question & Answer
formatted web service. Search similar topics or open a new one in
https://ask.libreoffice.org/en/questions
The
service is available in several other languages; just replace
/en/ with de, es, fr, ja, ko, nl, pt, tr, and many others in the
web address above.
Native
language support
The
LibreOffice website in various
languages
https://www.libreoffice.org/community/nlc/
https://www.libreoffice.org/community/nlc/
Mailing
lists for native
languages
https://wiki.documentfoundation.org/Local_Mailing_Lists
https://wiki.documentfoundation.org/Local_Mailing_Lists
Information
about social
networking
https://wiki.documentfoundation.org/Website/Web_Sites_services
https://wiki.documentfoundation.org/Website/Web_Sites_services
Accessibility
options
Information
about available accessibility options
https://www.libreoffice.org/get-help/accessibility/
https://www.libreoffice.org/get-help/accessibility/
OpenOffice Forum
Another forum that provides support for LibreOffice, among other
open source office suites https://forum.openoffice.org/en/forum/
Paid
support and training
You can also pay for support through service
contracts from a vendor or consulting firm specializing in
LibreOffice. For information about certified professional support,
see The Document Foundation’s website:
https://www.documentfoundation.org/gethelp/support/
What
you see may be different
Illustrations
LibreOffice runs on Windows, Linux, and macOS
operating systems, each of which has several versions and can be
customized by users (fonts, colors, themes, window managers). The
illustrations in this guide were taken from a variety of computers
and operating systems. Therefore, some illustrations will not look
exactly like what you see on your computer display.
Also, some of the dialogs may be different because
of the settings selected in LibreOffice. You can either use dialogs
from your computer’s operating system or from LibreOffice. The
differences affect mainly Open, Save, and Print dialogs. To change
which dialogs are used, go to Tools >
Options > LibreOffice > General and select or deselect
the option Use LibreOffice dialogs.
Icons
The LibreOffice community has created icons for several icon sets:,
Breeze, Breeze (SVG), Breeze (dark), Colibre, Colibre (SVG),
Elementary, Elementary (SVG), Karasa Jaga, Sifr, Sifr (dark), and
Tango. Each user can select a preferred set. The icons in this guide
have been taken from a variety of LibreOffice installations that use
different sets of icons. The icons for some of the many tools
available in LibreOffice may then differ from the ones used in this
guide.
To change the icon set used, go to Tools
> Options > LibreOffice > View. In the Icon
style section, choose from the drop-down list.
- Notes
Some Linux distributions include LibreOffice as part of the
installation and may not include all the icon sets mentioned above.
You should be able to download other icon sets from the software
repository for your Linux distribution if you wish to use them.
The Galaxy and Oxygen icon sets are no longer included as part of the
standard installation package. They can be added back by downloading
and installing the following
extensions:
https://extensions.libreoffice.org/extensions/galaxy-icon-theme
https://extensions.libreoffice.org/extensions/oxygen-icon-theme
Some of the previously included gallery backgrounds are now only available as an extension from https://extensions.libreoffice.org/extensions/legacy-gallery-backgrounds
https://extensions.libreoffice.org/extensions/galaxy-icon-theme
https://extensions.libreoffice.org/extensions/oxygen-icon-theme
Some of the previously included gallery backgrounds are now only available as an extension from https://extensions.libreoffice.org/extensions/legacy-gallery-backgrounds
Using LibreOffice on macOS
Some keystrokes and menu items are different on
macOS from those used in Windows and Linux. The table below gives
some common substitutions for the instructions in this book. For a
more detailed list, see the application Help.
Windows or Linux
macOS equivalent
Effect
Tools > Options menu
LibreOffice > Preferences
Access setup options
Right-click
Control+click and/or
right-click depending on computer setup
Open a context menu
Ctrl
(Control)
⌘ (Command)
Used with other keys
F5
Shift+⌘+F5
Open the Navigator
F11
⌘+T
Open the sidebar Styles
deck
What are all these things called?
The terms used in LibreOffice for most parts of
the user interface (the parts of the program you see and use, in
contrast to the behind-the-scenes code that actually makes it work)
are the same as for most other programs.
A dialog is a special type of window. Its purpose
is to inform you of something, or request input from you, or both. It
provides controls to use to specify how to carry out an action. The
technical names for common controls are shown in Figure 1.
In most cases the technical terms are not used in this book, but it
is useful to know them because the Help and other sources of
information often use them.
- Tabbed page (not strictly speaking a control).
- Radio buttons (only one can be selected at a time).
- Checkbox (more than one can be selected at a time).
- Spin box (click the up and down arrows to change the number shown in the adjacent text box, or type in the text box).
- Thumbnail or preview.
- Drop-down list from which to select an item.
- Push buttons.
In most cases, you
can interact only with the dialog (not the document itself) as long
as the dialog remains open. When you close the dialog after use
(usually, clicking OK or another
button saves your changes and closes the dialog), then you can again
work with your document.
Some dialogs can be left open as you work, so you
can switch back and forth between the dialog and the document. An
example of this type is the Find & Replace dialog.
Frequently
asked questions
How is LibreOffice licensed?
LibreOffice is distributed under
the Open Source Initiative (OSI) approved Mozilla Public License
(MPL). See https://www.libreoffice.org/about-us/licenses/
It is based on code from Apache
OpenOffice made available under the Apache License 2.0 but also
includes software that differs from version to version under a
variety of other Open Source licenses. New code is available under
LGPL 3.0 and MPL 2.0.
May I distribute LibreOffice to
anyone? May I sell it? May I use it in my business?
Yes.
How many computers may I install
it on?
As many as you like.
Is LibreOffice available in my
language?
LibreOffice has been translated
(localized) into over 40 languages, so your language probably is
supported. Additionally, there are over 70 spelling, hyphenation, and
thesaurus dictionaries available for languages, and dialects that do
not have a localized program interface. The dictionaries are
available from the LibreOffice website at: www.libreoffice.org.
How can you make it for free?
LibreOffice is developed and
maintained by volunteers and has the backing of several
organizations.
I am writing a software
application. May I use programming code from LibreOffice in my
program?
You may, within the parameters set
in the MPL and/or LGPL. Read the licenses:
https://www.mozilla.org/MPL/2.0/.
Why do I need Java to run
LibreOffice? Is it written in Java?
LibreOffice is not written in Java;
it is written in the C++ language. Java is one of several languages
that can be used to extend the software. The Java JDK/JRE is only
required for some features. The most notable one is the HSQLDB
relational database engine.
Java is available at no cost. More
information and download links to the appropriate edition for your
operating system can be found at:
https://java.com/en/download/manual.jsp
- Note
If you want to use LibreOffice features that require Java, it is
important that the correct 32-bit or 64-bit edition matches the
installed version of LibreOffice. See the Advanced Options in Chapter
2 of this guide. If you do not want to use Java, you can still use
nearly all of the LibreOffice features.
How can I contribute to
LibreOffice?
You can help with the development
and user support of LibreOffice in many ways, and you do not need to
be a programmer. To start, check out this webpage:
https://www.libreoffice.org/community/get-involved/
May I distribute the PDF of this
book, or print and sell copies?
Yes, as long as you meet the
requirements of one of the licenses in the copyright statement at the
beginning of this book. You do not have to request special
permission. We request that you share with the project some of the
profits you make from sales of books, in consideration of all the
work we have put into producing them.
Donate to LibreOffice:
https://www.libreoffice.org/donate/
Getting
Started Guide
Chapter
1
Introducing LibreOffice
Introducing LibreOffice
What is LibreOffice?
LibreOffice is a freely available, fully-featured
office productivity suite. Its native file format is Open Document
Format (ODF), an open standard format that is being adopted by
governments worldwide as a required file format for publishing and
accepting documents. LibreOffice can also open and save documents in
many other formats, including those used by several versions of
Microsoft Office.
LibreOffice includes the following components.
Writer
(word processor)
Writer is a feature-rich tool for creating
letters, books, reports, newsletters, brochures, and other documents.
You can insert graphics and objects from other components into Writer
documents. Writer can export files to HTML, XHTML, XML, Adobe
Portable Document Format (PDF), EPUB, and several versions of
Microsoft Word files. It also connects to your email client.
Calc
(spreadsheet)
Calc has all of the advanced analysis, charting,
and decision making features expected from a high-end spreadsheet. It
includes over 500 functions for financial, statistical, and
mathematical operations, among others. The Scenario Manager provides
“what if” analysis. Calc generates 2D and 3D charts, which can be
integrated into other LibreOffice documents. You can also open and
work with Microsoft Excel workbooks and save them in Excel format.
Calc can also export spreadsheets in several formats, including for
example Comma Separated Value (CSV), Adobe PDF and HTML formats.
Impress
(presentations)
Impress provides all the common multimedia
presentation tools, such as special effects, animation, and drawing
tools. It is integrated with the advanced graphics capabilities of
LibreOffice Draw and Math components. Slideshows can be further
enhanced using Fontwork special effects text, as well as sound and
video clips. Impress is compatible with Microsoft PowerPoint file
format and can also save your work in numerous graphics formats.
Draw
(vector graphics)
Draw is a vector drawing tool that can produce
everything from simple diagrams or flowcharts to 3D artwork. Its
Smart Connectors feature allows you to define your own connection
points. You can use Draw to create drawings for use in any of the
LibreOffice components, and you can create your own clip art and then
add it to the Gallery. Draw can import graphics from many common
formats and save them in many
formats, including PNG, GIF, JPEG, BMP, TIFF, SVG, HTML and PDF.
Base
(database)
Base provides tools for day-to-day database work
within a simple interface. It can create and edit forms, reports,
queries, tables, views, and relations, so that managing a relational
database is much the same as in other popular database applications.
Base provides many new features, such as the ability to analyze and
edit relationships from a diagram view. Base incorporates two
relational database engines, HSQLDB and Firebird. It can also use
PostgreSQL, dBASE, Microsoft Access, MySQL, Oracle, or any ODBC
compliant or JDBC compliant database. Base also provides support for
a subset of ANSI-92 SQL.
Math
(formula editor)
Math is the LibreOffice formula or equation
editor. You can use it to create complex equations that include
symbols or characters not available in standard font sets. While it
is most commonly used to create formulas in other documents, such as
Writer and Impress files, Math can also work as a standalone tool.
You can save formulas in the standard Mathematical Markup Language
(MathML) format for inclusion in web pages and other documents not
created by LibreOffice.
Advantages
of LibreOffice
Here are some of the advantages of LibreOffice
over other office suites:
- No licensing fees. LibreOffice is free for anyone to use and distribute at no cost. Many features that are available as extra cost add-ins in other office suites (like PDF export) are free with LibreOffice. There are no hidden charges now or in the future.
- Open source. You can distribute, copy, and modify the software as much as you wish, in accordance with the LibreOffice Open Source licenses.
- Cross-platform. LibreOffice runs on several hardware architectures and under multiple operating systems, such as Microsoft Windows, macOS, and Linux.
- Extensive language support. The LibreOffice user interface, including spelling, hyphenation, and thesaurus dictionaries, is available in over 100 languages and dialects. LibreOffice also provides support for both Complex Text Layout (CTL) and Right to Left (RTL) layout languages (such as Urdu, Hebrew, and Arabic).
- Consistent user interface. All the components have a similar “look and feel”, making them easy to use and master.
- Integration. The components of LibreOffice are well integrated with one another.
- All the components share a common spelling checker and other tools, which are used consistently across the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but enhanced versions in Impress and Draw.
- You do not need to know which application was used to create a particular file. For example, you can open a Draw file from Writer; it will open automatically in Draw.
- Granularity. Usually, if you change an option, it affects all components. However, LibreOffice options can be set at a component level or even at document level.
- File compatibility. In addition to its native OpenDocument formats, LibreOffice includes support for opening and saving files in many common formats including Microsoft Office, HTML, XML, WordPerfect, Lotus 1-2-3, and PDF.
- No vendor lock-in. LibreOffice uses OpenDocument, an XML (eXtensible Markup Language) file format developed as an industry standard by OASIS (Organization for the Advancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their framework is open and published.
- You have a voice. Enhancements, software fixes, and release dates are community-driven. You can join the community and affect the course of the product you use.
You can read more about LibreOffice and The
Document Foundation on their websites at https://www.libreoffice.org/
and https://www.documentfoundation.org/.
Minimum
requirements
LibreOffice 6.4 requires one of the following operating systems:
- Microsoft Windows: Windows 7 SP1, Windows 8, Windows Server 2012, or Windows 10; Administrator rights are needed for the installation process.
- GNU/Linux: Kernel version 3.10 or higher and glibc2 v2.17 or higher.
- macOS 10.10 (Yosemite) or higher.
Some LibreOffice features (wizards and the HSQLDB
database engine) require that the Java Runtime Environment (JRE) (or,
for macOS, the Java Development Kit (JDK)) is installed on your
computer. Although LibreOffice will work without Java support, some
features will not be available.
Java is available at no cost. More information and
download links to the appropriate edition for your operating system
can be found at: https://java.com/en/download/manual.jsp
- Note
If you want to use LibreOffice features that require Java, it is
important that the correct 32-bit or 64-bit edition matches the
installed version of LibreOffice. See the Advanced Options in Chapter
2 of this guide.
For a more detailed listing of hardware and
software requirements, see the LibreOffice
website,
https://www.libreoffice.org/get-help/system-requirements/.
https://www.libreoffice.org/get-help/system-requirements/.
How
to get the software
Versions of LibreOffice for Windows, Linux, and
macOS can be downloaded free from
https://www.libreoffice.org/download.
You can also download the software by using a Peer-to-Peer client,
such as BitTorrent, at the same address.
Linux users will also find LibreOffice included in
many of the latest Linux distributions; Ubuntu is just one example.
macOS users can also get two versions of
LibreOffice from the App Store for a small fee: LibreOffice Vanilla
and Collabora Office (an enterprise-ready version).
Windows users can also get LibreOffice Vanilla
from the Microsoft Store for a small fee.
How
to install the software
Information on installing and setting up
LibreOffice on the various supported operating systems is given here:
https://www.libreoffice.org/get-help/install-howto/.
Extensions
and add-ons
Extensions and add-ons are available to enhance
LibreOffice. Several extensions are installed with the program and
you can get others from the official extensions repository,
https://extensions.libreoffice.org/.
See Chapter 14, Customizing LibreOffice, for more information on
installing extensions and add-ons.
Starting
LibreOffice
In general, you start LibreOffice the same way you
start any other program on your computer.
On Windows and
Linux, entries for LibreOffice and each of
its components appear in the system menu of your
computer. On macOS, only an
entry for LibreOffice is added to the Applications menu. You can make
a desktop icon for LibreOffice or a component in the same way you can
make a desktop icon for any other program; see your operating
system’s help for how to do this.
Clicking on the LibreOffice menu entry, desktop
icon, or tile opens the LibreOffice Start Center (Figure 2)
from where you can select the individual components of LibreOffice.
You can also choose
to open an existing file or use a template. The thumbnails in the
Start Center include an icon showing the type of file (text,
spreadsheet, drawing, presentation).
Opening
an existing document before starting LibreOffice
You can start LibreOffice by double-clicking the
filename of an ODF document on the desktop, or in a file manager such
as Windows Explorer or macOS
Finder. The appropriate component of LibreOffice will start and the
document will be loaded.
You can also open files stored in remote servers
running Content Management Interoperability Services (CMIS). CMIS,
like OpenDocument Format, is an OASIS standard. When using CMIS
servers, the service will ask you for the necessary credentials for
file access.
If you do not have Microsoft Office installed on
your computer, or if Microsoft Office is installed but you have
associated Microsoft Office file types with LibreOffice, then when
you double-click on the following files, they open in LibreOffice:
- A Word file (*.doc or *.docx) opens in Writer.
- An Excel file (*.xls or *.xlsx) opens in Calc.
- A PowerPoint file (*.ppt or *.pptx) opens in Impress.
If you did not associate the file types and
Microsoft Office is installed on your computer, then when you
double-click on a Microsoft Office file, it opens using the
appropriate Microsoft Office component.
For more information on opening files, see “Opening existing documents”
on page 26.
Parts
of the main window
The main window is similar for each component of LibreOffice,
although some details vary. See the relevant chapters in this guide
about Writer, Calc, Draw, Impress, Base, and Math for descriptions of
those details.
Common features include the Menu bar, standard
toolbar, and formatting toolbar (Writer and Calc only) at the top of
the window and the status bar at the bottom.
Menu
bar
The Menu bar is located across the top of the
LibreOffice window, just below the title bar. When you select one of
the menus listed below, a sub-menu drops down to show commands. Below
is the case for Writer:
- File – commands that apply to the entire document such as Open, Save, and Export as PDF.
- Edit – commands for editing the document such as Undo, Find & Replace, Cut, Copy, Paste, and Track Changes.
- View – commands for controlling the display of the document such as Toolbars, Text Boundaries, and Zoom.
- Insert – commands for inserting elements into your document such as Header, Footer, and Image.
- Format – commands for formatting the layout of your document.
- Styles – commands for quickly applying common styles; for editing, loading, and creating new styles; and for accessing the Styles deck in the Sidebar.
- Table – commands to insert and edit a table in a text document.
- Form – commands to create fill-in forms.
- Tools – functions such as Spelling, AutoCorrect, Customize, and Options.
- Window – commands for the display window.
- Help – links to the LibreOffice Help file, What’s This?, and information about the program.
Toolbars
LibreOffice has two types of toolbars: docked
(fixed in place) and floating. Docked toolbars can be moved to
different locations or made to float, and floating toolbars can be
docked.
In a default LibreOffice installation, the top
docked toolbar, just under the Menu bar, is called the Standard
toolbar. It is consistent across the LibreOffice applications.
The second toolbar at the top for Writer and Calc,
in a default LibreOffice installation, is the Formatting bar. It is
context-sensitive; that is, it shows the tools relevant to the
current position of the cursor or the object selected. For example,
when the cursor is on a graphic, the Formatting bar provides tools
for formatting graphics; when the cursor is in text, the tools are
for formatting text.
In some cases it is convenient to reduce the
number of toolbars displayed and get more space for the document.
LibreOffice provides a single-toolbar alternative to the default
double-toolbar setup. It contains the most-used commands. To activate
it, enable View > User
Interface >
Single
Toolbar.
Other
variations include Tabbed
and Groupedbar Compact,
both accessed from View
> User Interface.
These provide a collection of tools at the top of the workspace,
grouped in various ways that may be familiar to users of Microsoft
Office (the “ribbon”).
Displaying
or hiding toolbars
To display or hide toolbars in a standard setup,
go to View > Toolbars on the Menu
bar, then click on the name of a toolbar from the drop-down list. An
active toolbar shows a check-mark beside its name. Toolbars created
from tool palettes are not listed in the View menu.
To close a toolbar, go to View
> Toolbars on the Menu bar and deselect the toolbar, or
right-click in an empty space between the icons on a toolbar and
select Close Toolbar
from the context menu.
Sub-menus
and tool palettes
Toolbar icons with a small triangle to the right
will display sub-menus, tool palettes, and alternative methods of
selecting items, depending on the icon.
Tool palettes can be made into a floating toolbar.
Figure 3 shows an example of
a tool palette from the Drawing toolbar made into a floating toolbar.
See “Moving toolbars”
and “Floating toolbars”
below for more information on moving and floating these toolbars
created from tool palettes.
Moving
toolbars
Docked toolbars can be undocked and moved to a new
docked position or left as a floating toolbar.
- Move the mouse cursor over the toolbar handle, which is the small vertical bar to the left of a docked toolbar and highlighted in Figure 4.
- Hold down the left mouse button and drag the toolbar to the new location. The toolbar can be docked in a new position at the top, sides or bottom of the main window, or left as a floating toolbar.
- Release the mouse button.
To move a floating
toolbar, click on its title bar and drag it to a new floating
location or dock the toolbar at the top or bottom of the main window.
Floating toolbars
LibreOffice includes several additional toolbars,
whose default settings have
them appear as floating toolbars in response to the
current position of the cursor or selection. You can dock these
toolbars to the top or bottom of the main window, or reposition them
on your computer display (see “Moving toolbars”
above).
Some of these additional toolbars are context
sensitive and will automatically appear depending on the position of
the cursor. For example, when the cursor is in a table, a Table
toolbar appears, and when the cursor is in a numbered or bullet list,
the Bullets and Numbering toolbar appears.
Customizing
toolbars
You can customize toolbars in several ways, including choosing which
icons are visible and locking the position of a docked toolbar. You
can also add icons and create new toolbars, as described in Chapter
14, Customizing LibreOffice. To access the customization options for
a toolbar, right-click in an empty space between the icons on a
toolbar to open a context menu as follows:
- To show or hide icons defined for the selected toolbar, point to Visible Buttons. Visible icons on a toolbar are indicated by an outline around the icon (Figure 5) or by a check mark beside the icon, depending on your operating system. Select or deselect icons to hide or show them on the toolbar.
- Click Customize Toolbar to open the Customize dialog; See Chapter 14, Customizing LibreOffice, for more information.
- Click Dock Toolbar to dock the selected floating toolbar. You can reposition the toolbar to a different docked position. See “Moving toolbars” on page 21.
- Click Dock All Toolbars to dock all floating toolbars. You can reposition the toolbars to different docked positions. See “Moving toolbars” on page 21.
- Click Lock Toolbar Position to lock a docked toolbar into its docked position.
- Click Close Toolbar to close the selected toolbar.
Context
menus
Context menus provide quick access to many menu
functions. They are opened by right-clicking on a paragraph, graphic,
or other object. When a context menu opens, the functions or options
available will depend on the object that has been selected. A context
menu can be the easiest way to reach a function, especially if you
are not sure where the function is located in the menus or toolbars.
Context
menus may
display an applicable keyboard shortcut if one has been set; you can
toggle this visibility off or on in Tools >
Options > LibreOffice
> View > Visibility.
Status
bar
The status bar is located at the bottom of the workspace. It provides
information about the document and convenient ways to change some
features quickly. It is similar in Writer, Calc, Impress, and Draw,
but each LibreOffice component includes some component-specific
items. An example of the Writer status bar is shown in Figure 7.
Page, sheet, or slide number and
page count
Shows the current page, sheet, or
slide number and the total number of pages, sheets, or slides in the
document. Click on this field to open the Go to Page dialog. Other
uses of this field depend on the LibreOffice component.
Word & character count
Shows the total number of words and
characters in the document or in the selection.
Page style or slide design
Shows the current page style or
slide design. To edit the current page style or slide design,
double-click on this field. To choose a different page style or slide
design, right-click on this field and select from the list that pops
up.
Language
Shows the current language of the
text at the current cursor position.
Insert mode
Shows the type of insert mode the
program is in. This field is blank if the program is in Insert mode.
Each time the Ins key is pressed, or this field is clicked,
the mode toggles between Insert and Overwrite.
Selection mode
Click to choose different selection
modes. The icon does not change, but when you hover the mouse pointer
over this field, a tooltip indicates which mode is active.
Unsaved changes
The icon shown here is different
when changes to the document have not been saved.
Digital signature
If the document has been digitally
signed, an icon shows here. You can click the icon to sign the
document, or to view the existing certificate.
Object
information
Displays
information relevant to the position of the cursor or the selected
element of the document.
View layout
Select between Single-page view,
Multiple-page view, and Book view to change how your document is
displayed.
Zoom slider
Drag the Zoom slider, or click on
the + and – signs to change the view magnification of your
document.
Zoom percentage
Indicates the magnification level
of the document. Right-click on the percentage figure to open a list
of magnification values from which to choose. Cicking on this
percentage figure opens the Zoom & View Layout dialog.
Sidebar
To activate the Sidebar, select View
> Sidebar from the Menu bar. The Sidebar (Figure 8)
is located on the right side of the edit views of Writer, Calc,
Impress, and Draw. It contains one or more decks,
based on the current document context. Decks
are organized into panels.
A tab bar on the right side of the sidebar allows you to switch
between different decks.
All four components contain the Properties,
Styles, Gallery, and Navigator decks. Some components have additional
decks, such as Page for Writer; Master Slides,
Animation, and Slide Transition for Impress; Shapes
for Draw;
and Functions for Calc.
A panel is like a combination of a toolbar and a
dialog. For example, you can freely mix working in the main edit
window to enter text and use the Properties panel in the sidebar to
change text attributes.
Toolbars and Sidebar panels share many functions.
For example, the buttons for making text bold or italic exist in both
the Formatting toolbar and the Properties panel.
For more detail, see the Sidebar explanation in
the relevant LibreOffice component’s user guide.
To hide the Sidebar, click on the gray Hide button
on the left. Click on the same button to show the Sidebar again.
To
undock the Sidebar and make it floating, and to dock a floating
Sidebar, use the Sidebar settings drop-down list at the top of the
tab bar (see Figure 9). From
the same list you can choose which items to show in the Sidebar.
Starting
new documents
You can start a new, blank document in LibreOffice
in several ways.
When LibreOffice is running but no document is
open, the Start Center (Figure 2
on page 19) is shown. Click
one of the icons to open a new document of that type, or click the
Templates icon to start a new document using a template.
You can also start a new document in one of the following ways:
- Use File > New on the Menu bar and select the type of document from the context menu.
- Use the keyboard shortcut Ctrl+N to create a new document. The type of document created depends on which LibreOffice component is open and active. For example, if Calc is open and active, a new spreadsheet is created.
- Use File > Wizards on the Menu bar and select the type of document from the context menu.
- If a document is already open in LibreOffice, click the New icon on the Standard toolbar and a new document of the same type is created in a new window. For example, if Calc is open and active, a new spreadsheet is created. The New icon changes depending on which component of LibreOffice is open.
- If a document is already open in LibreOffice, click on the small triangle to the right of the New icon on the Standard toolbar and select the type of document from the context menu that opens.
- Note
If all documents are closed without exiting
from
LibreOffice, then the Start Center will be displayed.
Opening
existing documents
You can also open an
existing document in one of the following ways:
- When no document is open, click Open File or Remote Files in the Start Center to reach the corresponding open dialog.
- Go to File > Open or File > Open Remote on the Menu bar to reach the corresponding open dialog.
- Use the keyboard shortcut Ctrl+O to reach the Open dialog.
- If a document is already open, click the Open icon on the Standard toolbar and select from a list of available documents from the Open dialog.
- Click the small triangle to the right of the Open icon and select from a list of recently opened documents, click Open Template to select a template, or click Open Remote File to open a remote file.
- When no document is open, click on a thumbnail of recently opened documents displayed in the Start Center. You can scroll up or down in the Start Center to locate a recently opened document.
When using the Open dialog, navigate to the folder
you want, select the file you want, and then click Open.
If a document is already open in LibreOffice, the second document
opens in a new window.
In the Open dialog, you can reduce the list of
files by selecting the type of file you are looking for. For example,
if you choose Text documents as the file type, you will only see
documents Writer can open (including .odt, .doc, .txt); if you choose
Spreadsheets, you will see .ods, .xls, and other files that Calc
opens.
You can also open an existing document that is in
a format that LibreOffice recognizes by double-clicking on the file
icon on the desktop or in a file manager such as Windows Explorer.
LibreOffice has to be associated with file types that are not ODF
files for the appropriate LibreOffice component to open.
- Note
When opening files stored in a remote server, you may be asked to
enter your user name and password to log in the server.
Saving
documents
You can save documents as follows:
- Save – use if you are keeping the document, its current filename and location.
- Save Remote – use if your document is already stored in a remote server or will be stored in a remote server.
- Save As – use to create a new document, or change the filename and/or file format, or save the file in a different location on your computer.
- Save a Copy – use to save a copy of your current document and keep it open for more editing.
- Save All – use to save all the files open in your current session.
Save
command
To
save a document if you are keeping the document’s current filename
and location, do one of the following:
- Use the menu option File > Save.
- Use the keyboard shortcut Ctrl+S.
- Click the Save icon on the Standard toolbar.
- Use the menu option File > Save All.
- Use the menu option File > Save Remote.
- Use the menu option File > Save a Copy (similar to the Save As command).
Using the Save command will immediately overwrite
the last saved version of the file.
Save
As command
If you want to create a new document file, change
the filename and/or file format, or save the file in a different
location on your computer:
- Use the keyboard shortcut Ctrl+Shift+S.
- Use the menu option File > Save As.
When the Save As dialog (Figure 10)
or Save dialog opens, enter the file name, change the file type (if
applicable), navigate to a new location (if applicable), and click
Save.
Password
protection
To restrict who can open and read a document, or
open and edit the document, use password protection.
- Using the Save As command above, select the Save with password option in the Save As dialog or Save dialog.
- Click Save and the Set Password dialog opens (Figure 11).
- In File Encryption Password, enter a password to open the document and then enter the same password as confirmation.
- To restrict wh