Calc Guide

pictures
linking 120
resizing 128
transparency 126
pie chart 90
Position and Size dialog 88
Position and Size of graphics 129
precision 355
prepare document for review 287
print file directly 139
print options 343
printer metrics 352
printing
choosing what to print 139
general options 140
multiple pages per sheet 140
page orientation 140
selecting what to print 141
Professional Template Pack 368
Properties dialog 41
protect a document 287
Q
Quickstarter
Windows 18
R
range
database 319
named 315
range operators 167
record changes 286
reference operators 166
references in color 354
referencing
other spreadsheets 266
sheets 263
regular expressions 67
enable in formulas 356
in functions 191
relative reference 169
relief options 56
remove personal information on saving 345
removing data from a cell 52
renaming
sheets 34
replacing all data in a cell 52
resolution options 358
rotating images 128
rotation of chart 82
rounding methods 189
rounding off numbers 189
rows
deleting 32
freezing 35
hiding and showing 62
inserting 32
selecting 30
S
save original Basic code 348
saving AutoRecovery info 22
saving spreadsheets
as CSV file 24
as HTML 24
methods 22
to Microsoft Excel format 22
scatter chart 93
scenarios 245
security 24
selecting
cells 29
columns and rows 30
sheets 31
selection list 49
selection mode indicator 17
send document as e-mail 157
shared extension 367
shared spreadsheet
introduction 284
opening 285
saving 285
setting up 284
sheet tabs 16
sheets
deleting 33
description 10
hiding and showing 62
identifying 260
inserting 33, 261
inserting from other spreadsheets 263
navigating 28
referencing 263
renaming 34, 260
searching 66
selecting 31
sequence number 17
sharing contents 49
shrinking text to fit cell 54
size optimization 348
snap grid 357
Solver 256
Solver for Nonlinear Programming 258, 368
sort lists
options 356
sorting 320
sorting
using macros 311
sorting records
case sensitive 65
method 63
special characters 45
splitting the screen 36
spreadsheet
create from template 109
432 OpenOffice.org 3.3 Calc Guide