OpenOffice.org 2.x Uživatelská příručka Strana 21

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 508
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 20
What use is the DataPilot?..................................................................................................250
Creating DataPilot Tables...................................................................................................250
Selecting DataPilot Output Ranges....................................................................................252
Editing DataPilot Tables.....................................................................................................252
Filtering DataPilot Tables...................................................................................................252
Updating DataPilot Tables.................................................................................................252
Deleting DataPilot Tables...................................................................................................252
Consolidating Data..................................................................................................................253
Applying Goal Seek................................................................................................................255
Naming Cells......................................................................................................................255
Start Goal Seek...................................................................................................................256
Applying Multiple Operations............................................................................................256
Multiple Operations in Columns or Rows.....................................................................256
Examples........................................................................................................................256
Calculating With One Formula and One Variable........................................................257
Calculating with Several formulae Simultaneously......................................................257
Multiple Operations Across Rows and Columns...............................................................257
Calculating with Two Variables....................................................................................258
Using Scenarios.......................................................................................................................259
Using Ready-Made Scenarios............................................................................................259
Creating Personal Scenarios...............................................................................................259
Validity of Cell Contents........................................................................................................261
Using Cell Contents Validity..............................................................................................261
Sample macro:....................................................................................................................263
Printing or Exporting Spreadsheets.........................................................................................264
Printing Sheet Details.........................................................................................................264
Defining Number of Pages for Printing..............................................................................264
Printing Sheets in Landscape Format.................................................................................265
Printing Rows or Columns on Every Page.........................................................................265
Saving and Opening Sheets in HTML....................................................................................267
Saving Sheets in HTML.....................................................................................................267
Opening Sheets in HTML..................................................................................................267
OpenOffice.org User Guide for 2.x xv
Zobrazit stránku 20
1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 507 508

Komentáře k této Příručce

Žádné komentáře