Selecting items in a spreadsheet............................................................................................. 128
Working with columns and rows............................................................................................... 130
Working with sheets................................................................................................................. 132
Viewing Calc............................................................................................................................ 134
Using the keyboard.................................................................................................................. 136
Speeding up data entry............................................................................................................ 140
Sharing content between sheets.............................................................................................. 143
Validating cell contents............................................................................................................ 144
Editing data.............................................................................................................................. 144
Formatting data........................................................................................................................ 146
AutoFormatting of cells............................................................................................................ 149
Using themes........................................................................................................................... 150
Using conditional formatting..................................................................................................... 150
Hiding and showing data.......................................................................................................... 151
Sorting records........................................................................................................................ 152
Using formulas and functions................................................................................................... 153
Analyzing data......................................................................................................................... 153
Printing.................................................................................................................................... 154
Chapter 6 Getting Started with Impress........................................................................ 158
What is Impress?..................................................................................................................... 159
Starting Impress....................................................................................................................... 159
Main Impress window.............................................................................................................. 159
Workspace views..................................................................................................................... 163
Creating a new presentation using the Presentation Wizard.................................................... 167
Formatting a presentation........................................................................................................ 170
Adding and formatting text....................................................................................................... 174
Adding pictures, tables, charts, and media.............................................................................. 179
Working with slide masters and styles..................................................................................... 182
Adding comments to a presentation......................................................................................... 189
Setting up a slide show............................................................................................................ 190
Using Impress Remote control................................................................................................. 192
Chapter 7 Getting Started with Draw............................................................................. 195
What is Draw?......................................................................................................................... 196
Draw main window................................................................................................................... 196
Working with layers.................................................................................................................. 200
Choosing and defining colors................................................................................................... 201
Drawing basic shapes.............................................................................................................. 202
Glue points and connectors..................................................................................................... 207
Drawing geometric shapes...................................................................................................... 209
Selecting objects...................................................................................................................... 210
Moving and adjusting object size............................................................................................. 212
Rotating and slanting an object................................................................................................ 213
Editing objects......................................................................................................................... 214
Formatting area fill................................................................................................................... 217
Getting Started with LibreOffice 5.1 | 5
