Libre Office

 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 

What’s new in LibreOffice 6.0?..................................................................................................15 

Chapter 1 Introducing LibreOffice.............................................................................................16

 What is LibreOffice?...................................................................................................................17 Advantages of LibreOffice..........................................................................................................18 Minimum requirements..............................................................................................................18

 How to get the software.............................................................................................................19 

How to install the software.........................................................................................................19 Extensions and add-ons............................................................................................................19 

Starting LibreOffice....................................................................................................................19

 Parts of the main window...........................................................................................................22 

Starting new documents............................................................................................................27

 Opening existing documents......................................................................................................28

 Saving documents.....................................................................................................................29 Password protection..................................................................................................................30 

Opening and saving files on remote servers..............................................................................31 Renaming and deleting files.......................................................................................................32 Using the Navigator...................................................................................................................32 Undoing and redoing changes...................................................................................................33 Reloading a document...............................................................................................................33 Closing a document...................................................................................................................33 Closing LibreOffice.....................................................................................................................34 Chapter 2 Setting up LibreOffice......................................................................................35 Using LibreOffice on macOS......................................................................................................36 Choosing options for all of LibreOffice.......................................................................................36 Choosing options for loading and saving documents.................................................................50 Choosing language settings.......................................................................................................55 Choosing Internet options..........................................................................................................60 Controlling LibreOffice’s AutoCorrect functions..........................................................................60 Troubleshooting LibreOffice in Safe Mode.................................................................................61 Chapter 3 Using Styles and Templates............................................................................63 Direct formatting........................................................................................................................64 What are styles?........................................................................................................................64 Applying styles...........................................................................................................................65 Contents | 3 Creating and modifying styles....................................................................................................67 Creating new (custom) styles.....................................................................................................69 

Copying styles from a template or document.............................................................................71 Deleting styles...........................................................................................................................72 What is a template?...................................................................................................................72 Using a template to create a document.....................................................................................73 Creating a template...................................................................................................................73 Editing a template......................................................................................................................75 Adding templates obtained from other sources..........................................................................76 Setting a default template..........................................................................................................77 Organizing templates.................................................................................................................78 Examples of style use................................................................................................................80 Chapter 4 Getting Started with Writer..............................................................................82 What is Writer?..........................................................................................................................83 The Writer interface...................................................................................................................83 Changing document views.........................................................................................................88 Moving quickly through a document...........................................................................................89 Working with documents............................................................................................................90 Using built-in language tools......................................................................................................90 Working with text.......................................................................................................................91 Formatting text.........................................................................................................................100 Formatting pages.....................................................................................................................107 Adding comments to a document.............................................................................................112 Creating a table of contents.....................................................................................................113 Creating indexes and bibliographies........................................................................................113 Working with graphics..............................................................................................................113 Printing.....................................................................................................................................114 Using mail merge.....................................................................................................................114 Tracking changes to a document.............................................................................................114 Using fields..............................................................................................................................115 Linking and cross-referencing within a document.....................................................................115 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..................................................................................................................124 Saving spreadsheets...............................................................................................................126 Navigating within spreadsheets...............................................................................................127 Selecting items in a spreadsheet.............................................................................................131 Working with columns and rows...............................................................................................133 4| Contents Working with sheets.................................................................................................................134 Viewing Calc............................................................................................................................136 Using the keyboard..................................................................................................................138 Speeding up data entry............................................................................................................142 Sharing content between sheets..............................................................................................145 Validating cell contents............................................................................................................145 Editing data..............................................................................................................................146 Formatting data........................................................................................................................147 AutoFormatting of cells............................................................................................................150 Using themes...........................................................................................................................151 Using conditional formatting.....................................................................................................153 Hiding and showing data..........................................................................................................153 Cell protection..........................................................................................................................154 Sorting records........................................................................................................................155 Cell comments.........................................................................................................................156 Using formulas and functions...................................................................................................156 Analyzing data.........................................................................................................................157 Pivot tables and pivot charts....................................................................................................157 Printing....................................................................................................................................158 Chapter 6 Getting Started with Impress........................................................................163 What is Impress?.....................................................................................................................164 Starting Impress.......................................................................................................................164 Main Impress window..............................................................................................................165 Workspace views.....................................................................................................................168 Formatting a presentation........................................................................................................172 Adding and formatting text.......................................................................................................177 Adding pictures, tables, charts, and media..............................................................................182 Working with slide masters and styles.....................................................................................184 Adding comments to a presentation.........................................................................................191 Creating a photo album............................................................................................................191 Setting up a slide show............................................................................................................193 Using Impress Remote control.................................................................................................195 Chapter 7 Getting Started with Draw.............................................................................198 What is Draw?.........................................................................................................................199 Draw main window...................................................................................................................199 Working with layers..................................................................................................................202 Choosing and defining colors...................................................................................................203 Drawing basic shapes..............................................................................................................205 Glue points and connectors......................................................................................................211 Drawing geometric shapes......................................................................................................212 Selecting objects......................................................................................................................213 Moving and adjusting object size.............................................................................................214 Rotating and slanting an object................................................................................................216 Editing objects.........................................................................................................................217 Contents | 5 Formatting area fill...................................................................................................................220 Using styles.............................................................................................................................220 Positioning objects...................................................................................................................221 Applying special effects...........................................................................................................222 Combining multiple objects......................................................................................................225 Arranging, aligning, and distributing objects.............................................................................226 Inserting and editing pictures...................................................................................................226 Working with 3D objects..........................................................................................................227 Exporting graphics...................................................................................................................227 Inserting comments in a drawing.............................................................................................227 Chapter 8 Getting Started with Base.............................................................................229 Introduction..............................................................................................................................230 Planning a database................................................................................................................231 Creating a new database.........................................................................................................232 Creating database tables.........................................................................................................233 Creating a database form........................................................................................................241 Entering data in a form.............................................................................................................253 Creating queries......................................................................................................................256 Creating reports.......................................................................................................................264 Accessing other data sources..................................................................................................267 Using data sources in LibreOffice............................................................................................268 Chapter 9 Getting Started with Math..............................................................................273 Introduction..............................................................................................................................274 Getting started.........................................................................................................................274 Creating formulas....................................................................................................................276 Editing formulas.......................................................................................................................279 Formula layout.........................................................................................................................280 Changing formula appearance.................................................................................................286 Formulas in Writer....................................................................................................................291 Formulas in Calc, Draw, and Impress......................................................................................296 Chapter 10 Printing, Exporting, E-mailing and Signing Documents..........................298 Quick printing...........................................................................................................................299 Controlling printing...................................................................................................................299 Exporting to PDF.....................................................................................................................307 Exporting to EPUB format........................................................................................................314 Exporting to other formats........................................................................................................315 E-mailing documents...............................................................................................................315 Digital signing of documents....................................................................................................317 Removing personal data..........................................................................................................319 Chapter 11 Graphics, Gallery, Fontwork........................................................................321 Introduction..............................................................................................................................322 Adding images to a document..................................................................................................322 Modifying, handling, and positioning graphics..........................................................................326 Managing the LibreOffice Gallery.............................................................................................327 6| Contents Creating an image map............................................................................................................329 Using LibreOffice’s drawing tools.............................................................................................330 Using Fontwork........................................................................................................................333 Chapter 12 Creating HTML Files.....................................................................................338 Introduction..............................................................................................................................339 Relative and absolute hyperlinks.............................................................................................339 Creating hyperlinks..................................................................................................................340 Saving and exporting documents as HTML files......................................................................343 Creating, editing, and saving HTML files using Writer/Web......................................................349 Checking a web page in a browser..........................................................................................350 Chapter 13 Getting Started with Macros.......................................................................351 Introduction..............................................................................................................................352 Your first macros......................................................................................................................352 Creating a macro.....................................................................................................................358 Macro recorder failures............................................................................................................362 Macro organization..................................................................................................................363 How to run a macro..................................................................................................................366 Extensions...............................................................................................................................368 Writing macros without the recorder.........................................................................................369 Finding more information.........................................................................................................369 Chapter 14 Customizing LibreOffice..............................................................................371 Introduction..............................................................................................................................372 Customizing menu content......................................................................................................372 Customizing context menu contents........................................................................................374 Customizing toolbars...............................................................................................................375 Assigning shortcut keys...........................................................................................................377 Assigning macros to events.....................................................................................................379 Adding functionality with extensions........................................................................................379 Appendix A Keyboard Shortcuts....................................................................................382 Introduction..............................................................................................................................383 General keyboard shortcuts.....................................................................................................384 Navigating and selecting with the keyboard.............................................................................385 Controlling dialogs...................................................................................................................385 Controlling macros...................................................................................................................386 Managing documents...............................................................................................................386 Editing......................................................................................................................................386 Selecting rows and columns in a database table opened by Ctrl+Shift+F4..............................387 Shortcut keys for drawing objects............................................................................................387 Defining keyboard shortcuts....................................................................................................388 Further reading........................................................................................................................388 Appendix B Open Source, Open Standards, OpenDocument....................................389 Introduction..............................................................................................................................390 A short history of LibreOffice....................................................................................................390 Contents | 7 The LibreOffice community......................................................................................................390 How is LibreOffice licensed?....................................................................................................391 What is “open source”?............................................................................................................391 What are “open standards”?....................................................................................................391 What is OpenDocument?.........................................................................................................391 File formats LibreOffice can open............................................................................................392 File formats LibreOffice can save to.........................................................................................394 Exporting to other formats........................................................................................................395