OpenOffice.org OpenOffice - 3.3 Manual de usuario Pagina 281
- Pagina / 464
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Just as in a spreadsheet, each table cell is identified by a letter (for the column) and a
number (for the row). For example, cell C4 is the cell in the third column from the left
and fourth row from the top. When the cursor is in a cell, this cell reference is
displayed on the status bar.
Tip
Basic spreadsheet functions in tables are much the same as in
OpenOffice.org Calc. The main difference is that cell references are
formatted differently. Cell A2 (first column, second row) is referred to in
Calc as A2 (or $A$2 for an absolute reference). In Writer tables, it is
referred to as <A2>.
For example, suppose you had two numbers in cells <B1> and <C2> and wanted to
display the sum of the two in cell <A1>, as shown in Figure 288.
Figure 288: Using spreadsheet functions in a table
Do the following:
1) Click in cell <A1> and press the = key. The Formula bar appears
automatically, near the top of the screen. In the leftmost side of the bar, you
can see the coordinates of the selected cell.
2) Click in cell <B1>. The identifiers of this cell are automatically displayed in
the Formula bar and inserted into cell <A1>.
3) Press the + key.
4) Click on cell <C2>. You can see the final formula = <B1>+<C2> displayed
both in the selected cell and in the Object bar.
5) Press the Enter key or click the green tick (checkmark) on the Formula Bar.
Tip
To display the list of the mathematical functions that you can use in a
table:
1) Display the Formula toolbar by pressing F2 or by selecting a blank
cell and pressing the = key.
2) Click and hold the Formula f(x) icon.
Chapter 9 Working with Tables 281
- OpenOffice.org 3.3 1
- Writer Guide 1
- Copyright 2
- Note for Mac users 2
- Contents 3
- Chapter 1 9
- Introducing Writer 9
- What is Writer? 10
- Toolbars 11
- Moving toolbars 12
- Floating toolbars 13
- Customizing toolbars 13
- Right-click (context) menus 14
- Status bar 14
- Changing document views 17
- Starting a new document 17
- • Press the Control+N keys 18
- Opening an existing document 19
- Saving a document 20
- Password protection 22
- Closing a document 23
- Closing OpenOffice.org 23
- Using the Navigator 24
- Using the Navigation toolbar 26
- Setting reminders 27
- Getting help 28
- Undoing and redoing changes 29
- Using Writer on a Mac 30
- Chapter 2 31
- Setting up Writer 31
- User Data options 32
- General options 33
- Memory options 34
- View options 35
- Print options 37
- Path options 38
- Color options 38
- Font options 40
- Security options 41
- Appearance options 42
- General Load/Save options 43
- Choosing options for Writer 48
- Formatting Aids options 50
- Grid options 51
- Default fonts 51
- Default table options 53
- Change tracking options 54
- Compatibility options 54
- AutoCaption options 56
- Mail Merge E-mail options 57
- Choosing language settings 58
- Choose spelling options 59
- Chapter 3 62
- Working with Text 62
- Selecting text 63
- Finding and replacing text 65
- Inserting special characters 68
- Inserting en and em dashes 69
- Formatting paragraphs 70
- Setting tab stops and indents 72
- Formatting characters 73
- Autoformatting 74
- Using footnotes and endnotes 78
- Checking spelling and grammar 80
- Using built-in language tools 82
- Using the status bar 83
- Hyphenating words 85
- Using AutoCorrect 87
- Using word completion 88
- Using AutoText 89
- Inserting AutoText 90
- Line numbering 91
- Recording changes 93
- Merging modified documents 95
- Comparing documents 95
- Adding other comments 96
- Using cross-references 97
- Using hyperlinks 97
- Editing hyperlinks 100
- Chapter 4 102
- Formatting Pages 102
- Introduction 103
- Choosing a layout method 103
- Changing page margins 109
- Formatting separator lines 112
- Using frames for page layout 114
- Creating frames 115
- Anchoring frames 117
- Linking frames 117
- Using tables for page layout 119
- Creating sections 122
- Naming sections 123
- Linking sections 123
- Saving a new section 127
- Editing and deleting sections 127
- Updating links 129
- Creating headers and footers 130
- Numbering pages 135
- Changing the number format 136
- Numbering pages by chapter 137
- Restarting page numbering 139
- Adding a border 144
- Chapter 5 148
- Printing, Exporting 148
- Faxing, and E-Mailing 148
- Quick printing 149
- Controlling printing 149
- Selecting what to print 152
- Printing a brochure 153
- Printing envelopes 156
- Printing labels 158
- Sending a fax 160
- Exporting to PDF 160
- Exporting to XHTML 166
- E-mailing Writer documents 166
- > Mail Merge E-mail 167
- Digital signing of documents 169
- Removing personal data 170
- Chapter 6 171
- Introduction to Styles 171
- What are styles? 172
- Style selection basics 173
- Using Fill Format mode 174
- Applying styles 177
- Applying character styles 179
- Applying frame styles 180
- Applying page styles 180
- Example: Chapters 181
- Applying list styles 182
- Modifying styles 183
- Center Heading 1 185
- Indent Heading 3 186
- Using AutoUpdate 187
- Sample poem 189
- Final result 190
- Copying and moving styles 191
- Deleting styles 192
- Setting up heading numbering 195
- Chapter 7 201
- Working with Styles 201
- Creating custom (new) styles 202
- Understanding linked styles 204
- Working with paragraph styles 205
- Options for positioning text 210
- Controlling tab stops 212
- Setting up a drop cap 214
- Working with character styles 217
- Migrating to character styles 218
- Working with frame styles 219
- Working with page styles 221
- Background and Border pages 223
- Header and Footer pages 224
- Columns page 224
- Footnote page 224
- Working with list styles 228
- Creating a new list style 229
- Options page 232
- Category 234
- Enter CDTrack 234
- Applying the list style 235
- Chapter 8 236
- Working with Graphics 236
- Graphics (images) in Writer 237
- Creating and editing images 237
- Adding images to a document 238
- Linking an image file 239
- Embedding linked images 240
- Modifying an image 242
- Using the Picture toolbar 243
- Transparency 244
- Cropping images 245
- Resizing an image 246
- Rotating a picture 247
- Other settings 247
- Using Writer’s drawing tools 248
- Creating drawing objects 249
- Resizing a drawing object 250
- Grouping drawing objects 250
- Arranging graphics 252
- Anchoring graphics 252
- Aligning graphics 253
- Wrapping text around graphics 253
- follow these steps: 254
- Editing the contour 255
- Example 1: page wrapping 256
- Margin to image distance 256
- Spacing image to text 256
- Image anchor 256
- Adding captions to graphics 259
- Illustration 1. An example 260
- Adding captions manually 261
- Creating an image map 262
- Chapter 9 265
- Working with Tables 265
- Creating a table 266
- Creating nested tables 268
- Formatting the table layout 269
- Default parameters 270
- Resizing rows and columns 271
- Inserting rows and columns 272
- Merging and splitting cells 273
- Specifying table borders 273
- Formatting the table text 277
- Vertical alignment 278
- Number formats 279
- Rotating text in a table cell 279
- Moving between cells 280
- Sorting data in a table 280
- Additional table operations 282
- I II III) option 283
- Cross-referencing a table 284
- Merging and splitting tables 286
- Deleting a table 286
- Copying a table 286
- The Table menu and toolbar 287
- Figure 290: Table toolbar 288
- Name Description 288
- Chapter 10 290
- Working with Templates 290
- Creating a template 292
- Editing a template 294
- Caution 295
- Setting a default template 297
- Organizing templates 299
- Deleting a template 300
- Importing a template 300
- Exporting a template 300
- Chapter 11 301
- Using Mail Merge 301
- What is mail merge? 302
- Creating the data source 302
- Registering a data source 303
- Creating a form letter 305
- Editing merged documents 309
- Printing mailing labels 310
- Printing 313
- Creating an envelope template 318
- Step 2: Select document type 319
- Step 3: Insert address block 320
- Matching the fields 322
- Do not 323
- Step 4: Create salutation 324
- Step 5: Adjust layout 324
- Expand it to see the fields 326
- Step 7: Personalize documents 327
- Step 8: Save, print or send 327
- Chapter 12 330
- Tables of Contents 330
- Indexes, and Bibliographies 330
- Tables of contents 331
- Changing the title 333
- Setting the type of index 333
- Creating from index marks 334
- Adding elements 335
- Changing elements 336
- Deleting elements 336
- Hyperlinking an entry 336
- Styles page 337
- Adding color 338
- Adding a graphic 339
- Deleting a color or graphic 339
- • Edit an existing TOC 340
- • Delete a TOC 340
- Editing a table of contents 340
- Alphabetic indexes 341
- Customizing index entries 343
- Formatting entries 347
- Adding multiple columns 348
- Other types of indexes 349
- list, select the 350
- list, choose 350
- Bibliographies 351
- Filtering records 352
- Changing column details 353
- is displayed 353
- Changing the data source 353
- Changing field details 354
- Formatting the bibliography 357
- Entries page 358
- • Au – Author 358
- • Ti – Title 358
- • Ye - Year 358
- Generating the bibliography 359
- Chapter 13 362
- Working with Master 362
- Documents 362
- Why use a master document? 363
- Step 1. Plan the project 366
- Step 2. Create a template 367
- Step 4. Create subdocuments 368
- Editing a master document 373
- Editing subdocuments 374
- Using bookmarks 375
- Setting references 375
- Problem solving 381
- Chapter 14 383
- Working with Fields 383
- Introduction to fields 384
- Quick and easy field entry 384
- ” on page 388 390
- Inserting cross-references 391
- Available formats 392
- Keyboard shortcuts for fields 397
- Fixing the contents of fields 397
- Converting fields into text 397
- Plan your conditional content 398
- Create the variable 399
- Conditional text 400
- Hidden text 401
- Using placeholder fields 404
- Chapter 15 409
- Using Forms in Writer 409
- Introduction to forms 410
- When to use forms 410
- Creating a simple form 411
- Activate design mode 412
- Insert form controls 412
- Configure controls 412
- Form controls reference 413
- Form Control toolbar 414
- More Controls toolbar 415
- Form Design toolbar 416
- Example: a simple form 418
- Configure form controls 421
- Finishing touches 422
- Accessing data sources 423
- • Close the dialog box 427
- Entering data into a form 428
- Advanced form customization 429
- Read-only documents 430
- Chapter 16 433
- Customizing Writer 433
- Customizing menu content 434
- Creating a new menu 435
- Modifying existing menus 436
- Adding a command to a menu 436
- Modifying existing toolbars 438
- Adding a command to a toolbar 438
- Creating a new toolbar 440
- Assigning shortcut keys 441
- Saving changes to a file 445
- Assigning macros to events 446
- Using extensions 447
- PDF Import 448
- Writer’s Tools 448
- Appendix A 449
- Keyboard Shortcuts 449
- Opening menus and menu items 450
- Controlling dialogs 451
- Stopping macros 451
- Function keys for Writer 452
- Shortcut keys for Writer 453
- Shortcut Keys Effect 454
- Shortcut Keys Effect 456
- Index 459 459
- Index 461 461
- Index 463 463
© 2020, manymanuals.es. Todos los derechos reservados | 0.254 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales