Copyright
Contributors
To this edition
To previous editions
Feedback
Publication date and software version
Who is this book for?
What’s in this book?
Where to get more help
Help system
Other free online support
Paid support and training
What you see may be different
Illustrations
Icons
Using LibreOffice on macOS
What are all these things called?
Frequently asked questions
What’s new in LibreOffice 6.0?
What is LibreOffice?
Writer (word processor)
Calc (spreadsheet)
Impress (presentations)
Draw (vector graphics)
Base (database)
Math (formula editor)
Advantages of LibreOffice
Minimum requirements
How to get the software
How to install the software
Extensions and add-ons
Starting LibreOffice
Opening an existing document before starting LibreOffice
Quickstarter
Activating Quickstarter
Using Quickstarter on Linux or Windows
Disabling Quickstarter
Reactivating Quickstarter
Parts of the main window
Menu bar
Toolbars
Displaying or hiding toolbars
Sub-menus and tool palettes
Moving toolbars
Floating toolbars
Customizing toolbars
Context menus
Status bar
Sidebar
Starting new documents
Opening existing documents
Saving documents
Save command
Save As command
Password protection
Changing the password
Saving documents automatically
Opening and saving files on remote servers
Renaming and deleting files
Using the Navigator
Undoing and redoing changes
Reloading a document
Closing a document
Closing LibreOffice
Using LibreOffice on macOS
Choosing options for all of LibreOffice
User Data options
General options
View options
Print options
Paths options
Fonts options
Security options
Security options and warnings
Personalization
Application colors
Accessibility options
Advanced options
Basic IDE options
Online update options
OpenCL options
Choosing options for loading and saving documents
General
VBA Properties
Microsoft Office
HTML compatibility
Choosing language settings
Install the required dictionaries
Change some locale and language settings
Choose spelling options
English sentence checking
Grammar checking
Punctuation
Others
Other languages sentence checking
Choosing Internet options
Controlling LibreOffice’s AutoCorrect functions
Troubleshooting LibreOffice in Safe Mode
Direct formatting
What are styles?
Applying styles
Using the Styles menu in Writer
Using the sidebar Styles deck
Using Fill Format Mode
Using the Set Paragraph Style list
Using keyboard shortcuts
Direct formatting and Style formatting
Creating and modifying styles
Changing a style using the Styles deck
Updating a style from a selection
Using AutoUpdate
Updating styles from a document or template
Creating new (custom) styles
Creating a new style using the New Style dialog
Creating a new style from a selection
Dragging and dropping to create a style
Adding table styles in Writer
Copying styles from a template or document
Deleting styles
What is a template?
Using a template to create a document
Creating a document from the Templates dialog
Creating a document from a template in the Start Center
Creating a template
Creating a template from a document
Creating a template using a wizard
Editing a template
Updating a document from a changed template
Adding templates obtained from other sources
Installing individual templates
Installing collections of templates
Setting a default template
Setting a template as the default
Resetting the default template
Organizing templates
Creating a template category
Deleting a template category
Moving a template
Deleting a template
Importing a template
Exporting a template
Examples of style use
Defining a different first page for a document
Dividing a document into chapters
Changing page orientation within a document
Displaying different headers on right and left pages
Controlling page breaks automatically
Compiling an automatic table of contents
Defining a sequence of paragraph styles
Formatting a table in Writer
What is Writer?
The Writer interface
Status Bar
Sidebar
Properties Deck
Page Deck
Styles Deck
Gallery Deck
Navigator Deck
Manage Changes Deck
Design Deck
Changing document views
Moving quickly through a document
Using the Navigator
Using Go to Page Option
Working with documents
Saving as a Microsoft Word file
Using built-in language tools
Options for applying languages
Using styles
Using direct formatting
Preventing text from being checked for spelling
Obtaining resources for additional languages
Working with text
Selecting items that are not consecutive
Selecting a vertical block of text
Cutting, copying, and moving text
Pasting text
Finding and replacing text and formatting
Using the Find toolbar
Using the Find & Replace dialog
Inserting special characters
Inserting dashes and non-breaking spaces and hyphens
Inserting non-breaking spaces
Inserting non-breaking hyphens
Inserting en and em dashes
Checking spelling and grammar
Checking spelling automatically
Checking spelling and grammar
Using synonyms and the thesaurus
Using AutoCorrect
Using Word Completion
Using AutoText
Formatting text
Using styles is highly recommended
Formatting paragraphs using styles
Formatting paragraphs directly
Removing direct formatting
Formatting characters using styles
Formatting characters directly
Formatting tables
AutoCorrection
Creating lists with styles
Creating bulleted and numbered lists
Creating nested lists
Creating lists with direct formatting
Creating bulleted and numbered lists
Creating nested lists
Setting tab stops and indents
Changing the default tab stop interval
Changing measurement units for tab stops and rulers
Hyphenating words
Automatic hyphenation using styles
Setting Hyphenation with Writing Aids
Manual hyphenation
Formatting pages
Creating headers and footers
Inserting a header or footer
Determining header and footer appearance
Inserting document title in headers and footers
Numbering pages
Displaying the page number
Including the total number of pages
Restarting page numbering
Changing page margins
Adding a custom watermark to the page background
Adding comments to a document
Formatting comments
Navigating through comments
Printing comments
Creating a table of contents
Creating indexes and bibliographies
Working with graphics
Printing
Using mail merge
Tracking changes to a document
Using fields
Linking and cross-referencing within a document
Using hyperlinks
Creating and using cross-references
Using bookmarks
Using master documents
Classifying document contents
Creating fill-in forms
What is Calc?
Compatibility with other spreadsheet applications
Wildcards
Formula syntax
Macros
Spreadsheets, sheets, and cells
Calc main window
Title bar
Menu bar
Toolbars
Formula bar
Status bar
Sidebar
Spreadsheet layout
Individual cells
Sheet tabs
Opening a CSV file
Saving spreadsheets
Saving in other spreadsheet formats
Exporting contents as image
Navigating within spreadsheets
Cell navigation
Sheet navigation
Keyboard navigation
Customizing the Enter key
Selecting items in a spreadsheet
Selecting cells
Single cell
Range of contiguous cells
Range of non-contiguous cells
Selecting columns and rows
Single column or row
Multiple columns or rows
Entire sheet
Selecting sheets
Single sheet
Multiple contiguous sheets
Multiple non-contiguous sheets
All sheets
Hiding and showing sheets
Working with columns and rows
Inserting columns and rows
Single column or row
Multiple columns or rows
Deleting columns and rows
Single column or row
Multiple columns or rows
Working with sheets
Inserting new sheets
Moving and copying sheets
Dragging and dropping
Using a dialog
Deleting sheets
Renaming sheets
Viewing Calc
Changing document view
Freezing rows and columns
Freezing rows or columns
Unfreezing
Splitting the screen
Splitting horizontally or vertically
Removing split views
Using the keyboard
Numbers
Minus numbers
Leading zeroes
Numbers as text
Text
Date and time
AutoCorrection options
Replace
Exceptions
Options
Localized options
Reset
Deactivating automatic changes
Speeding up data entry
Using the Fill tool
Using a fill series
Defining a fill series
Defining a fill series from a range in a sheet
Using selection lists
Sharing content between sheets
Validating cell contents
Editing data
Deleting data
Deleting data only
Deleting data and formatting
Replacing data
Changing data
Using the keyboard
Using the mouse
Formatting data
Multiple lines of text
Automatic wrapping
Manual line breaks
Shrinking text to fit the cell
Formatting numbers
Formatting fonts and text in cells
Formatting cell borders
Formatting cell background
Formatting default cell styles
AutoFormatting of cells
Using AutoFormat
Defining a new AutoFormat
Using themes
Using conditional formatting
Hiding and showing data
Hiding data
Showing data
Cell protection
Sorting records
Cell comments
Using formulas and functions
The Function Wizard and Function Search
Analyzing data
Pivot tables and pivot charts
Pivot charts
Printing
Print ranges
Defining a print range
Adding to a print range
Removing a print range
Editing a print range
Printing options
Repeat printing of rows or columns
Page breaks
Inserting a break
Deleting a page break
Headers and footers
Setting a header or footer
What is Impress?
Starting Impress
Main Impress window
Workspace
Slides pane
Sidebar
Toolbars
Status bar
Workspace views
Normal view
Outline view
Notes view
Handout view
Slide Sorter view
Customizing Slide Sorter view
Moving a slide using Slide Sorter
Selecting and moving groups of slides
Working in Slide Sorter view
Formatting a presentation
Inserting slides
New slide
Duplicate slide
Selecting slide layout
Modifying slide elements
Adding text
Adding objects
Modifying the appearance of all slides
Modifying the slide show
Adding and formatting text
Using AutoLayout text boxes
Using text boxes
Vertical text
Quick font resizing
Pasting text
Pasting unformatted text
Formatting pasted text
Creating bulleted and numbered lists
AutoLayout text boxes
Text boxes
Creating a new outline level
Changing list appearance
Adding pictures, tables, charts, and media
Adding pictures
Adding tables
Adding charts
Adding media files
Adding graphics, spreadsheets, and other objects
Working with slide masters and styles
Styles
Slide masters
Creating a slide master
Applying a slide master
Loading additional slide masters
Modifying a slide master
Adding text, footers, and fields to all slides
Text
Footers
Fields
Adding comments to a presentation
Creating a photo album
Setting up a slide show
One slide set – multiple presentations
Hiding slides
Custom slide shows
Slide transitions
Slide advance
Running a slide show
Presenter Console
Using Impress Remote control
Getting Impress Remote
Connecting the mobile device to the computer
Enabling remote control in Impress
Running a slide show with Impress Remote
What is Draw?
Draw main window
Workspace
Pages pane
Layers bar
Sidebar
Rulers
Status bar
Toolbars
Standard toolbar
Drawing toolbar
Line and Filling toolbar
Text Formatting toolbar
Options toolbar
Working with layers
Adding a layer
Choosing and defining colors
Drawing basic shapes
Drawing a straight line
Drawing an arrow
Choosing line endings
Drawing a dimension line
Drawing rectangles or squares
Drawing circles or ellipses
Drawing curves or polygons
Curves
Polygons
Polygons 45°
Freeform lines
Adding text
Glue points and connectors
Glue points
Connectors
Drawing geometric shapes
Basic shapes
Symbol shapes
Block arrows
Flowcharts
Callouts
Stars and banners
Selecting objects
Direct selection
Selection by framing
Selecting hidden objects
Arranging objects
Moving and adjusting object size
Moving objects
Adjusting object size
Rotating and slanting an object
Rotating an object
Slanting an object
Editing objects
Line and Filling toolbar
Text Formatting toolbar
Sidebar Properties
Context menu
Formatting lines and borders
Arrows, arrowheads, and line endings
Formatting area fill
Using styles
Positioning objects
Snap function
Snap to grid
Displaying the grid
Configuring the grid
Help lines
Applying special effects
Flipping objects
Mirror copies
Distorting an object
Dynamic transparency gradients
Duplication
Cross-fading
Combining multiple objects
Grouping
Temporary grouping
Permanent grouping
Ungrouping
Combining objects
Arranging, aligning, and distributing objects
Inserting and editing pictures
Working with 3D objects
Exporting graphics
Inserting comments in a drawing
Introduction
Planning a database
Creating a new database
Creating database tables
Using the Wizard to create a table
Creating a table by copying an existing table
Creating tables in Design View
Defining relationships
Creating a database form
Using the Wizard to create a form
Modifying a form
Creating forms and sub forms in Design View
Entering data in a form
Quickly populate a table with data from a spreadsheet
Creating queries
Using the Wizard to create a query
Using the Design View to create a query
Creating reports
Creating a report: Example
Report wizard vs Report Design View
Vacations table report
Report Builder: another way to create reports
Accessing other data sources
Accessing a spreadsheet as a data source
Registering *.odb databases
Using data sources in LibreOffice
Viewing data sources
Editing data sources
Launching Base to work on data sources
Using data sources in Writer and Calc
Writer documents
Calc spreadsheets
Introduction
Getting started
Formulas as separate documents or files
File formats for formulas
Formulas in LibreOffice documents
Creating formulas
Elements window
Context menu
Markup language
Greek characters
Using markup language
Symbols dialog
Formula examples
Example 1
Example 2
Editing formulas
Formula layout
Using braces
Brackets and matrices
Unpaired brackets
Non-scalable brackets
Scalable brackets
Recognizing functions
Formulas over multiple lines
Adding limits to sum/integral commands
Writing derivatives
Markup language characters as normal characters
Text in formulas
Aligning formulas using equals sign
Changing formula appearance
Formula font size
Current formula font size
Default formula font size
Formula fonts
Current formula fonts
Default formula fonts
Adjusting formula spacing
Current formula spacing
Default formula spacing
Adjusting formula alignment
Current formula alignment
Default formula alignment
Changing formula color
Character color
Background color
Formula library
Using Math
Using Writer, Calc, Draw, or Impress
Using your formula library
Formulas in Writer
Automatic formula numbering
Numbering
Cross-referencing
Anchoring formulas
Vertical alignment
Object spacing
Text mode
Background and borders
Backgrounds
Borders
Quick insertion of formulas
Formulas in Calc, Draw, and Impress
Anchoring formulas
Calc
Draw and Impress
Formula object properties
Formulas in charts
Quick printing
Controlling printing
Selecting general printing options
Printing multiple pages on a single sheet of paper
Selecting pages/sheets/slides to print
Writer
Calc
Impress and Draw
Printing handouts, notes, or outlines in Impress
Printing a brochure
Printing envelopes, labels, business cards
Printing in black and white (on a color printer)
Previewing pages/sheets before printing
Writer
Calc
Exporting to PDF
Quick export to PDF
Controlling PDF content and quality
General page of PDF Options dialog
Initial View page of PDF Options dialog
User Interface page of PDF Options dialog
Links page of PDF Options dialog
Security page of PDF Options dialog
Digital Signatures page of PDF Options dialog
Exporting to EPUB format
Quick export to EPUB
Export to EPUB
Exporting to other formats
E-mailing documents
E-mailing a document to several recipients
Digital signing of documents
Signing multiple times with same signature
Removing personal data
Introduction
Adding images to a document
Inserting an image file
Drag and drop
Insert Image dialog
Linking an image file
Embedding linked images
Inserting an image from the clipboard
Inserting an image using a scanner
Inserting an image from the Gallery
Inserting an image as a background
Modifying, handling, and positioning graphics
Exporting images
Compressing images
Managing the LibreOffice Gallery
Adding objects to the Gallery
Deleting images from the Gallery
Adding a new theme to the Gallery
Deleting a theme from the Gallery
Location of the Gallery and the objects in it
Creating an image map
Using LibreOffice’s drawing tools
Creating drawing objects
Setting or changing properties for drawing objects
Resizing a drawing object
Grouping drawing objects
Using Fontwork
Creating a Fontwork object
Editing a Fontwork object
Using the Fontwork toolbar
Using the Formatting toolbar
Using menu options
Using the 3D-Settings toolbar
Moving and resizing Fontwork objects
Introduction
Relative and absolute hyperlinks
Creating hyperlinks
Using the Navigator
Using the Hyperlink dialog
Editing hyperlinks
Removing hyperlinks
Saving and exporting documents as HTML files
Writer documents
Saving a Writer document as an HTML file
Exporting a single web page
Saving as a series of web pages
Calc spreadsheets
Impress presentations
Draw documents
Creating, editing, and saving HTML files using Writer/Web
Writer/Web display modes
Creating and editing an HTML document
Checking a web page in a browser
Introduction
Your first macros
Adding a macro
Recording a macro
Running a macro
Viewing and editing macros
Commenting with REM
Defining subroutines with SUB
Defining variables using Dim
Explaining macro code
Creating a macro
A more complicated example of a macro
Running a macro quickly
Macro recorder failures
Dispatch framework
How the macro recorder uses the dispatch framework
Other options
Macro organization
Where are macros stored?
Importing macros
Downloading macros to import
How to run a macro
Toolbars, menu items, and keyboard shortcuts
Events
Extensions
Writing macros without the recorder
Finding more information
Included material
Online resources
Printed and eBook materials
Introduction
Customizing menu content
Creating a new menu
Modifying existing menus
Adding a command to a menu
Modifying menu entries
Customizing context menu contents
Customizing toolbars
Modifying existing toolbars
Creating a new toolbar
Choosing icons for toolbar commands
Assigning shortcut keys
Example: Assigning styles to shortcut keys
Saving changes to a file
Loading a saved keyboard configuration
Resetting the shortcut keys
Assigning macros to events
Adding functionality with extensions
Installing extensions
Introduction
Assistive tools in LibreOffice
Tip for Macintosh users
Getting help
General keyboard shortcuts
Opening menus and menu items
Accessing a menu command
Running a toolbar command
Navigating and selecting with the keyboard
Controlling dialogs
Controlling macros
Managing documents
Editing
Selecting rows and columns in a database table opened by Ctrl+Shift+F4
Shortcut keys for drawing objects
Defining keyboard shortcuts
Further reading
Introduction
A short history of LibreOffice
The LibreOffice community
How is LibreOffice licensed?
What is “open source”?
What are “open standards”?
What is OpenDocument?
OpenDocument filename extensions
File formats LibreOffice can open
Opening text documents
Opening spreadsheets
Opening presentations
Opening graphic files
Opening formula files
File formats LibreOffice can save to
Saving text documents
Saving spreadsheet files
Saving presentations
Saving drawings
Writer/Web can save in these formats
Exporting to other formats