Calc Guide

Microsoft Office file conversion 398
moving chart elements 86
moving from sheet to sheet 26
Multiple Operations tool 281
multiple sheets
introduction 295
setting up 295
N
named range 359
navigating within spreadsheets
cell reference 23
focus 23
keyboard 24
methods 23
Navigator 23, 38
scenarios 280
nested functions 198
net charts 101
nonlinear programming solver 293
numbers as text, entering 42
numbers, entering 42
O
Object Linking and Embedding (OLE)
316
ODF plugin (Sun) 20
OLE object
linked 319
non-linked 319
other (Windows) 318
OpenDocument Format 397
opening spreadsheets 17
order of calculation 192
outline group controls 63
overlining 56
OXT extension 123
P
page breaks, visible 403
page style on status bar 15
page styles
applying 111
background 115
borders 115
description 107, 108
options 113
sheet settings 115
paper format 114
password protection 20
password-protect PDF 172
PDF
blank page export 169
digital rights management (DRM) 172
encrypt 172
EPS images 169
export documents to 167
form 169
image compression and resolution 168
initial view selection 169
pages to export 167
password-protect 172
security settings 172
tagged 169
user interface settings 169
PDF Options dialog 167
PDF/A-1 169
perspective of chart 88
picture context menu 142
Picture toolbar 136
pictures
linking 132
resizing 141
transparency 139
pie charts 96
Position and Size dialog for chart 94
Position and Size of graphics 143
precision 406
prepare document for review 326
Print dialog 155
print file directly 155
print options 391
printer metrics 402
printing
choosing what to print 155
printer selection 155
protect a document 326
R
range
database 364
named 359
range operators 186
record changes 326
reference operators 186
references in color 404
referencing
other spreadsheets 301
sheets 299
regular expressions 69
enable in formulas 406
in functions 215
Index 495