Calc Guide

dialog 244
examples of use 219
filter 260
GETPIVOTDATA 267
group date or time values 255
group rows or columns 253
group scalar values 254
group without intervals 256
multiple data fields 262
page fields 253
preconditions 241
refresh 261
row or column fields 250
shortcuts 266
sort results 257
starting 242
DataPilot Tools 421
date conversion, automatic 45
date functions 458
dates and times, entering 43
DDE link
description 320
in Calc 320
in Writer 321
default template 124
deleting
columns and rows 31
sheets 33
Detective 208
digital rights management (DRM) 172
digital signature 175
digital signature
status bar indicator 15
documents
comparing 337
merging 335
drag and drop 132
drag mode 40
drawing object properties 147
Drawing Object Properties toolbar 147
drawing objects
grouping 148
properties 147
resizing 148
Drawing toolbar 147
drawing tools 145
Dynamic Data Exchange (DDE) 320
E
e-mailing
several recipients 174
Writer document as attachment 174
editing data
changing the contents of cell 52
removing data from a cell 51
replacing cell data 52
en and em dashes, entering 44
Enter key 26
EPS images in PDF 169
Err:503 Division by zero 206
error codes
common messages 487
displayed within cells 486
introduction 485
error messages 205, 210
error-checking formulas 179
errors, finding and fixing 205
EuroOffice Solver 293
export directly as PDF 167
exporting to PDF 167
Extension Manager 123
extensions
DataPilot Tools 421
installing 420
introduction 420
Professional Template Pack 421
Solver for Nonlinear Programming
421
External Data dialog 307
F
FDF 169
features 10
file sharing options 393, 395
Fill Format mode 110
fill series
defining 47
using 46
Fill tool 45
filled net charts 101
filtering 367
filters
advanced 372
auto 367
standard 368
financial analysis functions 435
find and replace
cell styles 69
Find & Replace dialog 68
formulas or values 68
regular expressions 69
text 69
492 OpenOffice.org 3.x Calc Guide