OpenOffice.org 2.x Guide de l'utilisateur Page 21

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 508
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 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
Vue de la page 20
1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 507 508

Commentaires sur ces manuels

Pas de commentaire