Calc Guide

Modifying images............................................................................136
Using the picture context menu......................................................142
Using Calc’s drawing tools..............................................................145
Positioning graphics........................................................................148
Creating an image map...................................................................151
Chapter 6
Printing, Exporting, and E-mailing........................................154
Quick printing.................................................................................155
Controlling printing........................................................................155
Using print ranges..........................................................................159
Page breaks..................................................................................... 163
Headers and footers........................................................................164
Exporting to PDF............................................................................167
Exporting to XHTML.......................................................................173
Saving as Web pages (HTML).........................................................174
E-mailing spreadsheets...................................................................174
Digital signing of documents..........................................................175
Removing personal data.................................................................176
Chapter 7
Using Formulas and Functions...............................................177
Introduction....................................................................................178
Setting up a spreadsheet................................................................178
Creating formulas...........................................................................180
Understanding functions.................................................................197
Strategies for creating formulas and functions...............................203
Finding and fixing errors................................................................205
Examples of functions.....................................................................210
Using regular expressions in functions...........................................215
Advanced functions.........................................................................217
Chapter 8
Using the DataPilot................................................................218
Introduction....................................................................................219
Examples with step by step instructions.........................................219
OpenOffice.org 3.x Calc Guide 5