OpenOffice.org 2.x Guía de usuario Pagina 307
- Pagina / 508
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 4: Spreadsheets in Calc
Inserting a note
To keep a note, perhaps reminding one to sell a certain share later on, select the relevant cell
and choose Insert > Note. A shadowed area in the document appears in which to enter text.
To make this note visible all the time, click in the relevant cell (cells with notes have a small
red dot in the corner, provided "Note Indicator” in Tools > Options > OpenOffice.org Calc
> View is marked), open the context menu and choose Show Note. Otherwise, one only sees
the note when the mouse pointer is moved on to the cell.
Inserting a sheet into another document
Select the cell range and copy it to the clipboard (Copy icon on the Standard toolbar). Open
the document into which to insert the sheet (generally a text document) and insert the sheet
(Insert command).
Displaying formulae
To display the references in the spreadsheets, choose Tools > Options > OpenOffice.org
Calc > View and mark formulae. The best way to examine an individual formula is to click
the cell containing the formula and then click the Wizard: Functions icon on the formula
bar.
Using print ranges
Print ranges have been used in the sample document to print specifically targeted cells.
Freezing Columns
Select the column to the right of the column to be frozen, say a list of names, by clicking on
the column header, and click Freeze in the Window menu. This makes is possible to scroll
horizontally, while the area to the left of the freeze line remains fixed. This fixes the display
so that the column containing the names is always in view. This function is especially useful
for large sheets.
Splitting a Calc Window
Sometimes a user may need to work with a spreadsheet in which the active data is in different
rows. Scrolling up and down can be inconvenient. In this case splitting the display can be an
advantage. Select the cell tat which to split the display,and click Split in the Window menu.
This make is possible to scroll vertically in each of the split sections. This function can be
especially useful for large sheets.
Conditional Formatting
With this function, information can be displayed simply by entering a letter. For example, if
this is an employee list, use this feature to instantly find out if a particular employee is
present, sick, or on vacation.
To do so, use the following steps:
1. Open the Styles and Formatting window (click the icon in the Standard toolbar)
2. create three Cell Styles.
3. For the Cell Styles, choose names that correspond to the information to be represented. In
the case of the employee list , choose: Sick, Vacation and Present.
OpenOffice.org User Guide for 2.x 273
- OpenOffice.org User Guide 1
- Feedback 3
- Acknowledgements 3
- Modifications and updates 5
- Contents 7
- Important Features with 2.x 37
- Multiple Language Support 41
- New Charting Module 41
- Help Agent 44
- The Title Bar 48
- The Menu Bar 49
- The Toolbars 49
- Examples of Floating Toolbars 50
- Using Floating Toolbars 51
- The document window 51
- Docking toolbars 51
- Docking windows 52
- Opening and Saving Documents 53
- Saving Documents 56
- Backup a File Automatically 57
- OpenOffice.org File Formats 58
- Sending Documents as E-Mail 61
- Printing Documents 62
- Spellcheck 66
- 5. Click Next 71
- Using Automatic Functions 74
- Undo URL recognition 76
- Turn off URL recognition 76
- Shift+Ctr+N 78
- Find & Replace 79
- Match Case 80
- Searching Backward 81
- Current Selection Only 81
- Searching for Styles 81
- Searching for Text Attributes 81
- Similarity Search 82
- Character Result/Use 83
- Permissions available 87
- Name Type Default 89
- Entering and Formatting Text 94
- Using the keyboard: 95
- Using the mouse: 95
- Deleting characters 96
- Deleting text 96
- Status bar uses 97
- Non-breaking spaces 99
- Non-breaking hyphen 99
- Hyphen, em-dash and en-dash 99
- Creating a link 106
- Delete (Del) 107
- Backspace 107
- Create Page Styles 118
- Editing Page Styles 122
- Page Styles Summary 125
- Defining default Templates 126
- Templates and Styles 127
- Automatic Spellcheck 130
- Using AutoText 131
- AutoText With AutoComplete 134
- Text Frames 135
- Editing Text Frames 136
- Linking Text Frames 136
- Using Text Animation 138
- Character 140
- Drawing Lines in Text 141
- Editing Text With FontWork 142
- Aligning Text With Lines 144
- The Navigator 145
- Other Navigator Features 147
- • Select Update Index/Table 150
- Preparation 153
- Entering Data 153
- Example file 154
- Headings and Numbering 159
- before 170
- Numbering Lines 172
- Tables in Text 173
- Table AutoFormat 175
- Table properties in general 175
- Calculating in Text Documents 177
- Statistical Functions 178
- Trigonometric Functions 178
- More Defined Values 179
- (Ctrl+a) 185
- Defining Captions 191
- Editing or deleting captions 191
- Charts with Linked Data 195
- Automatic hyphenation 206
- Manual Hyphenation 206
- Fixed and Variable Fields 209
- Printing Address Labels 213
- Newsletters 216
- Creating Page Styles 217
- Editing Headers 217
- Editing Columns 217
- Editing Paragraph Styles 218
- Working with Frames 219
- Formatting a Frame 219
- Anchoring Frames 219
- Defining a Frame Wrap 219
- Style for this purpose 221
- Using Automatic Hyphenation 224
- Letters With Envelopes 225
- Get a POSTNET font 229
- Importing into Calc 237
- Exporting from Calc 238
- The Calc Window 239
- Inserting Sheets 241
- Renaming Sheets 241
- =CONVERT( 245
- Calculating With formulae 251
- Handling Multiple Sheets 254
- Formatting a Spreadsheet 257
- Layout of Spreadsheets 259
- Addressing Cells 261
- (') 264
- Using References in formulae 266
- ='file:///C:/ 267
- Using Charts 269
- Database Functions in Calc 274
- Evaluating Data With Calc 283
- Consolidating Data 287
- Applying Goal Seek 289
- Examples 290
- Profit=Quantity * (Selling 291
- Using Scenarios 293
- Validity of Cell Contents 295
- Sample macro: 297
- Page 1 Page 3 299
- Page 2 Page 4 299
- AutoFill 304
- Linking Sheet Information 310
- 7. Click Next 316
- Outline view 320
- In-Slide Effects 321
- Editing Presentations 322
- Using Outline View 324
- NIX-based systems, use 328
- <instdir> 330
- Creating a Business Report 331
- Overview 332
- Introduction 332
- Creating a Slide Show 334
- Working with Connectors 336
- Editing Glue Points 338
- OpenOffice.org Draw Functions 343
- Drawing Curves 353
- Working With Objects 360
- Grouping Objects 362
- Entering Groups 362
- Exiting Groups 362
- Shapes - Merge 365
- Shapes - Subtract 365
- Applying Text to Bitmaps 366
- Working With colours 369
- 3D Globe 377
- 3D Effects: Favourites 379
- 3D Effects: Geometry 380
- 3D Effects: Shading 380
- 3D Effects: Illumination 381
- First Step: 382
- Second Step: 383
- Third Step: 384
- Fourth Step: 386
- Fifth Step: 387
- Using a Grid 389
- Add some more details 392
- Complete the drawing 394
- Using Snap Lines 395
- Creating a database file 398
- Creating a table 399
- Creating a related table 400
- Creating a data entry form 401
- Making data entry easier 402
- Viewing Data 406
- Creating a report 409
- Open the Data Sources window 410
- Refreshing the form 411
- Registering a Data Source 412
- Address Books 413
- Form Design 416
- Available controls 417
- Customizing controls 418
- Associating data with a field 420
- How to use the form 421
- Standard toolbar 422
- Operators 423
- Commands 424
- Further Information 432
- Inserting an object as a copy 433
- Inserting an object as a link 434
- Revision Marking Function 441
- Version Management 444
- Turning on protection 445
- Turning off protection 445
- How to get a Certificate? 448
- Self-signed certificates 449
- Moving Tabs on the Ruler 451
- Deleting Tabs 451
- Changing the Defaults 451
- Changing the colour of Text 452
- More on Templates 453
- Accessing the Sample Macros 455
- The Sample Macros 457
- Formula Entry 458
- Special Formating 461
- − 1 23 4 462
- −1 23 4 462
- Special Characters 463
- Special Operators 464
- Vectors and Matrices 465
- Formatting 466
- 5^(1+3+3^2) 467
- Step-by-Step Procedure 469
- Control 472
- 6. Adf fix 473
- Chapter 13: Xml Enhancements 480
- Creating a new Docbook Filter 485
- Common.xcu 487
- C:\<some 487
- <release>\user\basic 489
- Time for the second test 494
- Time for the third test 495
- They are a guide only 498
Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x
(548 paginas)Sharp EL-M332BWH manuály
Uživatelské manuály a uživatelské příručky pro Video Sharp EL-M332BWH.
Poskytujeme 1 manuály pdf Sharp EL-M332BWH ke stažení zdarma podle typů dokumentů: Uživatelský manuál
Comentarios a estos manuales