Calc Guide

relative reference 189
relief options 56
remove personal information on saving
394
removing data from a cell 51
renaming
sheets 33
replacing cell data 52
resolution options 409
rofessional Template Pack 421
rotating images 142
rotation
chart 88
rounding methods 213
rounding off numbers 213
rows
deleting 31
freezing 34
hiding and showing 63
inserting 30
selecting 29
S
save original Basic code 398
saving AutoRecovery info 20
saving spreadsheets
as CSV file 22
as HTML 23
methods 19
to Microsoft Excel format 20
scatter charts 99
scenarios 277
security 20
selecting
cells 27
columns and rows 29
sheets 29
selection list 48
selection mode indicator 15
send document as e-mail 174
shared extension 420
shared spreadsheet
introduction 323
opening 324
saving 325
setting up 323
sheet tabs 14
sheets
deleting 33
description 10
hiding and showing 63
identifying 295
inserting 32, 296
inserting from other spreadsheets 297
navigating 26
referencing 299
renaming 33, 298
searching all 67
selecting 29
sequence number 15
sharing content 48
shrinking text 54
size optimization 397
snap grid 408
Solver 290
Solver for Nonlinear Programming 293,
421
sort lists
options 407
sorting 365
sorting
using macros 354
sorting records
case sensitive 66
sort options 66
sorting data 65
special characters, entering 43
splitting the screen 36
spreadsheet
create from template 119
update from changed template 122
spreadsheet functions 470
spreadsheets
comparing 337
creating new 16
description 10
documentation, internal 179
embedding 316
identifying copies 327
merging 335
opening 17
opening shared spreadsheet 324
saving 19
saving as CSV 22
saving as Microsoft Excel 20
saving shared 325
setting up sharing 323
sharing 323
statistical analysis functions 449
status bar 14
stock charts 102
496 OpenOffice.org 3.x Calc Guide