Getting Started with LibreOffice 6.0

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