Calc Guide

Index
3
3D chart
appearance 89
area chart 98
bar chart 96
elements 79
formatting 87
illumination 89
line chart 99
moving elements 86
pie chart 96
rotation and perspective 88
rotation, interactive 90
types 75
A
absolute reference 190
advanced functions 217
anchor, visible 403
anchoring of objects 150
appearance of 3D chart 89
appearance options 395
Apply Style list 12, 110
area charts 97
arguments in functions 197, 429
arithmetic operators 182
array functions 468
arrow keys
navigating within spreadsheets 24
assign styles to shortcut keys 111
auto filters 367
AutoCorrect options 409
AutoInput 45
automatic changes, deactivating 44
automatic saving 20
axes labels 76
B
background
cell styles 113
bar charts 95
Base, editing data sources 315
borders
cell styles 113
bubble charts 100
C
Calc options
calculate 404
case sensitive 406
changes 408
dates 405
grid 408
grid lines, viewing 402
guides while moving 403
handles 403
input settings 401
iterative references 405
page breaks, visible 403
screen display 403
sort lists 407
unit of measurement 400
updating links 401
Zoom 404
calculation options 404
calculation order 192
calculations linking sheets 192
case sensitive sorting 66
cell alignment and orientation 57
cell protection 113
cell styles
alignment options 113
applying 109
background 113
border options 113
description 107
Fill Format mode 110
font effects 113
font options 113
linked with 112
numbers 113
cells
description 10, 14
focus 23
hiding and showing 63
information on status bar 15
range 27
selecting 27
validating contents 49
changes
accepting or rejecting 334
adding comments 329
editing comments 330
490 OpenOffice.org 3.x Calc Guide