Calc Guide

navigation 370
resetting to default values 366
saving to a file 366
selection 370
L
layout settings
format 106
page layout 105
table alignment 106
line chart 93
linking to external data
External Data dialog 270
find required range 273
Navigator 271
load Basic code to edit 348
load/save options 347
logical functions 404
M
macro recorder 299
macro security options 345
macros 366
macros
accessing cells directly 310
arguments 308
arguments in functions 309
as Calc functions 303
introduction 299
organizing 303
recording 299
sorting data 311
main window, description 10
manual line breaks 54
margins 105
mathematical functions 376
menu bar 11
menu font, customizing 358
menus
adding commands 361
creating 360
customizing 359
modifying 360
modifying entries 361
merging documents 294
Microsoft Excel 23
Microsoft Office file conversion 349
moving from sheet to sheet 28
Multiple Operations tool 249
multiple sheets
introduction 260
setting up 260
N
named range 315
navigating within spreadsheets
cell reference 26
focus 26
keyboard 27
methods 26
Navigator 26, 38
scenarios 248
nested functions 177
net chart 95
nonlinear programming solver 258
numbers as text 44
numbers, data entry 44
O
Object Linking and Embedding (OLE) 278
ODF plugin (Sun) 22
OLE object
linked 281
non-linked 280
other (Windows) 279
OpenDocument Format 347
opening spreadsheets 20
order of calculation 171
outline group controls 62
overlining 56
OXT extension 113
P
page breaks, visible 353
page style on status bar 17
page styles
applying 102
background 106
borders 106
description 99, 100
options 105
sheet settings 106
paper format 105
password protection 24
password-protect PDF 155
PDF
blank page export 153
digital rights management (DRM) 155
embed standard fonts 153
encrypt 155
EPS 151
export documents to 151
form 153
image compression and resolution 151
initial view selection 153
pages to export 151
password-protect 155
security settings 155
tagged 152
user interface settings 154
PDF Options dialog 151
PDF/A-1 152
picture context menu 128
Picture toolbar 123
Index 431