Docstoc

Symbols Numerics A

Document Sample
Symbols Numerics A Powered By Docstoc
					                                                                                                977




Index


Symbols                             rotation object, converting
                                      curves to 825
                                                                        (+) in formulas 561
                                                                        AutoText categories 183, 868
                                 3D Controller icon 711, 715            cells automatically 564
! = ^ * / + - = 560
                                 45-degree lines, drawing 767           cells quickly 563
###
                                                                        dictionaries for spell
    in spreadsheet cells 529
                                                                          check 193
    turned into underline 130
                                                                        floating frames (Calc) 599
$ (absolute cell reference       A                                      floating frames (Writer) 240
    marker) 568
                                                                        notes to documents (Calc) 622
) in formulas 561                absolute                               notes to documents
                                    cell references 568                   (Writer) 423
                                    cell references, applying 509       sheets to a spreadsheet 521
Numerics                            paths 471
                                    URLs 138
                                                                        text boxes (Writer) 239
                                                                    Additional Settings for UNIX
                                 accents 189                            Printers option 60
0 values, hiding 541
                                 Accept or Reject Changes           address books
1/2 to .5, changing 530
                                    window                              creating data source from,
1/2, 1/4, 3/4 125
                                    Calc 621                              overview 879
1st, 2nd, 3rd, 4th 124
                                    Writer 421                          creating data sources 900
3D
                                 accepting                              migrating 46
    3D effects window 810
                                    document changes (Calc) 621     ADO
    attributes, applying
                                    document changes                    data source, creating 897
      changes 811
                                      (Writer) 420                      overview 878
    changing angles and
                                 Access                                 syntax 898
      rotating 808
                                    ADO data source 897             Adobe Acrobat, see PDF
    charts, rotating 596
                                    database connection             After update event 948
    conversion options 824
                                      overview 854                  agendas
    conversion using Effects
                                    syntax with ADO 898                 creating with AutoPilot 176
      tearoff menu 826
                                 Acrobat                            aging filter
    conversion, example 828
                                    UNIX PDF setup 67                   example 841
    converting polygons to 825
                                    see also PDF                    algebraic ordering in
    converting text to 821
                                 Active Server Pages WebCast            formulas 561
    cool effects 809
                                    options 741                     alignment
    display 118
                                 ActiveX Data Objects 878               Alignment field for animated
    display options 118
                                 Adabas                                   GIFs 720
    formatting 3D objects 810
                                    in 6.0 52                           changing (object bar) 200
    geometry, modifying 811
                                    not in OpenOffice.org 9             formatting icon (Impress) 686
    objects, creating 808
                                 ADD (Writer task bar) 185              objects 774
    objects, merging 809
                                 adding                                 paragraphs 212
978       Index



    tables, setting for 455         Apply Numbering - Symbol              how used in HTML notes 460
    text (Draw) 771                    option 125                         of document, setting 155
    text (Impress) 686              Apply styles option 126            AutoAbstract
    vertical (cells) 544            applying                              creating presentation
    vertical for cells 541             document changes 420                 using 642
Allow Quick Editing icon 680           document changes (Calc) 621        options window 644
Along a Curve effect 714               styles (Calc) 557               AutoCorrect 121
alternative entry for               arcs 762                              activating and
    concordance 347                 Area window (Draw) 764                  deactivating 124
ambient light                       areas                                 AutoCorrect window, Custom
    example 812                        charts, filling 593                  Quotes 188, 190
    modifying for 3D object 812        naming spreadsheet 611             AutoCorrect window,
Amount field                        arranging objects in layers 777         Exceptions 123
    animated GIF window 720         arrows                                AutoCorrect window,
Analysis Addin function 14             drawing 767                          Replace 122
anchoring                              style lists, where stored 793      AutoCorrect window, Word
    graphics (Web) 466                 styles, creating and                 Completion 127
    objects (Writer) 304                 modifying 791                    AutoCorrect/AutoFormat 121
Angle field                         ascending sort order (Calc) 575       exceptions 123
    duplicating object 817          Asian                              AutoCorrect window
    gradients 805                      case evaluation 113                Custom Quotes 188, 190
    hatches, creating and              character formatting 207           Exceptions 123
      modifying 806                    default fonts 109                  Replace 122
    text in cells 544                  dictionaries, adding 110           Word Completion 127
    transparency 767                   enabling Asian language         AutoFilter
animation                                support 109                      Calc 576
    animated GIFs 719                  font setup 108                     data sources 918
    Animation window 720               Katakana and Hiragana 113          forms 952
    enabling when running              layout options 111              AutoFormat
      presentation 730                 Ruby text setup 112                AutoFormat Chart
    group options 720                  text formatting 111                  window 591
    moving object or text on           typography 112                     AutoFormat window
      specified path 714               vertical text, using and             (Calc) 538
annoying features                        enabling                         AutoFormat window for Web
    activating and                  ASP WebCast script options 741          tables 455
      deactivating 124              Assign Macro window                   AutoFormat window,
    AutoCorrect 123                    assigning macro to events 949        tables 278
    turning off 128                    illustration 489, 949              Calc 538
any record field 865                Assign Styles window 335, 337,        Chart wizard 591
apple crisp 347                        351                                creating (Calc) 539
applets                             Attach file option when creating      tables 278
    adding to documents 485            library 968                        Writer setup option 126
    adding to presentations 696     attributes                         AutoHorizontal option 795
    Insert Applet window 486           applying quickly to objects     automatic
    setup options 150                    (Draw) 763                       AutoFit option for bitmaps 765
    where to enter code 486            applying to basic objects          Automatic field of Area
applications                             (Draw) 763                         window 764
    openable with program 511          cell (Calc) 542                    automatic presentation
    running from presentation 719      connectors 797                       conversion 738
Applied styles category                dimension lines 795                AutoSpellcheck 191
    Calc 555                           lines, quickly changing 768        AutoVertical option, dimension
    Writer 250                      audience handouts, see handouts         lines 795
Apply border option 125             author                                bold and underline option 124
                                       field 860                          borders 125
                                                                                       Index       979



  capitalization 122, 124            quick business card insertion      not printing dark
  cell formatting 578                  using 398                          backgrounds 848
  corrections 123                 Avery, see labels                     number allowed (Impress) 700
  deactivating and                axes                                  options for slide layouts 672,
    activating 124                   of weevil 436                        673
  en dashes 125                      spreadsheets, see rows,            overview (Impress) 700
  file extensions 157                  columns                          Page Setup window 704
  fill, sorting 534                  Web grid setup 436                 pages (Writer) 234
  filling in Calc 532                                                   paragraphs 209, 215
  function AutoPilot                                                    removing 705
  hyperlink formatting 124                                              replacing old with new 702
  lowercase 122, 124
                                  B                                     selecting (Impress) 701
  numbering and bulleting 125                                           spreadsheets 538, 548
  slide transition                backgrounds                           tables, predefined 455
       slide transitions 721         adding (Impress) 701               templates 650
  spell check 191                    adding more paths for file         troubleshooting 703
  styles 126                           selection 648                    unused, removing 702
  subtotals (Calc) 564               adding new 703                  backups
  tables 125                         and orientation (Impress) 701      backup files, path to 132
  text marquee options 483           background color                   finding backups after
  turning off all automatic              tables (Writer) 282              crash 133
    features 131                     Background color field             saving at specified interval 156
  URL formatting 130                     hatches 765                 backward
  word changes, controlling 121      background color in cells          calculations with goal
  word completion 127, 130             (Writer) 286                       seek 609
Automatic styles category 250        Background option for slide        calculations with
AutoPilot                              layouts 672, 673                   scenarios 605
  adding more paths for file         background view 657                printing 86
    selection 648                    background view for             balance sheet (subtotals) 564
  converting Microsoft Office          presentations 657             balderdash 127
    documents 161                    bitmaps, creating and           bars, see change bars
  creating a new document 176          modifying 807                 Base
  forms 928                          blank, applying 705                creating databases 877
  Function                           changing a chart’s 596             see also databases, data sources
  HTML                               color or graphic 236            base point
       templates, creating 451       colors                             positioning objects 776
  HTML document, creating                converted                      resizing objects 778
    with 446                               presentations 737         based on field 252
  letters 176                        creating and modifying 703      Basicmacro editing window 965
  presentations 639                  dark backgrounds, not           bending, see distorting
  turning off for                      printing 744                  Beta StarOffice 6.0,
    presentations 648                deleting parts of 705              uninstalling 44
AutoText 180, 866                    Draw 757                        Bezier curves, see curves
  adding categories 183, 868         file size, reducing 701         bibliographies 353-356
  and business cards 366             for HTML documents 447          bitmaps
  AutoText window 181, 867           for paragraphs 216                 applying to objects using Area
  business cards 396                 for sections 412                     window (Draw) 764, 765
  editing entries 182, 868           forms 930                          applying to objects using object
  inserting in documents 184,        hatches 765                          bar (Draw) 763
    870                              HTML documents, setup              backgrounds, using in 703
  locations stored 182                 options 434                      Bitmap object option for
  moving entries to different        making transparent using             animated GIFs 720
    categories 183, 869                eyedropper 834                   BMP format description 785
                                                                        bullets, creating from 688
980      Index



   chart fills 593                    applying to objects using object      bulleted items, promoting 676
   conversion options 824               bar (Draw) 763                      changing default font
   converting Draw objects            Border field for gradients 805          (Impress) 692
     to 827                           Border field for                      character orientation 223
   creating and modifying 806           transparency 767                    choosing from Gallery 223
   modifying for 3D object 813        Border option for Web tables          creating styles by drag &
   offset options 765                   455                                   drop 257
   offset, illustration 766           cell, quick 541                       customized 688
   print settings 87                  charts 596                            customizing 220
   style lists, where stored 804      for pages (Writer) 234                demoting and promoting
   using as text fill 772             for paragraphs 216                      (Impress)
black and white                       in charts 593                         demoting and promoting,
   applying effect to rasters in      paragraphs 216                          illustration (Impress) 687
     Draw 838                         removing from text frames 691         formatting icon (Impress) 686
   displaying presentations in        spreadsheets 538                      graphical 220
     black and white 666              table (Writer) 282                    height and width 223
   example of effect 838              tables, predefined 455                hiding bulleted items
   printing options (Draw) 848        text frames, setting 683              making a slide for each bulleted
blank background,                     see also formatting, styles             item 677
   applying 705                    Bottom field                             not showing up 688
blank paragraphs, removing            presentation margins 673              Numbering/Bullets window
   automatically 126                  text frame options 683                  (Graphics) 220
blue                               Bottom option                            paragraphs 214
   creating or modifying 803          distribution 774                      paragraphs (object bar) 200
   modifying for graphic with      boxing text 215, 235                     position settings 224
     object bar 832                Brad Pitt 483                            primary control window 221
BMP, see bitmaps                   breakpoints for macros 974               promoting and demoting
bold                               breaks                                     (Impress) 686
   automatic 124                      breakpoints in macros 974             removing 259
   formatting icon (Impress) 686      displaying or hiding in HTML          saving customizations 224
   formatting, object bar 200           documents 435                       setting up (Impress) 689
   text formatting (Draw) 771         manual (Calc) 551                     space to text 224
bookmarks                             page breaks 212                       special characters 223
   cross-referencing 862              page flow 259                         styles 256
   field 862                          page in Calc 551                      styles, creating 256
   icons, example of use 470          paragraph to next page or             styles, using with paragraph
books                                   column 213                            styles 257
   chapter-page numbering 323         switching to new page                 text (Draw) 771
   master document example 327          style 213                           turning off shading 217
   master documents 326               table breaks 283                      turning on/off (Impress) 688
   moving within using             brightness                               using graphics 220
     Navigator 312                    changing in image 834                 when transferred from Writer
   ordering 21                        modifying for 3D object 812             to presentation 641
   overview 312                       modifying for graphic with            Writer 217
   page numbering 322                   object bar 832                   business cards
   single-source                   Bring to Front option 777                and AutoText 366
     documentation 410             brochures 88                             AutoText 396
   see also master documents       browsing                                 data for 363
boolean field types 908               notes in HTML document 460            entering new data 390
borders                               URL, entering 438                     quick insertion with
   adding to pages 235                Web 443, 436                            AutoText 398
   adjusting spacing for              Web, setup 136                        simple 394
     pages 235                     bullets                                  single 397
                                      automatic 125, 126                    with fixed data 389
                                                                                      Index        981



   without variables 397              conditions in (IF) 572           decimal places (Writer) 287
   see also formatting, styles        controlling order 562            decimal places,
button size 106, 108                  copy and paste 580                 controlling 530
button tips 97                        Data Pilot and data              deleting contents 530
buttons                                 sources 515                    editing contents of 530
   adding to drawings 815             function AutoPilot               entering percentages 529
   adding to forms 938                functions 563                    entering text and numbers 528
   adding to presentations 699        in Writer text 297               exact text in 529
   form of hyperlink 471              order                            filling 531
   in forms 926                           in formulas 561              filling the exact same data 531
   modifying button link                  using parentheses 562        filling to increment data 531
     quickly 478                      quick totals 563                 font color, changing 540
   properties window 947              scenarios 606                    format for numbers 540
   see also controls                  spreadsheets, about 560          formatting 539
                                      spreadsheet-type in tables 295   formatting (Calc) 542
                                      updating in spreadsheets 571     hiding when printing 546
                                                                       hiding zero values 541
C                                 calendars 49
                                  callouts 680, 682                    jumping to 524
                                  camera distance 811                  leading zeroes (Writer) 287
Calc                                                                   leading zeroes, keeping 529
                                  canned text, see AutoText
   converting spreadsheets to                                          merging (Calc) 542
                                  cannot find error 37, 38
     HTML 448                                                          merging and splitting
                                  capitalization, automatic 122
   features 498                                                          (Writer) 289
                                  caps, drop 215
   formula bar 500                                                     merging data 542
                                  caption numbering 306, 308
   guided tour 500                                                     negative numbers (Writer) 287
                                  Caption window 307, 308
   HTML table, opening in 511                                          number formats in 543
                                  captions 306
   importing text files 513                                            numbers that are wider
                                  Case match field
   keyboard shortcuts 508                                                than 529
                                      search setup 137
   linking to target within a                                          passwords 602
                                  catalog for styles 249, 556
     document 472                                                      preventing invalid entries 603
                                  categories
   linking to target within a                                          printing specific range 628
                                      AutoText 183, 868
     document (HTML tags) 473                                          protecting 546, 602
                                      deleting template 270
   menu bar 500                                                        protecting contents
                                      moving styles between 261
   new features 14                                                       (Writer) 286
                                  CDs 20, 23
   object bar 500                                                      references 568
                                  cedillas 189
   printing options and                                                references, absolute or
                                  Cell Attributes window 543, 602
     procedures 624                                                      relative 568
                                  CELL function 14
   printing, things that                                               references, tips 568
                                  cell references 568
     control 624                                                       selecting data from a pick
                                  cell styles 556
   Quick Start 498                                                       list 532
                                  cells
   Quick Start checklist 498                                           selecting non-adjacent
                                      adding/removing decimal
   setup options 507                                                     (Calc) 535
                                        places 540, 543
   starting 499                                                        setting attributes (Calc) 542
                                      automatically completed
   status bar 500                                                      showing formulas 587
                                        text 532
   Stylist 500                                                         spacing inside 544
                                      background 540
   toolbar 500                                                         styles 556
                                      borders, quick 541
   work area 499                                                       table formatting 286-287
                                      changing direction of Enter
calculations                                                                changing country currency
                                        key 535
   algebraic order 561                                                       text that is wider than 528
                                      changing text angle 544
   automatic totals 564
                                      combining data 542               thousands separator
   backwards to reach goals 609
                                      combining/concatenating 581        (Writer) 287
   backwards with scenarios 605
                                      controlling valid entries 603    vertical alignment 541, 544
   checking totals 572
                                      creating styles 556
   commission earned 574
982       Index



   vertical alignment in                     setting up 316                  changing background 596
      (Writer) 289                      numbering captions 310               changing chart type 595
   wrapping text 96, 528, 544           numbering limitations 315            changing default colors 597
Center option                        CHAR 908                                changing details 595
   distribution 774                  character formatting 215                character options 594
   lines 769                            advanced effects (Draw) 817          chart area 590
Center X and Y fields for               Asian 111, 207                       data 590
   gradients 805                        creating styles 255                  data labels options 594
Center X and Y options for              creating styles by drag &            displaying legend 592
   transparency 767                       drop 256                           fills 593
centering                               Draw, Impress 771                    fonts 594
   text (Impress) 686                   filling text with gradients          legend 590, 591
   see also alignment                     (Draw) 772                         lines/borders options 593
centimeters, unit of measure 180        format painter 201                   modifying 592
cereal 470                              inline explanations with Ruby        organizational 690, 692
cfg files 103                             text 190                           parts of 590
change bars                             in-line text 112                     previewing with text 591
   recording 420                        object bar, using 200                rotating 3D charts 596
   setting up 420                       removing 463                         secondary Y axis 594
   showing 420                          Ruby text 112                        selecting parts 593
change bars and marks 419               styles 254                           selecting types 591
Change Options window 618               styles, applying 259                 selecting types of types 592
Change slides 730                       text width 206                       spacing between data 594
changes                                 URLs, automatic 130                  statistics options (2D
   accepting or rejecting 420           Writer 200                             only) 594
   accepting or rejecting            Character Style window                  title 590
      (Calc) 621                        (Organizer) 255                      title, entering 592
   adding comments to                Character window 202, 203,              transparency options 594
      (Calc) 619                        688, 771                             troubleshooting re
   protecting 422                    characters                                memory 290, 590
   recording (Calc) 618                 background color 201, 206            updating (Writer) 290
   undo 421                             combine characters field 863         updating data 597
Changes Options window                  count in paragraph 187               X axis 590
   (Writer) 420                         font color 201                       Y axis 590
changing                                in document 154                   check boxes
   AutoText entries 868                 specifying separator characters      adding to drawings 815
   back to standard template 264          for word count 187                 adding to forms 940
   chart default colors 597             styles 248                           adding to presentations 699
   chart details 595                    see also Asian                       examples 927
   chart type 595                    charcoal filter example 839             properties windows 947
   charts 592                        chart area 590                          see also controls
   colors in images 833              chart wall 590                       checklist
   object into another, see cross-   charts                                  Quick Start (Calc) 498
      fading                            2D to 3D, 3D to 2D 595               Quick Start (Draw) 750
   paths to folders 132                 adding data labels 591               Quick Start (Impress) 634
   sort lists 534                       adding to Calc 590                   Quick Start (Writer) 168
   styles 260                           adding to drawings 814               Quick Start, Web 442
   styles using drag & drop 261         adding to presentations 695       Chinese, see Asian
Chapter styles category 250             adding to Writer 290              circles
chapters                                area fill 593                        conversion options 824
   chapter-page numbering 323           area options 593                     drawing (Draw) 762
   moving between using                 AutoFormat Chart wizard 591          drawing segment of 762
      Navigator 312                     axes labels 591                      text, aligning to specific
   numbering 314                        axes labels, entering 592              shape 820
                                                                                            Index       983



    typing text inside 684                formatting icon (Impress) 686       width in tables 288
circumflexes 189                          hatches, creating and            Combine single line paragraphs
client installation 31                      modifying 806                     option 126
client-server, see multi-user             hue, saturation, luminance 803   combining
    see multi-user 31                     interaction effects 719             cell data 581
clip art, see Gallery                     lines 768                           cells (Calc) 542
Close Bezier icon 801                     models, changing 803                combine characters field 863
CMYK 802                                  modifying (Draw) 802                formulas and text 581
    changing to RGB 803                   modifying for 3D object 812         objects, example 828
    selecting 93                          palettes, adding or                 polygons into curve 830
    selecting for commercial                modifying 804                     spreadsheet data 583
      printing 93                         paragraph backgrounds 216        comments 975
coffee cake 347                           resolution for images 832        commercial color setup for
collating                                 RGB or CMYK 93                      printing 93
    documents (Draw) 849                  see also formatting, styles      commission earned,
    documents (Impress) 746               setting default 120                 calculating 574
    documents (Web) 426, 492              slide transitions 720            common.xml file 145
collating printed copies 76               spreadsheet change               comparing documents 419
color                                       recording 618                  completing
    adding (Draw) 802                     spreadsheets 538, 588               key to press to accept 128
    applying color modes to rasters       tables, setting for 455             words automatically 130
      in Draw 838                         text (Draw) 771                  concatenating cells 581
    applying grayscale effects to         see also character formatting,   concordance 345
      rasters in Draw 838                   paragraph formatting           conditional
    applying to objects in Draw,       columns                                any record field 865
      procedures 801                      breaks, manual 551                  Conditional styles category,
    applying to objects using Area        changing page 237                     Writer 250
      window (Draw) 764                   changing paragraphs                 conditions, using in paragraph
    applying to objects using object        (Writer) 237                        styles 253
      bar (Draw) 763                      changing widths (Writer) 288        fields or conditions 862
    applying to text 771                  deleting 537                        formatting (cells) 578, 579
    background 757                        deleting (Writer) 288               paragraph styles,
        paragraphs 216                    expanding and contracting in          troubleshooting 253
        page 236, 703                       Calc 610                          sections 415
    bitmaps, creating and                 hiding (Calc) 537                   styles 250
      modifying 807                       in sections 412                     syntax for fields, finding 866
    cells 540                             in tables, resizing 456             text field 862
    changing chart default 597            inserting (Calc) 537             conditions
    changing one to another in            making widths equal                 for filtering (Calc) 578
      image 833                             (Writer) 288                      in calculations (IF) 572
    changing while duplicating            multiple (Writer) 236            cones 808
      objects 816                         paragraph-specific               configuration
    color depth for images 832              (Writer) 237                      migrating from 5.2 45
    Color fields 805                      printing repeated (Calc) 626     configuration files 105
    color models provided 802             repeating in Calc 626            configuration keys 192
    color themes in Calc 558              resizing (Calc) 536              Configuration window
    color-coding spreadsheet              resizing (Writer) 285               (Keyboard) 105
      edits 618                           selecting entire (Calc) 535      Configuration window
    color-coding spreadsheets 615         slides, using in 685                (Menu) 103
    commercial printing setup 93          sorting (Calc) 574, 575          Connect window, adding a
    converted presentation 737            spreadsheet rows for data           printer 56
    for page backgrounds                    source 517                     connecting
      (Writer) 234                        unfreezing 553                      objects, example 828
                                          unhiding 537                        polygons into curve 829
984      Index



   to databases, see databases,        curves to 3D rotation 825              characters in paragraph 187
     data sources                      curves to polygons 826                 separator characters that affect
connection pooling 892, 905            databases to Writer, RTF, and            word count 187
connector lines                          HTML tables 920                      words and characters in
   adding connector points 798         file types (Draw) 823                    document 154
   connecting to borderless text       file types (Image) 785              cramming a document onto one
     frames 691                        lines to curves 825                    sheet of paper 86
   using in org charts 691             Microsoft Office                    crash, finding files after 133
Connector window 797                     documents 161                     Create AutoAbstract
connectors                             non-Writer documents 178               window 644
   adjusting 797                       polygons to 3D 825                  Create from file option
   applying specified                  polygons to curves 829                 Insert OLE Object
     attributes 797                    raster to vector 827                     window 481
   drawing 796                         rasters or vectors to other            inserting OLE objects 699
   icon, illustration 793                vectors 824                       Create new option
consolidating spreadsheets 585         settings for text document             Insert OLE Object
content reuse, sections 409              conversion 160                         window 481
content.xml 147                        spreadsheets to Writer                 inserting OLE objects 699
context menus 108                        tables 294                        Create Scenario window 607
Continuous 483, 768                    StarOffice 5.2 documents 161        Create single print jobs
contour mode 664, 683, 824             text file conversion                   option 493
contrast 834                             problems 28                       create table 912
controls                               to different applications 160       Create table option 125
   adding buttons to forms 938      copies                                 creating
   adding data entry fields to         number to make of object 817           cell styles 556
     forms 937                         number to print 76                     databases 877
   adding drop-downs to                number to print (Draw) 849             formulas manually 563
     forms 939                         number to print (Impress) 746          indexes 342
   adding group boxes to               number to print (Web) 426,             master documents 328
     forms 941                           492                                  master spreadsheet 583
   adding list boxes to forms 944   copying                                   new files (Calc) 509
   adding to forms 937                 filtering results to other sheets      new files (Draw) 756
   adding to spreadsheets 598            (Calc) 578                           new files (Writer) 175
   check boxes, adding to              nonconsecutive text                    page styles 557
     forms 940                           blocks 185                           scenarios in spreadsheets 606
   displaying or hiding in HTML        objects (Draw) 815                     sections (Writer) 409
     documents 435                     quick 816                              tables of contents 332
   events, definition of each 948      slide from any document                templates (Writer) 267
   guidelines for distributing             slide view 676                     versions of a document
     documents containing 934          slide from same document                 (Calc) 618
   labels, modifying 935                   drawing view 676                   versions of a document
   properties window 947               sort results to other sheets             (Writer) 406
   replacing 937                         (Calc) 575                        crop circles 836
   SQL and forms 927                copyright, inserting 180, 866          cropping
   table controls 931               Corner Point icon 801                     any shape 836
conversion options (Draw) 824       Correct TWo INitial CApitals              pictures (Writer) 276
conversion, see migration              option 124                             standard 835
Convert to Curve icon 801           correcting typos                       cross-fading 822-823
Convert to Polygon window 827          automatically 121                   crosshairs icon 767
converted presentation 735, 741     corrupt documents, opening 159         cross-references
converting                          counting                                  bookmarks 862
   conversion options (Draw) 824       characters and words in                creating with hyperlinks 332
   conversion options                    document 186                         hyperlinked 332
     (Image) 785                                                              insert reference field 862
                                                                                          Index      985



   set reference field 861           Data Record Search                     SQL statements 912
   see also references                  window 951                          supported 854
cubes, creating 808                  data sources                           supported address book
currency                                Access with ADO 897                   formats 900
   changing in cells (Writer) 287       Access, overview 854                switching for a form 954
   format in cells 540                  address book 900                    switching for mail merge 376
cursor, direct 185                      address book overview 879           tables, creating 906
curves                                  ADO 897                             text, creating 882
   conversion options 824               copying tables between 911          text, tutorial 874
   converting lines to 825              data entry with forms 923           tips 877
   converting polygons to 829           data source viewer 914              troubleshooting 399, 893, 896
   converting to 3D rotation 825        data, adding to table 913           tutorial 873
   converting to polygons 826           dBase, creating 885                 types supported 878
   curving objects 817                  dragging into document 379          viewing data using forms 922,
   curving text 817                     easiest 882                           950
   curving text along line 819          editing data 914                 databases
   drawing 799                          editing data source data 920        Access, overview 854
   editing 800                          example 873                         Adabas in 6.0 52
   editing icons, descriptions 800      filtering using forms 952           Adabas, not in
   editing icons, illustration of       formatting in table 382               OpenOffice.org 9
     option bar 800                     forms for data entry 955            ADO 878
   editing, illustration 801            HTML table, inserting in            ADO connection 897
   see also objects                       spreadsheets 511                  and data sources 873
custom dictionary 193                   importing manually into             converting to Writer, RTF, and
custom installation 27                    spreadsheet 517                     HTML 920
custom presentations 722                importing using Data Pilot 517      creating 877
Custom Slide Show option 730            index for new tables 910            data for mail merge, setting
Custom styles category                  JDBC 893                              up 362
   Calc 556                             links 883                           data source types
   Writer 250                           MySQL and JDBC 893                    supported 878
customizing                             MySQL, overview 854                 database name field 865
   bullets, numbers, outlining 220      next record field 865               dBase 878
   interface size 106, 108              ODBC, creating 887                  dBase data source,
cyan 803                                ODBC, UNIX, and                       creating 885
cylinders 808                             MySQL 881                         exporting 919
                                        opening in Calc with Data           field labels, changing 935
                                          Pilot 515                         forms, using 950
                                        Oracle and JDBC 893                 importing 880
D                                       Oracle, overview 854                JDBC 879, 893
                                        overview 855                        mail merge overview 360
damaged installations 40                preparing data 880                  migrating 52
dashes, en (automatic) 125              preparing data beforehand 876       migrating 5.2 databases 902
data                                    queries 914                         MySQL data source with
   charts 590                           renaming tables 911                   JDBC 893
   combining in spreadsheets 583        rows and columns in                 MySQL, ODBC on UNIX 881
   data entry in forms 955                spreadsheet 517                   MySQL, overview 854
   data entry with forms 923            saving new records 924              new features 16
   data entry, troubleshooting 957      searching using forms 951           ODBC 878
   editing data source data 920         sorting and filtering 917           ODBC data source,
   forms, creating and using 922        sorting using forms 951               creating 887
   preparing data to put in data        specifying for form 932             Oracle data source with
     sources 876                        spreadsheet 884                       JDBC 893
   viewing using forms 922, 950         spreadsheet, overview of using      Oracle, overview 854
Data Pilot 515                            as 879                            overview 855
986      Index



   preparing to create data        Delete Points icon 801              diagonal
     sources 880                   deleting                                lines, drawing 45-degree 767
   searching 951                      area names (Calc) 613                text, aligning to specific
   supported 854                      cell contents 530                      line 819
   tables, creating 906               columns, rows, and tables            text, Writer 244
   tutorial 873                         (Writer) 288                   dictionaries, adding 110, 193
dates                                 graphic, part of 837             differences between StarOffice
   adding to drawings 757             headers and footers 232              and OpenOffice.org 8, 9
   adding to HTML note 460            layers 662                       dimension lines
   adding to presentations 699        macro modules 971                    adjusting, illustration 794
   field 860                          macros 971                           applying specific
   field types in data source         nonconsecutive text                    measurements 794
     tables 909                         blocks 185                         drawing 794
   format, changing 859               rows and columns 537                 icon, illustration 793
   formatting date field 232          scenarios in spreadsheets 608    direct cursor 185, 126
   formatting for fields 865          sections 417                     directories
   formatting in cells 286            sheets 523                           changing in dialog boxes 134
   handouts, adding to 728            slides 669                           default directory for saving and
   printing                           sort lists 534                         opening 132
       drawings 848                   styles 261                           see also paths
       presentations 745              styles (Calc) 557                disk space 22, 701
   see also fields                    table rows and columns           display
David St. Hubbins 532                   (Writer) 282                       grid (Writer) 306
dBase                                 tables of contents 342               HTML documents 435
   creating data source 885           templates and categories 270         selecting 784, 796
   overview 878                       versions of documents 407            size, changing (Impress,
DDE                                delimited text files, importing           Draw) 663
   field 864                          into Calc 513                        see also scale
   links between spreadsheet       delimiters 513                      Distort feature 817
     files 585                        opening text files in Calc 513   distorting 817
   links to sections 417              selecting in text file 514       distribution
   links to spreadsheet            demoting                                illustration of effects 775
     (Writer) 294                     bulleted items 676                   objects 774
DECIMAL 908                           bulleted items (Impress) 686     dividing (/) in formulas 561
decimals 287                          formatting icon (Impress) 686    dmaths 560
   adding and removing                headings to bulleted items 676   documents
     places 540                       icon 676                             adding charts (Calc) 590
   controlling (Calc) 530             see also indenting                   adding frames (Writer) 239,
   field types 908                 dependents                                297
   formatting in cells 540            tracing 587, 614                     adding graphics and drawings
   setting default places 540         tracing, example 614                   (Calc) 598
default application for MS and     Derek Smalls 532                        adding math formulas
   HTML files 29, 152              descending sort order                     (Calc) 599
defaults                              (Calc) 575                           adding math formulas
   fonts, changing (Impress) 692   Design Mode On/Off icon 934               (Writer) 300
   fonts. changing in standard     designs                                 adding other documents
     template (Writer) 263            presentation HTML                      (Writer) 302
   fonts, changing in Writer 178        conversion 734                     adding to Writer 302
   presentation default               presentation WebCast                 books and long documents 312
     settings 692                       conversion 740                     comparing 419
   printer 62                      developers’ manual 10                   comparing versions of a single
   template 263                    developing for OpenOffice.org 7           document 408
definition filter 842              Device settings for UNIX                converting 5.2 documents 161
                                      printers 60
                                                                                      Index       987



  converting from Microsoft       double lines of text 190                printing options 848
    Office 161                    Double-click Text to Edit               space around (Writer) 304
  count characters in 186            icon 680                             troubleshooting paper
  creating based on template      DPI                                       format 76, 79, 756, 849
    (Calc) 509                       print settings 87                    work area 751
  creating based on template         printer setup 62                 drivers
    (Writer) 176                  dragging to fill cells 531              databases, see data sources
  creating from template          Draw                                    PostScript drivers 77
    (Writer) 262                     adding other files to            drop cap 215
  deleting versions 407                drawings 814                   drop table 912
  document number field 863          background 757                   dropdown lists
  document properties 154, 155       converting Draw objects to           adding to drawings 815
  DTD 10                               other Draw objects 824             adding to presentations 699
  editing notes 424                  converting file types 823        dt file, changing HTML icons
  editing tools 419                  creating new drawing 750, 756        back 153
  finding elements in 313            features 752                     DTD 10, 147
  inserting AutoText 184, 870        formatting text in object        duplex
  inserting notes (Calc) 622           bar 771                            printer setup 61
  inserting notes (Writer) 423       guided tour 753                      turning on and off 59
  link to create new 476             new features 16                      UNIX printer, creating 57
  macros, adding to 976              objects, creating 761            duplicating 815-816
  moving within using                opening drawing 756              dynamic formatting (cells) 578
    Navigator 312, 523               opening drawings in
  name 154                             Impress 647
  new, creating 175                  presentations, opening as Draw
  opening corrupt 159                  file 757
                                                                      E
  opening prior versions of 407      printing options 848
  opening recent, setting            Quick Start checklist 750        Edit Points icon 763, 800
    number 145                       templates, creating 758          editing
  page numbering in books 322        text, using in drawings 769,        AutoText entries 182, 868
  password protecting 158              772                               bibliographies 356
  printing notes 424                 work area 751                       cell contents 530
  properties field 861            draw effects icons 817                 charts 592
  saving in HTML 448              Drawing view                           data source data 920
  saving versions of (Calc) 618      illustration 635                    data sources using forms 924
  saving versions of                 overview 654                        editing time field 863
    (Writer) 406                  drawings                               editing tools for
  sections, using 409                adding other files to 814             documents 419
  sending as Email 179, 520          adding to Calc 598                  editing tools, numbering
  settings for text document         adding to Writer 274                  lines 226, 419
    conversion 160                   creating and adjusting              editing tools, setting up
  sharing styles between 265           (Writer) 273                        marks 420
  showing changes (Calc) 618         dark background, not                editing tools, showing
  starting new 169                     printing 848                        changes 420
  storing bibliography               displaying or hiding in HTML        fields 865
    information 353                    documents 435                     formula formats 301
  template based on 645, 758         inserting slides from another       indexes 348
  title, specifying 646                file 674                          layers, preventing 661
  unzipping 146                      lining up on a grid                 macros 974, 975
  version control 406                  (Writer) 305                      master document source
  viewing previous versions 407      linking to (Writer) 275               files 329
  your name appearing in 155         opening 756                         notes in documents 424
DocuTech printing 92                 opening as presentation 647         presentation while running 732
donuts, see toruses 808              printing 849                        styles 260
988       Index



    styles (Calc) 557                    mail merge fields,                expanding slide into several 677
    styles using drag & drop 261           removing 403                    exponent (^) in formulas 560
    tables of contents 339, 341          pages, suppressing 15             exporting
    templates 268                        pages, removing 196                  databases 919
    text editing mode                    paragraphs, removing                 databases to Writer, RTF, and
      (Impress) 684                        automatically 126                    HTML tables 920
    XML config files, see XML         en dashes, automatic 125                presentations to other
editing changes, protecting 422       endnotes in sections 413                  formats 732
editing files, putting in edit        Enter key                               templates 268
    mode 450                             changing behavior in              expressions
editing tools                              spreadsheets 535                   order of evaluation 561
    change marks 419                     changing behavior in                 regular in search and
    document comparison 419                StarCalc 530                         replace 525
    line numbering 226, 419           Enter Password window 159               see also formulas
effects                               entering formulas manually 563       extended object lines, displaying
    distorting and curving            envelopes 384, 399                      when moving 776
      objects 817                     EPS 786                              extensions, file 157
    enabling (Impress) 710            equals sign (=) in formulas 560      external data, inserting in
    entire slide, applying to 720     equations                               spreadsheets 511
    examples (Image) 838                 changing formats 301              external databases
    flipping objects 782                 creating files of 302                exporting to 919
    grayscale effects, applying to       importing 302                        importing 880
      rasters in Draw 838                inserting (Writer) 300            extra lines in paragraph 213
    order, changing for objects 713      inserting as objects (Calc) 599   Eyedropper 833
    rotating objects 782                 inserting special
    running manually or                    characters 302
      automatically 721               errors, see troubleshooting 37
    sound and objects 712             evaluation order in
                                                                           F
    special effects (Impress) 710        formulas 561
Effects field                         events                               fading, see cross-fading 823
    interaction effects 719              assigning to hyperlinks 272       FAQs, see troubleshooting
    text marquee options 483             control events, definition of     favorites, 3D effects 811
elf dander 482                             each 948                        fax
Eliminate Points icon 801                form function properties 947         creating with AutoPilot 176
ellipses                                 linking to 471                       faxing 79
    aligning text to 820                 macros, assigning to 949             faxing a document 81
    conversion options 824            everyflavorbeans 127                    faxing mail merge 399
    drawing (Draw) 762                Excecute SQL Statement                  faxing Web page 493
    drawing segment of 762               window 912                           mail merge fax
    typing text inside 684            Excel                                       AutoPilot 367
email                                    converting 161, 511                      creating your own 378
    address book data sources 900        macros 960                           UNIX setup 63
    inserting link to create 475         opening files by default in       feature overview 4, 6
    migrating 46                           StarOffice 29                   features
    migrating from 5.2 49                opening files in OpenOffice.org      Calc 498
    program for sending document           or StarOffice 152                  differences between StarOffice
      as email 143                       opening MS files in StarOffice         and OpenOffice.org 8
    sending documents as 143,              or OpenOffice.org 29, 152          Draw 752
      179                                saving spreadsheets in 518           Impress 634
    sending spreadsheets 520          Exchange background page                new 7
empty                                    option 702                           new for databases 16
    fields, fixing in mail            executable, running from                new in Calc 14
      merge 403                          file 719                             new in Draw, Image and
                                      execute macro field 862                   Impress 16
                                                                                            Index        989



    new in this release 13                  info 863                           creating based on template
    new in Writer and Web 14                input 862                            (Calc) 509
    OpenOffice.org features                 insert reference 862               creating based on template
      mailing list 8                        keywords 863                         (Writer) 176
    Web 442                                 modified 863                       creating new (Calc) 509
    Writer 168                                                                 creating new (Draw) 756
                                            most recent print 863
Fertile, Minnesota 881                                                         creating new (Writer) 175
field codes, displaying or hiding           page 861                           formats openable with
    in HTML documents 435                   placeholder 862                      program 511
field length, modifying for form            sender 860, 861                    formula 302
    fields 957                              set reference 861                  inserting text-based file 479
fields                                      set variable 864                   link to create new 476
    adding data entry fields                show variable 864                  linking to other Calc files 585
      forms 937                             statistics 861                     name of, adding to
    adding drop-downs to                    time 861                             drawings 757
      forms 939                             title 864                          name of, adding to
    and AutoText 366                                                             presentations 699
                                            user field 865
    and business cards 366                                                     not editable, what to do 450
    control fields in forms 926         turning off gray background in         printing to 76
    creating and using (stored            Writer 232                           printing to (Draw) 849
      data) 858                         using in mail merge 366                printing to (Impress) 746
    creating in data source             variables, creating 320                printing to (Web) 426, 492
      tables 908                        won’t accept longer value 957          printing to file, options 78
    data source fields and field    fields (Writer) 231                        properties and template used to
      length 914                        DDE field 864                            create 447
    data source tables, defining        document 860                           properties, setting 467
      fields for 909                    input field (variable) 864             template based on 645, 758
    example of use 366                  insert formula 864                     unzipping 146
    modifying form labels 935           inserting in headers and               where stored 36
    page count 231                        footers 859                     Fill Format feature 201
    relationship to data                number sequence 864               Fill holes option 827
      sources 855                       other 859                         filling
    spacing in mail merge 403           page numbers and count 231,            cells 531
    stored field values 864               858                                  data in a specific order 532
        bookmarks 862                   set page variable 864                  the exact same data in
                                        turning off gray                         cells 531
        chapters 860
                                          background 859                       to increment cell data 531
        combine characters          figure captions 350-352
          field 863                                                       fills 763
                                        generating table of figures 350   filtering
        conditional text 862            generating table of figures for        AutoFilter (Calc) 576
        created 863                       master documents 352                 copying results to other sheets
        date 860                        inserting 306                            (Calc) 578
        description 863                 numbering 308, 309                     data in data sources 952
        document number 863         file extensions, creating                  records for mail merge 363
        document template 861           automatically 157                      settings conditions for
        editing 865                 files                                        (Calc) 578
                                        Attach file option when                spreadsheets 576
        editing time 863
                                          creating libraries 968               standard (Calc) 578
        execute macro 862               automatic extensions 157
        file name 861                                                     filters
                                        converting file types                  applying (Image) 838
        form letter field 865             (Draw) 823                           data sources 917
        formatting 865                  converting file types                  examples 838
        hidden paragraph 863              (Image) 785                          in mail merges 363
        hidden text 863                                                   find and replace 524
990       Index



finding                                  changing in standard template         form letter field 865
    document elements 313                  (Writer) 263                        see also mail merge, databases,
    index markers 349                    default font, changing for              data sources
    shortcut keys 105                      HTML documents 447               format painter feature 201
first letters of paragraph               Draw 771                           formats
    different 215                        enlarging fonts and buttons for       applying automatically 126
fishwife, meddling 428                     interface 106, 108                  reverting to default 126
Fit height to text option 683            for paragraph numbers 223             tables, predefined for 455
Fit Text to Frame icon 680               formatting icon (Impress) 686         updating in master
Fit Text to Size icon 682                general font substitution 74, 82        documents 330
Fit to Line vertical text                in spreadsheet headers and         formatting
    option 204                             footers 550                         advanced text effects
Fit to line width option 791             per-printer substitution in             (Draw) 817
Fit to page warning dialog 94              UNIX 72                             applying themes (Calc) 558
Fit to page option                       starting with standard                bibliographies 356
    fitting slide onto page                template 264                        cells 539, 540
      (Draw) 847                         substitution 82                       cells (Calc) 542
    print warning (Draw) 848             vertical text, enabling 109           cells with styles
    printing options (Draw) 848       FontWork 818-821                         character 200
    printing options (Impress) 745       curving text along a line 820         colors for HTML source 435
Fit to size                              moving curved text 821                conditional (cells) 578
    fitting document onto one sheet      overview of features 819              copying 201
      of paper 86                     footers                                  creating Calc AutoFormat 539
    fitting slide onto page              adding to slide 706                   data source in table 382
      (Draw) 847                         complex example 230                   date field format,
    presentation page setup 673          date field and format 232               changing 859
    text frame options 683               different within document 228,        fields 865
Fit width to text option 683               233                                 first characters of paragraph
fixed HTML table setup                   formatting 232                          different 215
    window 279, 454                      handouts, adding to 707, 728          format painter feature 201
fixed data values 362, 389               HTML 467                              getting right formatting icons in
flipping                                 illustration in slide 706               object bar 456
    objects 782                          in books and longer documents         headers and footers 232
    text in cells 544                      319                                 indexes 348
floating frames                          in master documents 329               number formats, creating 287
    adding to drawings 814               inserting (Web) 467                   Paragraph window 210
    adding to presentations 695          inserting fields 231                  paragraphs 208
    inserting (Calc) 599                 margins 230                           removing 463
    inserting (Writer) 240               removing 232                          sections 411
    Writer 239                           showing headings in 320               spreadsheets, AutoFormat 538
floating toolbars 99                     spacing of (Calc) 550                 spreadsheets, DataPilot 515
flow, changing page 259                  spreadsheet 549                       styles (Writer) 247
Focus gained and lost 948                variables, creating 320               tables (Writer) 277, 283, 287
font size for program                    viewing (Web) 467                     tables of contents 336, 339
    interface 106, 108                   Writer 228                            text (Impress) 688, 771
fonts                                 footnotes                                text (Impress, Draw) 685
    adding in UNIX printers 71           configuring 228                       text (Web) 462
    Asian defaults 109                   formatting 227                        text automatically 121
    Asian setup 108                      in sections 413                       text icons (Impress) 686
    changing color 201, 202           foreground 730, 807                      text, filling with gradients 772
    changing default (Writer) 178     form controls properties                 with styles (Calc) 554
    changing in object bar 200           window 947                         forms 950
    changing size and style 202       Form Design window 935                   adding controls 937-944
                                      form letters
                                                                                          Index       991



                                       importing 302
                                       in Writer text 297
                                                                        G
   adding records using 955            inserting special
                                                                        Gallery
   adding to drawings 815                characters 302
                                                                           choosing bullets 223
   adding to presentations 699         intersections in (!) 561
                                                                           dragging items to
   AutoPilot 928                       less-than-or-equal-to in
                                                                             documents 116
   controls and SQL 927                  (<=)> 561
                                                                           inserting (Writer) 275
   controls, creating 926              multiplying in (*) 561
                                                                           using 115
   creating and using 922              non-consecutive cells in ( 561
                                                                        gamma
   data entry 923                      not equal to in () 561
                                                                           adjusting 832
   doing data entry 955                operators 560
                                                                           changing in image 834
   edit or design mode 934             order of evaluation 561
                                                                           defined 832
   filtering data in data              space around (Writer) 304
                                                                        generating
     sources 952                       syntax in Writer and Calc 297
                                                                           bibliographies 355
   formatting manually 933             using in tables 296
                                                                           indexes 342
   formatting with AutoPilot 930    frames
                                                                           tables of contents 332
   form-based filters 953              adding to Writer 239, 297
                                                                        Generic Printer 62
   linking to data sources 883         complex page layout
                                                                        geometry, modifying for 3D
   modifying 933                         example 246
                                                                           object 811
   modifying control labels 935        space around (Writer) 304
                                                                        getting started 41
   new functions 16                    styles 248
                                                                        GhostScript, see PDF, PostScript
   problems entering longer            styles, applying 259
                                                                        GIF
     field 957                         styles, creating 258
                                                                           converting slide to 733
   processing 933                      text flow between 241
                                                                           description 786
   searching 951                       text frames (Writer) 240
                                                                           issues with 786
   searching for records in data       typing in (Writer) 241
                                                                           see also animated GIFs
     sources 951                       unlinking 243
                                                                        goal seek 609
   sorting data sources using 951      using in converted
                                                                        Gouraud 811
   specifying data source 932            presentation 735
                                                                        gradients
   switching data sources 954          Writer 239
                                                                           applying to objects using Area
   tab order, setting 936           FreeBSD plans for
                                                                             window (Draw) 764
   table controls 931                  OpenOffice.org 10
                                                                           applying to objects using object
   viewing data 922, 950            freezing
                                                                             bar (Draw) 763
formula bar, Calc 500                  regions of spreadsheet 552
                                                                           backgrounds, using in 703
formulas                               Writer table cells 286
                                                                           chart fills 593
   adding in (+) 561                From fields and gradients,
                                                                           creating and modifying 805
   adding to Calc as objects 599       creating and modifying 805
                                                                           intensity, selecting 805
   adding to drawings 814           From printer setup 493, 848
                                                                           modifying for 3D object 813
   adding to presentations 695      FTP
                                                                           print settings 87
   adding to Writer 300                example 440
                                                                           selecting 764
   addon program dmaths 560            linking to site 471
                                                                           style lists, where stored 804
   basics 560                          proxy, setting up for 135
                                                                           using as text fill 772
   changing formats 301                using Netscape 440
                                                                           transparency gradient of
   creating files of 302            Function AutoPilot window 567
                                                                             object 767
   Data Pilot and data              function bar 170
                                                                        grail-shaped beacons 888
     sources 515                    functions
                                                                        grant permissions 912
   displaying in cells 587             form, new 16
                                                                        graphics 735, 741
   dividing in (/) 561                 function AutoPilot
                                                                           3D display options 118
   entering manually 563               Function AutoPilot
                                                                           adding to Calc 598
   equals sign in (=) 560                window 567
                                                                           adding to HTML document by
   exponent (^) 560                    IF 572
                                                                             inserting a file containing
   greater-than in (>) 561             in spreadsheets 563
                                                                             graphics 463
   greater-than-or-equal-to in         new in this release 14
                                                                           adding to Writer 274
     (>=) 561
992     Index



  adjusting once inserted            placement behind Writer              snapping objects to 780
    (Writer) 304                       page 236                           unit of measurement,
  background for                     placement in page                      setting 114, 180
    paragraphs 216                     (Writer) 304                       using 780
  background of page 236             positioning behind                   Web setup 435
  backgrounds for pages                paragraphs 216                  group boxes 941
    (Writer) 234                     problems with linking 696         Group object option 720
  broken links 140                   resizing (Writer) 276             grouping
  bullets, creating from 688         scaling well 787                     objects 778
  cell background (Writer) 286       scanning 303                         spreadsheet areas 611
  changing one color to              space around (Writer) 304         groups, editing object
    another 833                      tutorial (Draw) 753                  groups 778
  commercial printing setup 93       typing text inside 684            Guide overhang field 795
  creating and adjusting             unlinking 478                     guided tour
    (Writer) 273                     using for bullets 220                Calc 500
  creating new drawing 750, 756      using Gallery 115                    data source, creating 873
  cropping 836                       ways to insert in HTML               Draw 753
  cropping (Writer) 276                document 463                       HTML document,
  deleting part of 837               Web 463                                creating 444
  displaying lines when              work area (Image) 752                Impress 636
    moving 665                    Graphics window 276, 478                macros 962
  displaying or hiding in HTML    gray boxes                              Writer 170
    documents 435                    turning off in bullets and        Guides When Moving 776, 780
  dragging Gallery objects to          numbering 217
    documents 116                 gray field background, turning
  drawings, opening as               off 232, 859
    presentations 647             grayscale
                                                                       H
  for bullets 220                    applying effect to rasters in
  Gallery images (Writer) 275          Draw 838                        half-width case evaluation 113
  grayscale or watermark 838         displaying presentation in 666    handout view 656
  handouts, adding to 728            example of effect 838             handouts
  hiding (Draw and Image) 664        making image grayscale 838           creating for presentations 727
  HTML code for inserted             print settings 87                    headers and footers 728
    graphic 463                      printing options (Draw) 848          headers and footers,
  HTML export settings 142        greater-than (>) in formulas 561          adding 707
  hyperlinks, adding to 477       green                                   illustration 728
  icon that opens inserted           color, creating or                   orientation 728
    object 299                         modifying 803                      printing only 746
  in Web documents 466               modifying for graphic with        hanging punctuation 112
  inserting 115                        object bar 832                  harmless pranks 723
  inserting in HTML               grid                                 hatches
    document 463                     can’t see 436                        applying to objects using Area
  inserting in presentation 697      displaying 780                         window (Draw) 764, 765
  lining up on a grid                doesn’t appear,                      applying to objects using object
    (Writer) 305                       troubleshooting 436                  bar (Draw) 763
  linking to (Writer) 275            icons for use, illustration 780      backgrounds, using in 703
  linking to macro or                illustration of features 773         creating and modifying 805
    JavaScript 490                   Impress 665                          modifying for 3D object 813
  links to, editing (Web) 464        lining up objects (Writer) 305       style lists, where stored 804
  memory used 119                    setup 778                            using as text fill 772
  moving on specified path           setup window 779                  headers
    (Impress) 714                    showing (Writer) 306                 adding to slide 706
  opening drawing 756                snap setup 779                       complex example 230
  paragraph backgrounds 216          snap to (Writer) 306                 date field and format 232
                                                                                     Index       993



   different within document 228,   Help Agent                         adding to drawings 815
     233                               turning off 129                 adding to presentations 696
   formatting 232                   hidden                             AutoPilot, using 446
   handouts, adding to 707, 728        hidden paragraph field 863      background color setup 434
   HTML 467                            hidden text field 863           backgrounds for
   illustration in slide 706        hidden pages                         documents 447
   in books and longer                 printing 745, 848               conversion, backgrounds,
     documents 319                  hidden slides, printing 848          issues 700
   in master documents 329          hiding                             converting documents to 448
   inserting fields 231                cells when printing 546         converting spreadsheets to 448
   margins 230                         elements of HTML                displaying according to Page
   removing 232                          documents 435                   Format options 467
   running 320                         hidden pages printing options   displaying or hiding elements
   showing headings in 320               (Draw) 848                      of 435
   spacing of (Calc) 550               layers 661                      export settings 142
   spreadsheet 549                     macro modules 971               finding template that a
   tables, specifying options 455      note markers (Writer) 424         document is based 447
   variables, creating 320             objects (Impress, Draw) 664     fonts, changing defaults 447
   viewing (Web) 467                   rows and columns (Calc) 537     formatting text 462
   Writer 228                          sections (Writer) 409           from Writer 179
headings                               slides 677                      graphics in, example 466
   changing angle of in cells 544          printing 745                graphics, using in 463
   changing default font               subpoints 678                   grid options 435
     (Impress) 692                         printing 678                guided tour of creating
   demoting to bulleted items 676      zero values in cells 541          document 444
   including in sort 575            Hierarchical styles category       icons 470
   inserting (Web) 467                 Calc 556                        importing tables into
   linking to within HTML              Writer 250                        spreadsheets 15, 511
     document 472                   high definition filter 842         interchangeability 462
   printing repeated (Calc) 626     highlighted field in HTML          new document 443, 446, 447
   repeating in Calc 626               documents 435                   notes 460
   showing in headers and           highlighting                       opening files by default in
     footers 320                       entire data area (Calc) 524       OpenOffice.org 29, 152
   table heading, repeating            entire rows, columns, and       opening HTML table in
     (Writer) 279                        sheets 535                      Calc 511
   table heading, repeating more       nonconsecutive text             opening text files in
     than one (Writer) 282               blocks 185                      HTML 448
height                                 paragraphs with color 209       page layout 466
   Calc rows 536                       value highlighting 588          printing options 493
   text frames, setting 683            value highlighting in           Quick Start 442
Height field                             spreadsheets 615              saving document as
   duplicating object 817           Hiragana 113                         HTML 144
   presentation page setup 673      horizontal                         saving documents in 448
help                                   distribution options 774        saving presentation as 733
   adding to spreadsheets 605          flipping objects 782            saving spreadsheet as 519
   Help Agent 97                       lines, drawing 767              source for creating targets 473
   information online 39               lines, inserting 276, 465       source text options setup 435
   knowledge database 39               snapping to, see grid 767       source, editing 461
   newsgroups 39                       sort (Calc) 575                 started converted
   tooltips 97                      hot dish 347                         presentation 737
   turning off Help Agent 129       HTML                               styles 451, 453
   Web sites 39                        adding date and time when       table of contents 472
   see also guided tour,                 inserting note 460            table setup for 279, 453
     troubleshooting                                                   table, inserting new 455
994       Index



   tags to link to targets within        demote/promote 676                   work area 752
     document 473                        dimension line 793                import personal data 26, 45
   templates 451-452                     drawing multiple objects          Import Styles window 266
   templates, types of 446                 without reselecting 762         importing
   text formatting example 462           finding right icons on object        databases 880
   tutorial, creating a new                bar 100                            delimited text files into
     file 444                            grid 780                               Calc 513
   view options for Web 435              hidden menu items 101                formula files 302
   Web features 442                      Hide Subpoints 679                   Microsoft Office
   Web work area 443                     increasing icon size 106, 108          documents 161
HTML source                              Insert tearoff menu objects 695      Microsoft Office
   nested tables 458                     interaction 717                        templates 269
   what source looks like 450            Live Mode 732                        non-Writer documents 178
HTML styles category 250                 Mouse pointer as pen 732             problems importing files 28
HTTP                                     object bar icons 768                 styles from another
   proxy, setting up for 135             objects to add to                      document 265
hue                                        presentations 695                  templates 268
   color, creating or                    s 679                                text files into Calc 513
     modifying 803                       Show Subpoints 679                Impress
   modifying for 3D object 812           text formatting in object bar        adding other files to
Hyperlink window 471-473, 476-             (Impress) 686                        presentations 695
   477                                   text option setup 679                drawings, opening as
hyperlinks 272                           text-creating 680                      presentations 647
   adding to documents 470               viewing hidden icons 100, 101        features 634
   as cross-references 332           IDE                                      guided tour 636
   assigning macros to 272               module, creating with 969            new features 16
   automatic formatting 124          IF function 572                          opening presentation 647
   bar, overview 436, 470            Ignore double spaces option 125          opening presentations in
   displaying style 272              illumination for 3D object 812             Draw 757
   Hyperlink Dialog icon 470         Illustrator                              player, installing 42
   Hyperlink icon 470                    Illustrator-like text                printing options 745
   icon that opens inserted                features 819                       Quick Start 634
     object 299                          inserting object created in 299      Quick Start checklist 634
   icons, example of use 470         image buttons in animated GIF            work area 635
   linked cross-references 332           window 720                        In Front of Object option 777
   table of contents entries 338     image maps 484-485                    Incan monkey god 428
hyphenation                          images                                inches, unit of measure 180
   controlling 196                       changing contrast and other       Included outline levels
   paragraphs 213                          settings 834                       option 644
   setup 212                             changing one color to             Increments field
                                           another 833                        Area window 764
                                         converting to Draw                   cross-fading 823
                                           objects 827                        text marquee options 483
I                                        creating and adjusting            indenting 676
                                           (Writer) 273                       bulleted items (Impress) 686
icon tips 97                             cropping, any shape 836              lists 219
icons                                    cropping, standard 835               numbering, bullets,
   All Levels 679                        deleting part of 837                   outlining 221
   attributes, applying to objects       editing window 752, 785              paragraphs 208, 211
     (Draw) 763                          grayscale or watermark 838           paragraphs (object bar) 200
   can’t find 711, 715                   in Web documents 466              Index styles category 250
   changing on toolbar 761               inserting in presentation 697     indexes
   connector 793                         scaling well 787                     assigning levels (keys) 343
   curves, editing 801                   scanning 303                         automatic capitalization 344
                                                                                        Index       995



    concordance, using to             Insert Picture window,              predefined text 180, 866
      create 345                        Impress 698                       rows and columns (Calc) 537
    creating 342                      Insert Plugin window 486            sections (Writer) 409
    deleting 349                      Insert Script window 488            sheets into a spreadsheet 521
    edit window 349                   Insert Section window 411,          slides 671, 674-675
    editing 348                         414                               slides and selecting layout 672
    formatting 348                    Insert Sheet window 522             spreadsheets (Writer) 291
    gray background behind            Insert Table window 278, 455        table rows and columns
      entries 349                     Insert Text window 696, 697           (Writer) 282
    index of tables 352            inserting                              tables of contents 334
    inserting into a single           adjusting objects once              text boxes (Writer) 239
      document 344                      inserted 304                      text-based file 479
    inserting into master             AutoText in documents 184,       installation 20
      documents 348                     870                               custom standard or
    locating markers 349              bibliographies into master            minimum 27
    making read-only 344                documents 356                     downloading StarOffice 20
    marking entries 343               bibliographies into single          installed wrong language 38
    page ranges, showing 344            documents 355                     installing additional
    regenerating 349                  bibliography references 354           components 34
    table design for data             captions 306                        JRE 30
      sources 910                     charts (Calc) 590                   locations where files
    troubleshooting 349               charts (Writer) 290                   installed 36
    updating 349                      documents (Writer) 302              multi-user 31
information field 863                 external data, HTML into            permission denied message 23
information online 39                   spreadsheets 511                  permissions 32
initials, adding to HTML              fields in headers and               problems with Linux 38
    note 460                            footers 231                       repairing 40
input field 862-864                   floating frames (Calc) 599          single-user 24
Insert Points icon 800                floating frames (Writer) 240        system requirements 22
insert reference field 862            footnotes 227                       trouble-shooting 37
Insert row, HTML table setup          formulas (Writer) 300               troubleshooting 37
    window 279, 454                   formulas as objects (Calc) 599      type to select in window 27
insertion windows                     frames (Writer) 239, 297            uninstalling 40
    Insert Applet window 486          graphics and drawings               Windows notes 23
    Insert Bibliography Entry           (Calc) 598                     Interaction icon 711, 715, 717
      window 354                      graphics and drawings            Interaction window 718
    Insert Break window 260, 323        (Writer) 274                   Internet
    insert formula field 864          horizontal line graphic             browsing 443
    Insert Graphics window 275          (Writer) 276                      converting documents to
    Insert Index Entry                indexes into a single                 HTML 448
      window 334, 343                   document 344                      Internet URLs field 470
    Insert Index window               indexes into master                 linking to URL using
      (Entries) 338                     documents 348                       Hyperlink window 471
    Insert Index window               links to other spreadsheet          new document 443
      (Index) 335, 337, 344, 351        files 585                         proxy setup 135
    Insert Index window               lists of figures into single        Quick Start, Web 442
      (Styles) 341                      documents 350                     searching from program 136,
    Insert Layer window 659           notes in documents (Calc) 622         438
    Insert Note window 423, 460       notes in documents                  Web features 442
    Insert OLE Object                   (Writer) 423                      Web work area 443
      window 293, 481, 699            object created in any            interrupting page flow 259
    Insert Options window               application 298                intersecting
      (Writer) 307                    page numbers in                     hatches, creating and
                                        spreadsheets 550                    modifying 806
996       Index



    formulas 561                         see also alignment              Language Options window 196
    objects 830                                                          languages available 7
    objects, example 828                                                 lastturtle.com 20-21
invalid entries, preventing                                              lawyers and WordPerfect 411
    (cells) 603
                                     K                                   layers
inversion, solarization filter 842                                           creating, illustration 659
invisible                            Katakana 113                            defaults 658
    applying to objects using Area   keep with next paragraph 213            deleting 662
      window (Draw) 764              kerning 203, 207                        hiding 661
    backgrounds 704                  Key1 for concordance 347                illustration of navigation 660
    line attribute 768               keyboard shortcuts                      illustration of use 660
ISPMT function 14                        assigning 104                       Insert Layer window 659
italics                                  assigning macros to 105             layer view 657
    formatting icon (Impress) 686        Calc 508                            layer view, overview 657
    formatting, object bar 200           viewing available 105               locking 661
                                         Writer 175                          moving objects between 662
                                     keys, index 343                         preventing editing and
                                     keywords                                  printing 661
J                                        keywords field 863                  renaming 661
                                         slide backgrounds 702               selecting one 660
Japanese                             killer whales 801                       specifying which is on top 660
   searching in Japanese             Korean, see Asian                       with modes and master
     setup 110                                                                 views 653
   see also Asian                                                        layout
Java
   developers’ manual 10
                                     L                                       selecting for slide 672
                                                                             setup options 83, 234
   installation 29, 30                                                       see also slide layouts, page
   JRE 30, 34                        labels
                                        adding to charts 591                   layout
   setup options 149                                                     LDAP
   why needed 30                        axes in charts 591
                                        axes, entering 592                   address book data source 900
Java Database Connectivity, see                                              tips for data sources 901
   JDBC                                 database fields, modifying 935
                                        new features 14                  leader dots on tabs 214
JavaScript                                                               leading zeroes 287, 543
   adding to document 487               quick insertion with
                                          AutoText 398                   left alignment (object bar) 200
   assigning to event 949                                                Left field
   linking graphic to 490               simple 394
                                        with fixed data 389                  guide field 795
   see also scripts                                                          presentation margins 673
JDBC                                    without variables 397
                                     landscape                               text frame options 683
   driver 879                                                            left pages
   overview 879                         Calc 547, 624
                                        page within portrait document        printing 86
   syntax 895                                                                setting 234
   troubleshooting 896                    (Writer) 238
                                        printer setup 61                 left-justifying text (Impress) 686
joining cell data 581                                                    legal documents 411
JPG                                     setup options 83
                                        Writer page layout 233, 238      legend, chart 590-591
   converting slide to 733                                               less-than-or-equal-to ( 561
   description 786                   landscape
                                        and portrait, switching          letterhead, inserting
JRE 30, 34                                                                   automatically 180, 866
jumping to cells 524                      between 260
                                        presentation page setup 673      letters
justification                                                                creating with AutoPilot 176
   alignment (object bar) 200           Writer 234
                                        see also orientation, page           mail merge letters
   paragraphs 212                                                                AutoPilot 367
   text formatting icon                   layout
                                     language and spelling                       creating your own 378
     (Impress) 686
                                        options 191                          printing mail merges 399
   text (Impress) 686
                                                                                              Index        997



levels                                    style lists, where stored 793         system requirements 22
    index 343                             styles, creating and                  see also UNIX
    outline numbering 317                   modifying 791                   List styles category 250
libraries                              linking                              lists
    Attach file option 968                forms to data sources 883             dropdown lists
    creating new 968                      objects, problems with 696            dropdown lists in spreadsheets
    Macro Organizer window 968            sections in other document 416          (scenarios) 605
    macro, creating 968                   spreadsheets 583                      drop-down lists, adding to
    managing macro libraries 970          to data in other Calc files 585         forms 939
    moving module to different            to sheets in other                    figure lists, inserting into
      library 970                           spreadsheets 522                      documents 350
ligatures 207                             to spreadsheet in Writer              indenting and restarting 219
light source, modifying for 3D              (Windows only) 294                  list boxes, adding to forms 944
    object 812                            unlinking 472                         list boxes, examples 927
Lindows 21, 23                            unlinking frames 243                  numbers, formatting
line break (text wrap) 528, 544        links                                      differently 225
line contour only 664                     adding to documents 470               restarting at 1 226
Line Numbering window 227                 adding to graphics 477                selection list in Calc 532
Line skew fields 797                      assigning macros to 272               sort list in Calc 532
Line type field                           between spreadsheet files 585         style lists, defined 792
    hatches, creating and                 broken 140                            tables of figures and other
      modifying 806                       create new file 476                     items 350
    object bar icon 768                   creating email with 475               tables of figures in master
Line window 769                           data sources 883                        documents 352
lines                                     DDE, sections (Writer) 417        literal text in cells 529
    adding connector points 798           displaying style 272              Live mode for presentations 732
    around cells, quick 541               editing OLE and graphics links    Load Slide Layout window 702
    arrowheads, matching 769                464                             loading
    changing attributes                   hyperlink bar, displaying 436         backgrounds, see backgrounds
      quickly 768                         icon that opens inserted              styles from another
    connecting to text frames 799           object 299                            document 265
    connectors, drawing 796               Link icon 470                     locations
    conversion options 824                modifying in Hyperlink                default directory for saving and
    converting to curves 825                window 478                            opening 132
    curving text along 819                modifying text/ button                for AutoText 182
    dimension lines, drawing 794            link 478                            relative or absolute URLs 138
    displaying lines when moving          news document 475                     where files are stored 36
      objects 665, 776                    target within a document 472          where files installed 36
    drawing 767                           target within a document          locking
    drawing vertical, horizontal, or        (HTML tags) 473                     layers 659, 661
      45-degree 767                       unlinking text link 478               Writer table cells 286
    hiding (Draw and Image) 664           unvisited 272                     logo
    in charts 593                         updating in master                    adding to page
    inserting (Web) 465                     documents 330                         background 236
    Line Styles tab 791                   updating spreadsheet                  handouts, adding to 728
    moving object on specified              objects 599                         in converted presentation 736
      path (Impress) 714                  using Hyperlink window 471            presentation 730
    numbering 226, 419                    visited 272                           showing when running 947
    object bar icons 768                  Web page, linking to using            see also graphics
    paragraph borders 216                   Hyperlink window 471            long documents
    properties window 769                 Writer 272                            overview 312
    snap lines setup 779               Linux                                    see also master documents,
    stacking lines of text 190            installation notes 23                   books
    straightening 767                     permission denied message 23      LONG VARCHAR 908
998      Index



loop, running presentation            running one line at a time 973      warning dialogs 93
   in 730                             security 150                        Writer page layout 233, 238
low definition filter example 842     setup, required 966               markers for notes, showing and
lowercase, automatic 122              shortcut keys, assigning to 972     hiding (Writer) 424
Luminance field 803                   troubleshooting 152, 960, 975     marquees 483
                                      where displayed in editing        master documents
                                        window 965                        chapter numbering in 327
                                    magenta 803                           creating 328
M                                   magnification                         editing source files 329
                                      changing on status bar 170          example 327
MacOS                                 setting default values 114          headers and footers 329
  making program look like          mail merge                            indexes 342
    Mac 106                           data for business cards and         inserting bibliographies 356
  plans for OpenOffice.org 10           labels 363                        inserting indexes 348
Macro Organizer window 968            data source for, creating from      inserting tables of contents 335
macro recorder 960                      text file 882                     links, updating 330
macros                                data used in, setting up 362        moving within using
  adding to documents 976             dragging fields into a                Navigator 313
  appendix 960                          document 380                      page styles 329
  Assign Macro window 489             dragging fields in,                 principles 326
  assigning shortcut key to 972         troubleshooting 378               tables of contents 332
  assigning to keyboard               empty fields, fixing 403            tables of items 352
    keys 105                          fields used in 858                  updating 329
  breakpoints 974                     filtering database records 363      updating styles 330
  breakpoints, using with 974         fixing blank line 404             master pages, see backgrounds
  comments, adding to 975             fixing empty space 403            master sheets, creating 583
  creating new modules 969            layout tips 402                   master views
  deleting 971                        letters and faxes                   descriptions 653
  documents, adding to 976                AutoPilot 367                   selecting one 654
  editing 974                             creating your own 378           with layers and modes 653
  editing window 965                                                    match case for concordance 347
                                      overview 360
  events 927                                                            matrix array 15
                                      printing 399
  events, assigning to 949                                              mbx files, migrating 49
                                      printing from spreadsheet 625
  Excel 960                                                             measurement, see unit of
                                      queries and filters 363
  execute macro field 862                                                 measurement
                                      removing empty fields 403
  finding samples 960                                                   meddling fishwife 428
                                      spacing between fields 403
  forms and controls 927                                                memo, creating with
                                      switching data source 376
  getting more information 960                                            AutoPilot 176
                                      troubleshooting 399
  HTML export settings 142                                              memo field types 908
                                    manifest.xml 147
  library, creating 968                                                 memory
                                    manual page break 175
  linking to 487                                                          graphics memory used 119
                                    manual slide transition,
  Macro Organizer window 969                                              reducing requirements 664
                                      specifying 721, 730
  macro recorder 960                                                      see system requirements 22
                                    maps, see image maps
  Macros window, organization                                           memory required 22
                                    margins 673
    of macros 967                                                       menu bar
                                      around text frames 691
  migrating 52                                                            Calc 500
                                      headers and footers 230
  moving using IDe 970                                                    Writer 170
                                      inside cells 544
  organizing 966                                                        menu tips 97
                                      overview 84
  running 971                                                           menus
                                      printer setup 61
      breakpoints 974                                                     context 108
                                      setup 84
      complete macro 973              slides 673                          customizing 102
      one step at a time 973          snapping to 779, 781                hidden menu items 101
      selected macro 973              spreadsheets 547                    increasing font size 106
  running first in module 973                                             right-click 108
                                                                                        Index       999



   seeing all items available 99     with master views and               templates to different
   setup 98                            layers 653                          categories 270
merges, see mail merges            Modify Slide window 672, 673        multi-file books, see master
merging                            modifying                             documents
   3D objects 809                    AutoText entries 182, 868         multiple pages per sheet of
   cells (Calc) 542                  bibliographies 356                  paper, printing 85
   cells (Writer) 289                chart details 595                 multiplying (*) in formulas 561
   data in cells 542                 charts 592                        multi-user installation 31
   objects 830                       master document source            MySQL
   objects, example 828                files 329                         data source using JDBC 893
   table cells (Writer) 282          modified field 863                  database connection
meta.xml 147                         notes in documents 424                overview 854
metafiles                            scenarios in spreadsheets 607       JDBC syntax 896
   conversion options 824            sections 417                        troubleshooting 893, 896
   converting Draw objects           sort lists 534                      UNIX use with ODBC 881
     to 827                          standard template (Writer) 264
Microsoft                            styles 260
   Access, see Access                styles (Calc) 557
   converting to and from            styles using drag & drop 261
                                                                       N
     Microsoft Office 160-161        tables of contents 341
   opening files by default in       templates 268                     Name field
     OpenOffice.org 29, 152        modules                                color, creating or
   saving automatically in MS        creating new for macros 969            modifying 802
     format 163                      creating using IDE 969               custom presentation 723
   SQL Server, see SQL Server        creating using Organizer 969         Graphics window 478
   switching from 11                 deleting 971                         Hyperlink window 471
Microsoft ActiveX Data               hiding 971                           layers 659
   Objects 878                       moving to different library 970      search setup 137
migration 44                         moving using IDE 970              names
   converting 5.2 files 50           renaming 970                         data source tables 911
   databases 52                      renaming macro modules 970           document, specifying name
   email 49                          running first macro in 973             for 646
   email, address book,            Monopoly 580                           documents 154
     newsgroups 46                 morphing                               of creator, adding to
   macros 52                         colors when duplicating                presentations 699
   overview 12                         objects 816                        slide name 672, 673
   schedule 49                       see also cross-fading                spreadsheet areas 611
   settings from 5.2 45            mortgages, calculating using           templates 649-650
   supported address book data       scenarios 606                        yours showing up in
     source formats 900            mosaic filter 839                        document 155
   UNIX printers                   mouse                               naming spreadsheet areas 611
millimeters, unit of                 lefties 108                       nap fairy 422
   measurement 180                   right-click 108                   Navigator
minimum installation 27            Mouse events 948                       and editing OLE objects 480
minions, smart alec 171, 422       Move Points icon 800                   Calc 524
MIRR function 14                   moving                                 illustration 524
misspellings                         AutoText entries to different        illustration (Impress) 668
   correcting automatically 121        categories 183, 869                inserting existing slides 674
   underlining 191                   objects (Writer) 304                 master document 328
   see also spellcheck               objects between layers 662           master document view 313
models of color, see color           objects, displaying lines            moving among slides 668
modes                                  when 665, 776                      opening 731
   selecting one 658                 sheets 523                           opening and closing 175
1000     Index



   running presentations              inserting in HTML 460               text (Draw) 771
     using 731                        markers 424                         text before and after 223
   setting table name that            printing (Web) 493                  turning off shading 217
     appears 455                      printing (Writer) 424, 427          turning on/off (Impress) 688
   starting 313                       printing HTML notes 461             Writer 217
   toggling between normal and        showing and hiding script         Numbering/Bullets window
     master document 313                indicators 487                      218, 222, 224
   using 314                          viewing (Writer) 424              numbers
   using (Calc) 523                   see also speakers’ notes            creating your own formats 287
   using (Writer) 312              notes view 656, 726-727                document number field 863
   visible when running            number format                          entering in cells 528
     presentation 730                 choosing 287                        format in cells 540
   window 314                         setting in tables 455               formatting for fields 865
negative numbers, setting to red      user-defined 287                    formatting in tables 286
   in cells (Writer) 287           Number Format window                   formatting numbers of
nested tables                         (Writer) 287                          numbered lists 225
   Web 456                         number sequence field 864              record number field 865
   Writer 280                      numbered lists, formatting             wider than cells 529
network installation                  numbers 225
   running 31                      numbering
   troubleshooting 32                 automatic 125
new document, creating using          bibliography references 355
                                                                        O
   hyperlink 476                      Calc page numbering
New window (template) 177,              issues 551                      oatmeal 474
   510                                captions 309                      object bar
newsgroups                            formatting in cells                  Calc 500
   migrating 46                         (Writer) 286                       formatting text using
   StarOffice 39                      levels of 217, 220                     (Draw) 771
next page style 258                   lines 226, 419                       line attributes 768
next paragraph style 252              lines for proofing (Writer) 214      switching between table and
next record field 865                 Numbering/Bullets window               text 282
No proxy for option 135                 (Graphics) 220                     table 282
No transparency option 767            page n of m, formatting 231          Writer 170
nonbreaking space 175                 page numbering in books 322       object bars
nonconsecutive                        pages 322                            attributes, applying to objects
   cells 561                          pages, Calc 549                        (Draw) 763
   text, selecting 185                paragraphs 200, 214                  character formatting 200
nonprinting characters,               position settings 224                finding right icons 100
   displaying or hiding in            primary control window 221           image options 832
   HTML documents 435                 removing 259                         setup 98
non-scrolling regions 553             restarting 219                       table tools (Writer) 281
not equal to () in formulas 561       restarting at 1 317               object frames and points,
not panicking xviii                   saving customizations 224            snapping to 779
notes                                 setting font style 223            objects
   browsing sequentially 460          setting up (Impress) 689             3D, see 3D 808
   displaying or hiding in HTML       setup (Writer) 213                   adjusting once inserted
     documents 435                    simple page numbering 322              (Writer) 304
   editing (Writer) 424               space to text 224                    aligning 774
   editing in HTML 460                styles 248, 256                      applying styles to (Draw) 758
   how indicator looks in HTML        styles, creating 256                 applying (Draw) 763
     document 459                     styles, using with paragraph         changing one into another, see
   in HTML, example 459                 styles 257                           cross-fading 822
   inserting (Calc) 622               switching page numbering             color, working with in
   inserting (Writer) 423               styles 322                           Draw 801
                                                                                          Index      1001



   conversion/combining effects,      inserted spreadsheet,                 printing 76
     examples 828                       example 481                         setup (Calc) 507
   converting to other object         inserting in document 479             setup (Writer) 174
     type 823                         inserting in slide 698                word completion 127
   copying and duplicating            links to, editing (Web) 464        Oracle
     (Draw) 815                       Navigator, using when                 data source using JDBC 893
   created in any application,          editing 480                         data source with ODBC 887
     inserting 298                 online help                              database connection
   creating basic objects in          adding to spreadsheets 605              overview 854
     Draw 761                         turning off Help Agent 129            JDBC syntax 895
   cross-fading 822                online information sources 39            ODBC syntax for data
   curving text along 820          Open Database Connectivity, see            sources 890
   displaying lines when              ODBC                                  troubleshooting 892, 893, 896
     moving 665, 776               opening                                  see also data sources
   displaying or hiding in HTML       default directory for saving and   order
     documents 435                      opening 132                         algebraic 561
   distributing 774                   non-Writer documents 178              calculation 562
   drawing multiple without           presentations 647                     evaluation in formulas 561
     reselecting icon 762             prior versions of                     object effects 713
   editing object groups 778            documents 407                       tabbing in forms 936
   flipping 782                       selecting type of dialog box 31    organizational charts
   grouping 778                    OpenOffice.org 4                         adding connector points 798
   in Web documents 466               books 21                              creating 690
   inserting 115                      CDs, ordering 20                      formatting 692
   moving (Writer) 304                developers’ manual 10                 positioning elements 692
   moving on specified path           developing for 7                   organizing
     (Impress) 714                    downloading 20                        AutoText entries 183, 868
   positioning 775                    extra files, templates 510            macro libraries, creating 968
   problems with linking 696          file application formats 511          macro module, creating 969
   resizing 777                       font substitution 74, 82              templates 269
   resizing (Writer) 305              FreeBSD development 10             orientation
   rotating 782-783                   getting started 41                    and backgrounds
   scaling well 787                   MacOS development 10                    (Impress) 701
   snapping to 781                    migration from StarOffice 5.,         Calc 547, 624
   space around (Writer) 304            see migration                       documents (Draw) 757
   styles (Impress) 693               new features 13                       Impress 743
   typing text inside 684             new features mailing list 8           portrait page within landscape
   using Gallery 115                  online information sources 39           document (Writer) 238
ODBC                                  opening Microsoft files in 152        presentations 745
   connection pooling 892             platform development 10               printer setup 61
   creating data source 887           PowerPC development 10                setup options 83
   overview 878                       reinstalling 35                       slide handouts 728
   syntax for data sources 890        removing 40                           slides 673
   troubleshooting 892                still running 38                      switching between landscape
   UNIX database access with          Washington Post review 8                and portrait 260
     MySQL 881                        XML configuration files 146           troubleshooting 756, 757
Office, see Microsoft              operating system, see system             warning setup 94
offset for bitmaps 765-766            requirements                          when cross-fading 823
OLE security 150                   operators in spreadsheets 560            Writer page layout 233, 238
OLE objects                        optional hyphens, displaying or       orphans, controlling 213
   adding to drawings 814             hiding in HTML                     outline levels for presentation
   adding to presentations 695        documents 435                         and AutoAbstract 644
   inserted blank spreadsheet,     options                               outline numbering
     example 482                      language and spelling 191
1002      Index



   applying an existing               fitting a page onto one sheet of      breaks in tables 283
     format 319                         paper 86                            Calc, things that affect
   level 317                          left only or right only 86              numbering 551
   saving different versions 318      mail merge layout tips 402            changing columns 237
   window 310, 317, 318               margin warning dialog 94              changing flow 259
outline view                          object placement (Writer) 304         creating styles (Calc) 557
   illustration 654                   page and section breaks 212           empty, suppressing 15
   overview 654                       page styles (Calc) 557                fitting slide on one page
   printing only 746                  printing more than one page on          (Draw) 846
   rearranging slides in 670            a sheet 85                          fitting slide on one page
outlining 217                         printing more than one page on          (Impress) 743
   Calc 610                             a sheet (Writer) 428                flow, Calc 549
   changing numbering style           removing empty pages 196              flows 259
     between levels 222               setup options 83                      footnotes 228
   customizing 220                    spreadsheets 624                      layout 234
   customizing levels 222             styles (Writer) 257                   left and right 234
   numbering 316                      text flow between frames 241          next style 258
   outline numbering 314              Web 466                               number to print spreadsheets
   paragraphs quickly 217             Writer 233, 238                         on 630
   saving customizations 224       page margins, snapping to 779,           numbering 322-323
   showing levels 223                 781                                   numbering, Calc 549
   troubleshooting 223             page numbers                             page count fields 231
   using the tab key 218              handouts, adding to 728               page field 861
Outlook                               in spreadsheet headers and            page n of m, formatting 231
   address book as data                 footers 550                         Page name printing option
     source 900                       numbering 322-323                       (Draw) 848
   tips for data sources 901       page orientation, setup                  printing more than one page on
oval                                  options 83                              a sheet 85
   aligning text to 820            page preview                             printing more than one page on
   see also ellipses                  Calc 551                                a sheet (Writer) 428
overriding page flow 259              printing from (Writer) 428            printing more than one slide per
overview                           page setup                                 page (Draw) 846
   data sources 872                   Draw 757                              printing more than one slide per
   mail merge 360                     printer margins 61                      page (Impress) 742
   main features 6, 13                troubleshooting 76, 79, 756,          printing multiple slides per
   see also guided tour                 757, 849                            printing options (Calc) 547
overwriting styles 265             Page Setup window                        removing empty 196
                                      Impress 673, 745                      simple page numbering 322
                                      presentations 673                     size 234
                                      slide backgrounds 704                 spreadsheets, things that affect
P                                  Page Style window 83, 258, 547-            numbering 551
                                      550, 628                              stretching slide to fill a page
page breaks 175, 259, 551          page styles                                (Draw) 847
page flow                             breaking to new 213                   stretching slide to fill a page
   Calc 549                           creating (Calc) 557                     (Impress) 743
   see also page layout               headers and footers,                  styles (Calc) 557
page layout                             changing 229                        styles (Writer) 248, 257
   advanced (Writer) 239           pages                                    styles, master documents 329
   backgrounds (Writer) 234           adding borders 235                    styles, next 258
   Calc 547                           adding to drawings 757                switching between landscape
   columns (Writer) 236               adding to presentations 699             and portrait 260
   complex example 246                background color and               pages per sheet, printing
   drawings 757                         graphics 236                        multiples 85
                                      backgrounds (Writer) 234           pair kerning 203, 207
                                                                                           Index     1003



palettes                               combining 126                        AutoText storage
   adding or modifying 804             count words in 187                     locations 182
   changing color models 803           creating caption                     backup files 132
   where stored 803                      numbering 309                      changing in dialog boxes 134
paper                                  creating styles by drag &            changing to folders 132
   format 234                            drop 254                           default directory for saving and
   format, selecting 76, 79, 756,      customizing bullets, numbers,          opening 132
     849                                 outlining 220                      download 132
   fitting document onto one           drop cap 215                         editing file locations 36
     sheet 86                          first characters different 215       graphics 132
   Paper format field,                 formatting 208                       my documents 132
     presentations 673                 hidden paragraph field 863           Path button, AutoText
   Paper source field,                 hyphenation 213                        window 181
     presentations 673                 indenting 208, 211                   Paths Options window 133
   printing multiple slides per        indenting (object bar) 200           relative or absolute URLs 138
     page                              justifying 212                       relative paths display absolute
   saving 85, 744                      keep with next 213                     in tool tips 471
   size                                large first letter or word 215       troubleshooting 140
        printer setup 61               line numbering for                   viewing and setting 36
        warning setup 94                 proofing 214                    PBM, description 786
   source, selecting 234, 493          next style 252                    PDF
   UNIX printers 60                    numbering (object bar) 200           native printing in new build 67
paragraph formatting                   numbering and bullets 214            Postscript printer driver for
   background 215                      outlining quickly 217                  Windows 77
   columns for paragraph               positioning graphics                 PostScript, converting to 78
     (Writer) 237                        behind 216                         printing
   conditional styles 252              putting in a box 215, 235                UNIX 79
   first characters different 215      restarting numbering 214                 Windows 79
   format painter 201                  setting numbering font 223           printing considerations 77
   inline text explanations 190        setting tabs 209                     printing to 77
   numbering, bullets,                 spacing between 211                  troubleshooting 68
     outlining 217                     stray lines 213                      UNIX setup 67
   Paragraph Format window 210         styles 248, 251                      Windows printing
   Paragraph Style window 252          tab setting 214                        considerations 77
   Paragraph window 211, 687           updating styles 261               percentages
   removing 463                        updating styles                      entering in cells 529
   return markers, showing or            automatically 252                  format for cells 540
     hiding in HTML                 parentheses for calculation          Perl WebCast script options 741
     documents 435                     order 562                         permission denied, Linux
   styles 251                       passwords                               install 23
   styles, applying 259                cells and sheets 602              permissions for multi-user
   widow and orphan control 213        for documents 149                    installation 32
   window 210                          password-protecting               personal data
paragraphs                               documents 158                      import selection 26
   aligning (object bar) 200           protecting section contents 413      migrating 45
   alignment 212                       protecting text from              PGM, description 786
   background color 209                  modification 197                Phong 811
   background color or                 removing for documents 158        photos
     graphics 216                   Paste Special window 581                adding to drawings 815
   borders 216                      pasting, paste special (Calc) 580       see also drawings, graphics
   breaking to new page style 213   paths                                picas 180
   bullets (object bar) 200            adding more for file selection    picture placeholders 664
   columns (Writer) 237                  windows 648                     pictures 216
1004      Index



   adding to Calc 598                  Calc 547, 624                    adding other files to 695
   adding to drawings 815              page within landscape            AutoPilot, turning off 648
   adding to Writer 274                  document (Writer) 238          background view 657
   background of page 236              printer setup 61                 changing font styles for new
   cell background (Writer) 286        setup options 83                   presentations 695
   creating and adjusting              switching to landscape 260       converting
     (Writer) 273                      Writer page layout 233, 238           automatic 738
   cropping 836                     ports and proxies, setting               colors 737
   cropping (Writer) 276               for 135                               example of result 738
   deleting part of 837             Position and Size window                 issues 733
   grayscale or watermark 838          positioning objects 775               naming 739
   in Web documents 466                resizing 777
                                                                             navigation 736
   inserting in presentation 697       rotating objects 783
   lining up on a grid              positioning                              starting converted 737, 741
     (Writer) 305                      behind paragraphs 216                 to HTML 733
   linking to (Writer) 275             displaying object lines when          to other file formats 732
   paragraph backgrounds 216             moving 776                          to Powerpoint 732
   placement behind Writer             using arrows and Shift 775            to raster 733
     page 236                          using Position and Size               WebCast 738
   resizing (Writer) 276                 window 775                     creating
   scaling well 787                    see also snap, grid                   AutoAbstract options
   scanning 303                     poster filter example 840                  window 644
   space around (Writer) 304        PostScript                               based on Writer
   work area 752                       level for UNIX printers 60
                                                                               document 639
placeholder field 862                  level, printer setup 62
plugins                                PDF, converting to 78                 from scratch 645
   adding to documents 486             printer driver for Windows 77         Send AutoAbstract to
   adding to presentations 696         printing 78                             Presentation 642
   Insert Plugin window 486            printing considerations 77            Send Outline to
PNG, description 786                   printing to 77                          Presentation 641
Point reduction 779, 827               printing to, file extension to        using AutoPilot 639
point size                               use 78                         creating, procedures 638
   formatting icon (Impress) 686       reading files 77                 custom 722-723
   text (Draw) 771                     troubleshooting 78               dark background, not
   see also formatting, font           Windows printing                   printing 848
points                                   considerations 77              default settings,
   adding and modifying for         PowerPC plans for                     modifying 692
     Bezier curves 800                 OpenOffice.org 10                displaying in black 666
   adding to connector lines 798    PowerPoint                          displaying in grayscale 666
   measurement 180                     converting 161                   fitting slide on one page 743
   snap points and object points,      opening 647, 732                 frames, using in converted 735
     setup 779                         opening MS files in StarOffice   grid 665
polygons                                 or OpenOffice.org 29, 152      handouts, creating 727
   converting curves to 826            saving presentation as 732       hiding objects 664
   converting to 3D 825                switching from                   opening 647
   converting to curves 829            troubleshooting 647              opening as Draw file 757
   converting to other Draw         PPM, description 787                orientation 673, 745
     objects 824                    precedents in Calc 587, 714         paths, adding for file
   curving text along shape 820     Presentation menu 669                 selection 648
   typing text inside 684           presentations 673                   printing
pooling connections 892, 905           adding fields like page and           only presentation 746
popart filter 841                        title 699                           procedure 746
pop-up tips 97                         adding more paths for file            paper size 742
portrait 234, 673                        selection 648
                                                                                           Index      1005



       printing takes too long 701,       converting 5.2 printers           fax, entering 493
          744                             creating new UNIX printer 55      files instead of printer,
   printing more than one slide per       default printer, setting 62         options 78
     page 742                             DocuTech setup 92                 fitting a page onto one sheet of
   printing multiple slides per           DPI setup 62                        paper 86
     page 727                             duplex 61                         fitting slide on one page
   printing options 745                   duplex UNIX printer 57              (Draw) 846
   quitting with interaction              duplex, turning off 59            fitting slide on one page
     effect 719                           input slot 61                       (Impress) 743
   reducing file size 701                 margin setup 61                   graphics and related
   rehearsing timing 729                  paper size and orientation 61       settings 87
   running 721                            PostScript drivers 77             hidden
       beginning and ending 731           PostScript level setup 62              slides 745, 848
       editing while 732                  resolution setup 62                    subpoints 678
       in automatic loop 730              scale setup 61                    hiding cells (Calc) 546
                                          selecting (Draw) 849              HTML notes 461
       options 730
                                          selecting (Impress) 746           layers, preventing 661
       switching between 731              selecting (Web) 426, 492          left only or right only 86
       using Navigator 731                selecting when printing 76        mail merge from
   setup before you begin 647             setup for all platforms 75          spreadsheet 625
   speakers’ notes 726                    setup options 75                  margin warning setup 94
   stretching slide to fill page 743      setup, UNIX 54                    margins 84
   styles 693                             spadmin location 54               margins, printing throughout
   templates 649-650                      trays (Writer) 234                  StarOffice 84
   text options setup 679                 UNIX                              memory used for graphics 119
   title, specifying 646                      fonts, adding 71              more than one page on a
   troubleshooting 647                        general font                    sheet 85
   tutorial 636                                 substitution 74, 82         more than one page on a sheet
   work area 635                                                              (Writer) 428
                                              name, changing 62
preventing cells from                                                       more than one slide per page
   printing 629                               per-printer substitution 72
                                              PostScript level 60             (Draw) 742, 846
Preview field                                                               most recent print field 863
   bitmaps, creating and                      removing 62
                                                                            multiple pages per sheet,
     modifying 807                        UNIX, printing right now 54
                                                                              printing throughout
   connectors 797                      printing
                                                                              StarOffice 85
   dimension lines 795                    aligning printout to page
                                                                            multiple slides per page 727
   hatches, creating and                    area 547
                                                                            not printing dark drawing
     modifying 806                        backwards 86
                                                                              backgrounds 848
   lines 769                              brochures 88
                                                                            not printing dark presentation
print jobs, single 493                    brochures and duplex printers
                                                                              backgrounds 848
Print Layout On/Off 467                     90
                                                                            notes (Calc) 628
Print Options window                      collating 76
                                                                            notes (Writer) 427
   orientation effects 83                 collating (Draw) 849
                                                                            notes in documents 424
   overview 83                            collating (Impress) 746
                                                                            nothing comes out 849
   Writer 427                             collating (Web) 426, 492
                                                                            number of pages to print
Print window 76                           colors 93
                                                                              spreadsheet on 630
Printable option for layers 659           column letters (Calc) 628
                                                                            options, setting up 76
Printer Installation window 56            commercial color setup 93
                                                                            page flow of sheets 549
Printer Properties window                 copies, number of 76
                                                                            Page Format window
   orientation effects 84                 dark backgrounds, not
                                                                              (Draw) 847
   overview 84                              printing 744
                                                                            Page Format window
   setup 61                               DocuTech setup 92
                                                                              (Impress) 743
printers                                  drawings 848-849
                                                                            page layout 83
   color and color depth 62               duplex 59
1006     Index



  PostScript 78                         to files (Impress) 746              spaces, displaying or hiding in
  PostScript or PDF 77                  to files (Web) 426, 492               HTML documents 435
  Postscript printer driver for         toner, saving 744                   text from modification 197
    Windows 77                          troubleshooting                     Writer table cells 286
  presentations                             documents not opening or     proxies
      hidden pages 745                        printing 55                   finding out what they are 136
      options 745                           paper format 76, 79, 756,       setting ports 135
      printing takes too long 701,            849                           setting up 135
        744                                 paper size 742               pyramids, creating 808
      procedure 746                     troubleshooting,
      specifying what to print 746        presentations 742
  preventing cells from 629             UNIX and PDF 79                  Q
  print layout, using in HTML           warning dialogs 93
    documents 467                       Web 492-493                      Quality option for printing
  print range (Calc) 628                Windows PDF 79                      options (Draw) 848
  procedures (Calc) 624                 Writer 426                       queries
  procedures (Draw) 849              printing options                       composition window 916
  procedures (Impress)                  Calc 624                            data sources 914
    presentations                       Draw 848                            in mail merges 362
      printing procedures 742           drawings 848                        running for data source 916
  procedures (Writer) 427               page (Calc) 547                     searching databases 951
  quick 75                              presentations 745                   writing with SQL code 915
  quickly with print icon               sheet (Calc) 547                 quick printing 75
    (Draw) 849                          Web                              Quick Start
  quickly with print icon                   setting 493                     Calc 498
    (Impress) 742                       Writer 427                          checklist (Calc) 498
  quickly with print icon            problems, see troubleshooting          checklist (Draw) 750
    (Web) 426, 492                   programmers’ manual 10                 checklist (Impress) 634
  range 76                           promoting                              checklist (Writer) 168
  range (Draw) 849                      bulleted items 676                  checklist, Web 442
  range (Impress) 746                   bulleted items (Impress) 686        Draw 750
  range (Web) 426, 492                  bulleted items to heading 677       Impress 634
  repeated headings (Calc) 626          formatting icon (Impress) 686       Web 442
  reversed order 86                     icon 676                         quick sum 563, 564
  reversing order (Writer) 427       properties                          quote marks
  row numbers (Calc) 628                documents, viewing and              changing automatically 126
  selected sheets only 15                 setting 447                       smart or straight 188
  selecting sheets to print 625         file, setting 467                   substituting other
  selection only 76                     see also document properties,         characters 188
  setup options 75                        fields
  shrinking spreadsheets to          proportional table setup
    fit 630                             window 279, 454
  specific spreadsheet               protecting                          R
    elements 628                        cell contents 286
  spreadsheet formulas 628              cell contents (Writer) 286       radio buttons
  spreadsheet grid 628                  cells 546                           adding to drawings 815
  stretching slide to fill a page       cells from modification 602         adding to presentations 699
    (Draw) 847                          editing changes 422                 examples 927
  stretching slide to fill a page       Protect option                      properties window 947
    (Impress) 743                           positioning objects 776         see also controls
  text black 493                            resizing objects 778         RAM required 22
  things that control (Calc) 624        section contents 413             ranges
  to files (Draw) 849                   sections, write-protecting 409      cells 561
                                                                                           Index      1007



   Draw document 849                     cells, tips 568                    numbers and bullets 259
   presentation 746                      cross-references 331               printers in UNIX 62
   printing 76                           insert reference field 862         program (uninstalling) 40
   running presentation 730              lists of books in document         rows and columns 537
   sums 564                              set reference field 861            rows and columns (hiding)
   Web document 426, 492             refreshing                               Calc 537
rasters                                  bibliographies 356                 scenarios 608
   adding to drawings 815                chart data 597                     sheets 523
   applying color modes to               drink, see refrigerator            sort lists 534
     (Draw) 838                          indexes 349                        styles 261
   converting to another raster          links in spreadsheets 522          styles (Calc) 557
     type 785                            links to objects in                tables of contents 342
   converting to Draw object               spreadsheets 599                 templates and categories 270
     (vector) 824, 827                   master documents 329            renaming
   cropping 836                          spreadsheet calculations 571       data source tables 911
   inserting in presentation 697         tables of contents 342             layers 661
   saving presentation as 733        regenerating                           macro module 970
   scaling well 787                      indexes 349                        sheets 522
read-only access, making files           tables of contents 342             slides 669
   editable 450                      Reggie the Pool Boy 327             reordering
rearranging slides 669               register true 211                      sheets 523
recalculating spreadsheets 508       registered trademark 189               sort lists 534
recent documents, setting            registration 42                        see also rearranging
   number that can be                regular expressions in search       repeating headings and columns
   opened 145                            and replace 525                    626
recorder for macros in future        rehearsing presentation             replacing
   release 960                           timing 729                         search and replace 524
recording changes (Calc) 618         rejecting document changes             styles 265
records                                  (Writer) 420, 621                  text automatically 121
   adding to data source using       relative                            resizing
     forms 955                           cell references 568                columns (Calc) 536
   any record field 865                  cell references, applying 509      graphics (Writer) 276
   modifying using forms 924             paths 471                          objects 777
   new using forms 924                   URLs 138                           objects (Writer) 305
   next record field 865             relative width of tables               objects, using mouse 777
   problems entering longer field        (Writer) 285                       objects, using Position and Size
     value 957                       relief filter, example 840               window 777
   record number field 865           Remove blank paragraphs                rows 536
   searching for in data                 option 126                         rows and columns in
     sources 951                     remove noise filter 843                  tables 456
rectangles 762                       Remove unused background               sheet area 523
   conversion options 824                pages 696, 697                     table columns (object bar) 282
   drawing (Draw) 762                Remove unused master pages             tables, overall dimensions 456
   rounding corners of                   702                             resolution
     existing 762                    removing                               color images 832
   typing text inside 684                columns, rows, and tables          converted presentation 735,
red                                        (Writer) 288                       741
   color, creating or                    empty merge fields 403             printer setup 62
     modifying 803                       formatting 463                  restarting
   modifying for graphic with            headers and footers 232            lists at 1 226
     object bar 832                      lines from headers and             numbering 214, 219
references                                 footers 229                      outline numbering at one 317
   cell, absolute and relative 568       lines from page borders 235        page numbering 325
   cell, tracing 614                     lines from paragraphs 216
1008      Index



Return key, changing behavior           changing units on 170              scale
   in spreadsheets 535                  resizing 180                          images 787
return, soft 175                        setting unit of measurement           printer setup 61
reusing content, sections 409             (Image) 784                         setting (Draw) 784, 796
reverse                                 setting unit of measurement        scanning 303
   calculations with goal                 (Impress, Draw) 663              scenarios
     seek 609                           vertical (Writer) 179                 creating 606
   calculations with                    Writer 170                            deleting 608
     scenarios 605                   running                                  modifying 607
reversing print order 86, 427           macros 971-973                        spreadsheets 605
reverting to prior document             presentations, custom 723          Schedule files from 5.2,
   versions 409                         presentations and editing 732         exporting 49
RGB                                  running heads 320                     scripts
   changing to CMYK 803                                                       adding to document 487
   selecting 93                                                               editing 488
right pages only, printing 86                                                 Insert Script window 488
right pages, setting 234
                                     S                                        linking to 487
right-click menus 108                                                         printing 488
right-justifying text                SadisTech 613                            showing and hiding
   (Impress) 686                     sampling, see Eyedropper                   indicators 487
RoboHelp 410                         Sascha Gates 170                         WebCast options 741
rolling 552                          saturation                               where to insert code 488
rotating                                modifying 803, 832                 scrolling
   3D charts 596                        modifying for 3D object 812           marquee options 483
   3D objects 808                    Save As window 158                       nonscrolling regions
   handles for 3D object             Save button (Configuration                 (Calc) 552
     rotation 809                       window) 104                           vertically and horizontally in
   objects manually 782              saving                                     Calc window split 553
   objects using Position and Size      as StarMath formula 302            searching
     window 783                         at specified interval 156             concordance terms 347
   text in cells 544                    default directory for saving and      databases 951
Roth, Werner (Web site) 39                opening 132                         for document elements 313
rows                                    in 5.2 51                             for index markers 349
   breaks, manual 551                   in 5.2 format 163                     Internet 439
   changing height (Writer) 289         in Microsoft format 163               Internet from within
   deleting 537                         outline numbering                       program 136
   deleting (Writer) 288                  versions 318                        Japanese search options 110
   expanding and contracting in         records in data sources 924           search and replace 524
     Calc 610                           selecting type of dialog           sections
   hiding (Calc) 537                      box 131                             adding text before 197
   in tables, resizing 456              spreadsheet as 5.2 or                 backgrounds 412
   inserting (Calc) 537                   Excel 518                           columns 412
   printing repeated headings 626       spreadsheet as HTML 519               conditional 415
   resizing (Calc) 536                  spreadsheet as text file 519          creating 411
   selecting entire (Calc) 535          to other formats (Writer) 178         creating (Writer) 409
   sorting (Calc) 575                   versions of a document 407            creating in spreadsheets 611
   spreadsheet rows for data            versions of a document                DDE links 417
     source 517                           (Calc) 618                          deleting 417
   unfreezing 553                       versions of a document                formatting 411
   unhiding 537                           (Writer) 406                        hiding 409
Ruby text                               whether printing means a              linking to section in other
   setup 112                              change to document 93                 document 416
   using 190                            Writer documents as                   modifying 417
ruler                                     HTML 179                            protecting 409
                                                                                             Index     1009



    protecting contents 413             graphics print settings 87         showing
    section breaks 212                  grid 778                               changes to cells 618
    using (Writer) 409                  HTML backgrounds 434                   grid (Writer) 306
security                                memory used for graphics 119           hidden rows and columns 537
    macros 150                          presentations 647                      note markers (Writer) 424
    OLE 150                             print options 75                       notes in documents 424
    password-protecting                 printing margins 84                    objects (Impress, Draw) 664
      documents 158                     security 149                           slides 677
    protecting text from                source text options for            shrinking spreadsheets to fit
      modification 197                    HTML 435                             printed page 630
    proxy, setting up for 135           table options, HTML                signatures
    setting up for documents 149          documents 279, 453                   creating and inserting 180, 866
see-through, see invisible,             text options (Impress) 679             moving to different
    transparency                        tips and tricks 95                       categories 183, 869
segments of circle, drawing 762      shading                               similarity search 525
selecting                               tables, predefined 455             single spaces, enforcing 125
    all cells in sheet 535              turning off 217                    Single Step icon 974
    all of document 175              shadows                               single-source
    chart parts 593                     applying to objects using Area         documentation 410
    custom presentation slides 723        window (Draw) 766                single-user installation 29
    drawing part to print 76            applying to objects using object   size
    entire data area (Calc) 524           bar (Draw) 763                       display size (Impress,
    entire rows and columns 535         modifying for 3D object 811              Draw) 663
    non-adjacent cells (Calc) 535       on page borders 235                    of text frames and text 683
    nonconsecutive text                 on paragraph borders 216               reduced-size slides,
      blocks 185                     sheeps’ bladders 754                        printing 727
selection lists 532                  sheets                                    Size fields
Semiautomatic transition 721            about 521                          Slide Design window 702
send as email program 143               adding 521                         slide layouts
Send AutoAbstract to                    creating a master sheet 583            selecting for correct
    Presentation feature 642            deleting 523                             formatting 685
Send Backward option 777                direction of page flow 549             selecting for slide 672, 673
Send Mail window 521                    password protection 602                see also backgrounds
Send Outline to Presentation            printing 625                       slide shows, see presentations
    feature 641                         printing only selected 15          slide transitions
Send to Back option 777                 printing options 547                   applying 720
sending                                 protecting 602                         automatic or manual 721
    documents as Email 143, 179         renaming 522                           manual, switching to 730
    spreadsheet as email 520            reordering 523                         presentation conversion
Sequence Options window 308             selecting all cells in 535               issues 733
servers                                 selecting non-adjacent cells       slide view
    files installed 31                    (Calc) 535                           illustration 655
    installation 31                  shortcut keys                             overview 655, 657
    proxy server names, how to          assigning 104-105                      rearranging slides in 670
      enter 136                         assigning to macro 972             slides
Set in Circle 817                       Calc 508                               backgrounds, see backgrounds
set variable field 864                  macro, assigning to 972                columns, using 685
settings.xml 147                        Writer 175                             converting to HTML 733
setup                                show                                      converting to PowerPoint 732
    3D display options 118              Show Grid icon 780                     converting to raster 733
    Basic 966                           Show Snap Lines icon 780               copying from any document
    commercial colors for               show sublevels 317                         slide view 676
      printing 93                       show sublevels field 317               copying from same document
    duplex printers 59                  show variable field 864                    drawing view 676
1010      Index



   deleting 669                          illustration of features 773          between bullets and text 224
   effects, applying to entire           page margins and objects,             between numbers and text 224
     slide 720                             snapping to 781                     between paragraphs 211
   going to specified 718                snap points and lines,                formatting icon (Impress) 686
   headers and footers 706                 creating 780                        inside cells 544
   hiding 677                            grid setup 779                        spreadsheet headers and
   inserting 674-675                  soft return 175                            footers 550
   inserting and selecting            Solaris                                  text (Draw) 771
     layout 672                          installation notes 23                 text width 206
   inserting from another file 674       system requirements 22             Spacing field
   inserting Image graphics 697          see also UNIX                         hatches, creating and
   inserting new empty 671            solarization filter example 842            modifying 806
   inserting quickly 671              Sort List Options window                 line styles 791
   making slide for each bulleted        (Calc) 533                         spadmin 54
     item 677                         sorting 575                           speakers’ notes
   margins 673                           copying results to other sheets       adding to presentation 726
   moving among using                      (Calc) 575                          printing only 746
     Navigator 668                       data sources 917                   spearmint euphoria gum 171
   name 745                              data sources using forms 951       special characters
   naming 672, 673                       horizontally 575                      creating automatically 121
   orientation (Impress) 745             including headings 575                inserting 189
   printing                              sort lists 532-534                    inserting in formulas 302
       troubleshooting 746               spreadsheets 574                   special effects
   printing (Draw) 849                   see also collating                    enabling (Impress) 710
   printing (Impress) 746             sounds                                   Impress 710
   printing hidden 848                   applying to text and                  see also effects
   printing more than one per page         objects 713, 716                 Special styles category,
     (Draw) 846                          converted presentation 735,           Writer 250
   printing more than one per page         741                              speed of display, increasing 664
     (Impress) 742, 743                  dragging Gallery items to          spell check
   printing multiple on a page             documents 116                       adding dictionaries 193
   printing options (Impress) 745        effects, applying to objects 712      automatic 191
   rearranging 669                       interaction effects 719               customizing 192
   renaming 669                          playing (Impress) 719                 options 191
   running, and switching                presentation conversion               troubleshooting 194
     between 731                           issues 733                       Split Curve icon 801
   selecting correct layout 685          slide transitions 720              splitting
   showing 677                           using Gallery 115                     table cells (Writer) 282, 289
   slide view 657                     sounds like search 525                   tables 455
   stretching to fill a page          source                                   window (Calc) 553
     (Draw) 847                          HTML, color setup 435              spreadsheets
   stretching to fill a page             HTML source in Web 450                about sheets 521
     (Impress) 743                       HTML, editing 461                     adding
   summary slide, creating 678           nested tables 458                         charts 590
   text, adding 683                      Edit Links window 465                     comments to changes 619
   text, adding to 679                spaces                                       controls to 598
   text-creation icons 680               displaying or hiding in HTML              graphics and drawings 598
   transitions, see transitions 710        documents 435                           help tips to 605
Smalls, Derek 532                        enforcing single 125
                                                                                   math formulas as
smart quotes 126, 188                    nonbreaking 175
                                      spacing                                        objects 599
smooth filter 842, 843
Smooth Transition icon 801               around objects (Writer) 304               sheets 521
snap                                     Asian typography 112                      to drawings 814
   grid snap setup 779                   between borders and page 235               o presentations 695
                                                                                    Index      1011



    to Writer 291                 moving within using 523              templates 509, 558
advanced techniques 583           naming areas 611                     tips for using 586
applying themes 558               navigating through sheets 523        troubleshooting 587
AutoFilter 576                    new, creating 509                    updating calculations 571
AutoFormat 538                    nonscrolling regions 552             updating links 522
automatic totals 564              number of pages to print             updating links to objects 599
backgrounds 548                     spreadsheet on 630                 using styles 554
borders, colors,                  opening 511                          viewing page breaks 551
  backgrounds 538                 opening data sources with Data       work area 499
bringing data source into           Pilot 515                      SQL
  manually 517                    opening HTML table in 511            and controls 927
calculations in tables 295        operators 560                        data source queries 914
calculations overview 560         outlining 610                        query composition
cell styles 556                   overview of using as data              window 916
changes, showing 618                source 879                         query writing with SQL
color-coding parts 588, 615       page layout 547                        code 915
colors for change                 page numbering 550                   running data source query 916
  recording 618                   page styles 557                      statements for data
consolidation feature 585         paste special 580                      sources 912
converting to Writer tables 294   print ranges 628                     syntax for queries 915
correct file format for text      printing mail merges from 625        troubleshooting 899
  file 514                        printing only selected           squares
data source from 884                sheets 15                          aligning text to specific
DDE link in Writer (Windows       printing specific elements 628         shape 820
  only) 294                       printing, things that                conversion options 824
deleting area names 613             control 624                        drawing (Draw) 762
deleting from document            protecting cells 602                 rounding corners of
  (Writer) 294                    Quick Start 498                        existing 762
deleting sheets 523               quick totals 563                     typing text inside 684
double-checking totals 572        recalculating 508                St. Hubbins, David 532
editing in Writer 293             renaming sheets 522              Standard Filter window 578
Enter key 535                     reordering sheets 523            standard installation 27
entering formulas                 rows and columns from data       Standard option
  manually 563                      sources 517                        printing options (Draw) 848
features 498                      saving as Excel or 5.2 518           printing options (Impress) 745
filtering data 576                saving as HTML 519               standard template 263
formatting with                   saving as text file 519          StarOffice
  AutoFormat 538                  scenarios 605 - 608                  beta, uninstalling first 44
formula basics 560                selecting non-adjacent cells         books 21
function AutoPilot                  (Calc) 535                         converting 5.2 documents 50,
functions 563                     sending as email 520                   161
goal seek 609                     setting change options 618           migrating 5.2 databases 902
headers and footers 549           setup options 507                    saving automatically in 5.2
HTML, saving as 448               sheets to print 625                    format 163
importing HTML tables 15,         showing changes 618                  saving spreadsheets in 5.2 518
  511                             showing more sheets 523              StarOffice52.dt file, changing
importing text files 513          shrinking to fit printed               HTML icons back 153
inserted blank OLE object,          page 630                           see also OpenOffice.org
  example 482                     sorting 574                      Start inside option 483
inserted OLE spreadsheet,         splitting window 553             statistics field 861
  example 481                     standard filtering 578           STD (Writer task bar) 185
inserting notes 622               starting 499                     stencils, creating in Draw 761
linking between files 585         styles, why useful 554           straddling cells 289
margins 547                       subtotals in 564                 straight quotes 188
1012      Index



straightening                          modifying using drag &              in spreadsheets 564
   lines 767                             drop 261                          incorrect 587
   see also grid                       next page 258                       quick 563
style catalog 249                      next paragraph 252                  ranges 564
style lists 792-793, 803-804           numbering 248                       Subtotals window 565, 566
styles                                 numbering and bullet 256         subtracting
   about (Writer) 247                  overwriting 265                     objects 830
   applying 259                        page (Calc) 557                     objects, example 828
   applying (Calc) 557                 page (Writer) 248, 257              formulas 561
   applying (Impress) 693              page styles in master            sums
   applying automatically 126            documents 329                     automatic 564
   applying graphics styles using      page, changing flow 259             checking 572
     object bar (Draw) 763             paragraph 248, 251                  incorrect 587
   applying to an object               paragraph, applying 259             quick 563
     (Draw) 758                        reasons for using in Calc 554       ranges 564
   bulleted items, demoting and        removing formatting 463             sum icon, table object bar 282
     promoting (Impress) 687           reusing in another document      suppressing
   Calc 554                              (Draw) 760                        cell printing 629
   cell 556                            reverting to default 126            see also blanks
   changing categories of 261          searching for 525                sversion.ini 35, 37
   changing default fonts              setting fallback styles 252      sversionrc 35, 37
     (Impress) 692                     sharing between                  SVG 787
   changing for all new                  documents 265                  swallows, airspeed of laden 754
     presentations 695                 style catalog 556                symbols, inserting 189
   character 248                       style lists, defined 792         Symmetric Transition icon 801
   character styles 254                Stylist (Calc) 555               Synchronize axes option 779
   character, applying 259             Stylist (Writer) 249             Synchronize ends option 769
   color themes in Calc 558            tips for using 249               syntax
   conditional paragraph styles        updating 266                        ADO 898
     252                               updating automatically 252          JDBC 896
   creating (Writer) 251, 254-258      updating in master                  see also data sources, macros,
   creating and modifying                documents 330                       formulas
     (Draw) 758                        updating paragraph 261           system requirements 22
   creating caption numbering          using (Calc) 557
     paragraphs 309                    using in drawings 758
   default font, changing 447          using number with
   deleting 261                          paragraph 257
                                                                        T
   deleting (Calc) 557                 Writer 247
   formatting with (Writer) 247     styles.xml 147                      Table Format window 284
   frame 248, 258                   Stylist                             table object bar
   frame, applying 259                 Calc 500, 555                       borders and background
   how they work (Writer) 249          icons (Writer) 249                    color 282
   HTML 451-453                        opening and closing 175             column/table resizing 282
   icons in Stylist (Writer) 249    sublevels, showing 317                 inserting/deleting rows/
   Impress 693                      subpoints                                columns 282
   lines and arrows, creating and      hiding 678                          merge and split cells 282
     modifying 791                     hiding, example 679                 sum icon 282
   making available for other          Subpoints per level option 644      switching to text object bar
     documents (Impress) 694           see also bullets                      (Writer) 282
   making available to other        subtotals                           table of figures 350, 352
     documents 247, 251                automatic 564                    tables
   modifying 260                       Data Pilot and data                 adding data to new data source
   modifying (Calc) 557                  sources 515                         tables 913
   modifying (Impress) 693             double-checking (Calc) 572          adding text before 197
                                                                                       Index      1013



AutoFormat 278                      number format options 455            removing 342
automatic 125                       object bar icons,                    selecting headings to use 337
borders and background color          illustration 454                   setting up 333
  (Writer) 282                      object bar tools (Writer) 281        structure 338
breaking to a new page 284          options in Insert Table              tables of other items 350
caption numbering 308                 window 455                         tables of other items in master
cells 286-287                       page breaks 283                        documents 352
column width 288                    post-creation formatting 287         updating 342
converting data sources to          protecting cell contents          tabs
  Writer, RTF, and HTML 920           (Writer) 286                       default settings 209
create, drop, grant 912             Relative option grayed out 456       leader dots 214
creating from spreadsheets 294      relative width (Writer) 285          setting 209
creating in data sources 906        resizing (Writer) 285                setting on paragraphs 214
creating with keyboard 125          resizing columns (Writer) 285        specifying how multiple tabs
data source tables 911-912,         resizing overall                       look in windows 107
  951                                 dimensions 456                     styles on ruler 209
default format (Writer) 279         resizing rows and columns 456        tab key using in outlining 218
defining fields for data            row height, changing                 tab order in forms 936
  sources 909                         (Writer) 289                       troubleshooting in slides
deleting 282, 288                   setup for HTML 279, 453                (Impress) 681, 685
displaying or hiding in HTML        splitting or not 455              tags unrecognized in HTML 142
  documents 435                     spreadsheet calculations in 295   target frame 272
entering name that appears in       table controls in forms 931       targets in HTML 472-473
  Navigator 455                     troubleshooting 286               tearoff menus 761
formats, using predefined 455       variable-width 456                Template Management
formatting (Writer) 277, 283        vertical alignment in cells          window 267
formatting data source as 382         (Writer) 289                    templates
formulas, using in 296              Writer 277                           adding to OpenOffice.org 16,
formatting icons 456             tables of contents                        164
header, specifying options 455      adding special items 333             AutoPilot 446
heading, repeating                  advanced options 337                 backgrounds 650
  (Writer) 279, 282                 codes 336                            Calc 558
HTML,                               contents slide, creating 678         changing font styles for new
    inserting new 455               creating 332                           presentations 695
    opening in Calc 511             editing 339, 341                     changing fonts in standard
HTML, importing into                fixing document after                  template (Writer) 263
  spreadsheet 15, 511                 insertion 341                      converting from Microsoft
icons on object bar 100             fixing page flow 341                   Office 161
index for data source               formatting 339                       creating 649-650
  tables 910                        heading levels 335                   creating (Draw) 758
index of tables 352                 HTML file, creating in 472           creating (Writer) 267
inserting captions 306              hyperlinking entries to source       creating and modifying,
inserting columns (Writer) 282        files 338                            procedures 648
inserting rows (Writer) 282         index of tables 352                  creating categories 269
joining two (Writer) 279            inserting 334                        creating document based on
merging and splitting cells         inserting content before 341           (Calc) 509
  (object bar) 282                  inserting in master                  creating document from
merging and splitting cells           documents 335                        (Writer) 176, 262
  (Writer) 289                      inserting space before 341           default fonts, changing 447
Name field value, where             leader dots 214                      default template 263-264
  displayed 455                     making read-only 335                 deleting 270
nested (Web) 456                    marking special entries 333          deleting categories 270
nested (Writer) 280                 quickly inserting 332                document template field 861
                                    regenerating 342                     HTML 446-447, 451-452
1014      Index



   importing and exporting 268      editing mode, entering                 vertical, Writer 244, 274
   importing from Microsoft           (Impress) 684                        vertical (Draw) 770
     Office 269                     entering in cells 528                  vertical, enabling 109
   included in this book 10, 164,   flow between frames 241                wider than cells 528
     176, 262                       formatting (Impress,                   width 206
   installing 16, 164                 Draw) 685                            wrapping in cells (Calc) 528
   legal, opening in                formatting in HTML                     wrapping text in text
     OpenOffice.org 411               documents 462                          frame 681
   making them show up in           formatting using object bar         Text CSV file format (Calc) 519
     selection windows 648            (Draw) 771                        text boxes, inserting
   modifying 268                    formatting window                      (Writer) 239
       background 650                 (Impress) 688, 771                text documents
       standard 649                 formatting with gradients,             adding frames 239, 297
   moving to different                bitmaps, hatches 772                 adding math formulas 300
     categories 270                 getting right formatting icons in      adding other documents 302
   naming 649-650                     object bar 456                       comparing 419
   organizing 269                   handouts, adding to 728                creating based on template 176
   sharing styles between 265       hidden text field 863                  editing notes 424
   standard 263 - 264               hiding (Draw and Image) 664            inserting AutoText 184, 870
   standard, modifying              HTML formatting                        inserting notes 423
     (Writer) 264                     example 462                          new, creating 175
   StarOffice 5.2 templates,        icons for creating in slides 680       printing notes 424
     obtaining 10, 176, 262         icons for formatting                   sending as Email 179
   styles, making available in        (Impress) 686                     text files
     other documents                indenting (Impress) 686                adding to drawings 815
     (Impress) 694                  in-line text 112                       adding to presentations 696
   switching (Writer) 263           inserting text-based file 479          creating data source from,
   that a document is based         keeping exact in cells 529               overview 879
     on 447                         margin around text frames 691          data source, creating 882
   using (Writer) 262               modifying text link                    data source, tutorial for
   Web 452                            quickly 478                            creating from 874
   where program looks for          moving on specified path               HTML, opening in 448
     them 178                         (Impress) 714                        importing into Calc 513
text                                new text frame, adding                 opening in spreadsheet,
   adding before table or             (Impress) 680                          example 514
     section 197                    no wrapping in text frame 682          presentation basis 639
   adding to slides 683             numbering 688-689                      saving in HTML format 448
   advanced effects 817             option setup 679                       saving spreadsheets as 519
   animated, see marquees           placeholders 664                       selecting correct format for
   Asian formatting 111             printing black (Web) 493                 opening in spreadsheet 514
   background color 206             protecting from                     text flow
   bullets 688-689                    modification 197                     applying and switching page
   callouts, creating 682           putting a box around 215, 235            styles for 259
   centering and justification      selecting nonconsecutive 185           see also page layout, columns
     (Impress) 686                  selecting with director cursor      text frames
   character styles 255               185                                  adding to slide 680
   connecting lines to text         slides, adding to 679                  borders, setting 683
     frames 799                     styles (Impress) 693                   connecting lines to 799
   converting to 3D 821             text and text frame options            creating with specific size 681
   default fonts, changing            (Impress) 683                        margin around 691
     (Impress) 692                  text field types 909                   options (Impress) 683
   diagonal 244                     troubleshooting (Impress) 681,         setup options 683
   drawings, using in 769, 772        685                                  sizing font size to text
                                    typing inside object 684                 frame 682
                                                                                           Index      1015



    typing in (Writer) 241                removing icons 99                 can’t cross-reference numbered
    Writer 240                            repeating tasks 99                  paragraphs 314
Text icon (Impress) 680, 681              setup 98                          can’t delete styles 261
Text styles category, Writer 250          tearoff menus 761                 can’t find icon 711, 715
textures 813                              Writer 170                        can’t format text in table using
themes in Calc 558                     tooltips 97, 605                       object bar (Writer) 282
thousands separator 287, 543           top ten reasons to use               can’t import certain file
three-dimensional, see 3D                 program 4                           formats 28
TIF description 787                    totals                               can’t select graphic in
tile 85                                   automatic 564                       paragraph 216
    bitmaps 765                           Data Pilot and data               cells don’t print 629
    printing options (Draw) 848             sources 515                     cells, can’t format 539
    printing options (Impress) 745        double-checking (Calc) 572        cells, can’t see all text 528
    converting raster to                  incorrect 587                     cells, formulas are lost when
      polygon 827                         quick 563                           cells are merged 542
time                                      ranges 564                        cells, leading zeroes are
    adding to drawings 757             tracing                                removed 529
    adding to HTML note 460               example 614                       cells, numbers become
    adding to presentations 699           precedents and dependents in        ### 529
    editing time field 863                  spreadsheets 587, 614           cells, pasted text is put into
    field 861                          trademark 180, 189, 866                separate cells 530
    for WebCast presentation 740       transitions, see slide transitions   cells, text that you type is
    handouts, adding to 728            transparency 766                       changed 529
    presentation timing 729               applying to objects using Area    charts and memories 290, 590
    printing                                window 767                      color, can’t remove from
         drawings 848                     background color for                paragraph 216
         presentations 745                  effect 719                      commonly experienced
    printing options (Draw) 848           backgrounds 704                     problems 37
    standing still 861                    changing in image 834             data entry 957
tips                                      chart fills 593                   data source table field
    filling across rows 570               charts 594                          length 914
    filling down columns 570              effects, applying to              data source tips 877
    fitting more of a spreadsheet on        objects 713, 716                data sources 399, 892, 893,
      a page 551                          mode, for object 767                896
    for building formulas 562             print settings 87                 databases 896
    for using styles 249                  replacing a color with 834        deleting indexes 349
    for using styles (Calc) 556           Transparency for animated GIF     delimited text file opens read-
    help menu 97                            window 720                        only 519
    troubleshooting indexes 349           Transparency gradient             displaying hyperlink bar 436
    Writer 179                              option 767                      documents not opening or
titles                                 trays (printer), selecting 234         printing 55
    chart, entering 590-592            Trim option 94, 848                  easiest data source 882
    naming document 646                troubleshooting                      Excel macros 960
    templates 649, 650                    backgrounds 703                   fields, dragging into
    title field 864                       backgrounds converted to            document 378
TOC, see tables of contents                 HTML 700                        file not editable 450
toolbar 99                                bitmaps 87                        finding files after crash 133
    adding icons 99                       broken links 140                  formatting text correctly
    Calc 500                              bullets and numbering primary       (Impress) 685
    drawing multiple objects                control window 221              formatting, removing 463
      without reselecting 762             bullets not showing up 688        forms, can’t use or edit 934
    floating tool windows 99              Calc page numbering               frames, typing in (Writer) 241
    icons, changing 761                     issues 551                      Gallery, can’t add or delete
                                                                              items 116
1016     Index



  getting rid of empty pages 196     permission denied message,                    errors 587, 614
  getting right icons in object        Linux install 23                          tracing precedents, depen-
    bar 456                          pop-up tips not working 97                    dents, and errors 587
  gradients 87                       PostScript setup 78                     starting OpenOffice.org 37
  graphics print settings 87         PowerPoint 647                          styles, can’t delete 557
  graphics printing 87               presentations                           styles, making available in
  grid, can’t see 436                    features not available 647            other documents 247, 251
  grid, doesn’t appear 436           presentations, printing 742             tab in slides (Impress) 681,
  Help Agent, turning off 129        print warning dialogs 93                  685
  hidden menu items 101              printing                                tables
  HTML document not displayed            nothing comes out 849                   adding content before 197
    according to Page Format             paper format 76, 79, 756,               breaks to a new page
    options 467                            849                                     (Writer) 284
  HTML interchangeability 462            paper size 742
  hyperlink formatting 124                                                       can’t make width of page
                                         presentations taking too                  (Writer) 284
  icons, seeing all available 99
  indexes 349                              long 701, 744                         disappears at bottom of
  inserting space before tables of   printing graphics 87                          page (Writer) 278
    contents 341                     printing issues 624                         variable-width 456
  installation 37                    reinstalling 35                         templates
  installation notes 23              removing lines from headers                 can’t find in the New
  linked objects/graphics 696          and footers 229
                                                                                   window 510
  macros 152, 960, 975               removing lines from page
                                       borders 235                               can’t see preview of one I
  mail merge printing 403                                                          created 177
  mail merge, dragging fields        removing lines from
                                       paragraphs 216                        text in slides (Impress) 681,
    in 378
                                     repairing damage 40                       685
  mail merges 399
                                     repeating headings or columns           Tile feature 745
  mail merges, blank line 404
                                       in Calc 626                           tips and tricks 95
  mail merges, empty space 403
                                     right-clicking to find more             transparency 87
  MS and HTML files opening
                                       options 108                           viewing hidden icons 100, 101
    by default in StarOffice 29,
                                     running head won’t show                 word completion 127, 130
    152
                                       heading 315                        tutorial
  multi-user installation 32
                                     setting up proxies 135                  Calc 500
  object bar icons 100
                                     skipped page numbers                    data sources, getting
  ODBC 892
                                       (Writer) 258                            started 872
  online information 39
                                     slides/layers not printing 746          Draw 753
  only selected object
                                     spellcheck crash 194                    HTML editor 444
    printing 746
                                     spreadsheets                            Impress 636
  opening corrupt
                                         .5 changes to 1/2 530               macros 962
    documents 159
                                         calculated amounts are              Writer 170
  opening text files in
                                           incorrect 587                  Type field
    spreadsheets 514
                                                                             connectors 797
  outlining 223                          cell-protection
                                                                             Edit Links window 465
  page layout issues 624                   password 603                      gradients 805
  page setup, Draw 756, 757              fill results are                    line styles 791
  page zero (Writer) 258                   inaccurate 532                    transparency gradient 767
  paper format 76, 79, 756, 849          formulas in cells 587            typos
  paragraph breaks to next page
                                         inserted into Writer won’t          correcting automatically 121
    (Writer) 213
                                           fit 292                           underlining 191
  paragraph modifications won’t
                                         sheet not in list of links 522      see also spellcheck
    take 253
  paragraph style changes 253            tips 586
  PDF setup 68                           tracing precedents and
                                                                                       Index      1017




U                                     charts (Writer) 290
                                      indexes 349
                                                                         converting to other vector
                                                                           type 824
                                      links in spreadsheets 522          creating new vector
underline
                                      links to objects in                  graphic 750, 756
   automatic 124
                                        spreadsheets 599                 dmaths 560
   formatting icon (Impress) 686
                                      master documents 329               opening vector graphic 756
   formatting, object bar 200
                                      paragraph styles 261               scaling well 787
   text (Draw) 771
                                      spreadsheet calculations 571    version control
undo 175, 421
                                      styles 266                         about 406
unfreezing rows and
                                      tables of contents 342             accepting or rejecting changes
   columns 553
                                   uppercase, automatic 122                (Calc) 621
unhiding rows and columns 537
                                   URLs                                  colors for changes 618
uninstalling 40
                                      automatic formatting 130           comments, adding to
unit of measurement
                                      entering to browse 438               changes 619
   setting 114, 180
                                      icons, example of use 470          comparing documents 419
   setting (Image) 784
                                      hypertext link 272                 numbering lines 226, 419
   setting (Impress, Draw) 663
                                      Internet URLs field 470            protecting documents 422
UNIX
                                      linking to using Hyperlink         saving versions of a document
   creating new printer 55
                                        window 471                         (Calc) 618
   database access with ODBC
                                      Load URL field 470                 saving versions of a document
     and MySQL 881
                                      relative or absolute 138             (Writer) 406
   fax setup 63
                                      URL Name field                     showing changes 420
   faxing 79
                                          example of use 470          versions
   installation notes 23
                                      URL recognition 124                comparing for a single
   PDF setup 67
                                   Use replacement table                   document 408
   printer setup 54
                                      option 124                         deleting 407
   printer setup for all
                                   user field 865                        opening prior 407
     platforms 75
                                                                         reverting to prior 409
   printers
                                                                         saving different 407
       additional settings 60
                                                                         viewing previous 407
       converting                  V                                  Versions window 407
       Device setting 60                                              vertical
       duplex 57                   valid entries 603                     alignment in cells 289, 541,
       fonts, adding 71            Validity window 604                     544
       fonts, general font         value highlighting 588, 615           distribution options 774
         substitution 74, 82       values in drop-down list, adding      flipping objects 782
       fonts, per-printer             to forms 939                       lines, drawing 767
                                   VARCHAR 909                           snapping to, see grid 767
         substitution 72
                                   variables                             ruler (Writer) 179
       name, changing 62              business cards without 397         sort (Calc) 575
       Paper setting 60               creating 320                       text
       PostScript level 60            example 366                            aligning text to specific
       removing 62                    finding with goal seek 609               line 819
   printing to PDF 79                 finding with scenarios 605             Draw 770
   printing right now 54              set variable field 864
                                                                             enabling 109
unlinking                             show page variable field 864
   frames 243                         show variable field 864                fitting to line height 204
   hyperlink 472                   VBScript                                  using (Impress)
untitled document, naming 646         adding to document 487                 Writer 244, 274
unvisited links 272                   see also scripts                viewing
unzipping files 146                vectors                               grid (Writer) 306
updating                              converting 823                     notes in documents 424
   bibliographies 356                 converting rasters to 827          shortcut keys 105
   chart data 597
1018      Index



views, layer, slide, and               converting presentation 738       work area
    background 657                     presentation time for each           Basic 965
Visible grid 779                         slide 740                          Calc 499
Visio-like tools, see connectors,      script options 741                   Draw 751
    lines                           WebQueries 15, 511                      Image 752
visited links 272                   Werner Roth Web site 39                 Impress 635
                                    whales, killer 801                      Web 443
                                    what-if scenarios in                    Writer 169
                                       spreadsheets 605                  wrapping
W                                   widows, controlling 213                 non-wrapping text in text
                                    width                                     frame 682
Warning Print Options                  columns in Calc, adjusting 536       text frames, setting 683
  window 94, 848                       line, changing 768                   text in cells 96, 528, 544
Washington Post review of              text frames, setting 683             text in text frame 681
  OpenOffice.org 8                     text width 206                    write-protecting
watermark                              see also tables                      cells 546
  applying effect to rasters in     wildcards in search and                 cells and sheets 602
    Draw 838                           replace 525                       Writer
  applying watermark effect to      Windows                                 conversion to HTML and vice
    images 838                         faxing 79                              versa 448
  example of effect 838                installation notes 23                creating new document 175
Web                                    printer setup for all                features 168
  browsing 443                           platforms 75                       guided tour 170
  browsing, procedure 445              printing to PDF 79                   keyboard shortcuts 175
  browsing, setup 136                  restarting every day xvii            lining up objects on a grid 305
  converting documents for use         system requirements 22               linking to target within a
    on 448                          windows                                   document 472-473
  fax, entering 493                    splitting (Calc) 553                 menu bar 170
  features 442                         type for saving and                  new features 14
  graphics in documents 466              opening 131                        object bar 170
  grid options 435                  wizards, see autopilots                 presentation basis 639
  guided tour, HTML                 womplets 410                            printing 426-427
    document 444                    Word                                    Quick Start checklist 168
  HTML document,                       opening files by default in          ruler 170
    creating 443                         StarOffice 29                      setup options 174
  HTML export settings 142             opening MS files in StarOffice       starting 169
  nested tables source 458               or OpenOffice.org 29, 152          status bar 170
  new features 14                      switching from 10                    styles, about 247
  new HTML document 446-447         word completion                         templates, where program
  page layout 466                      controlling 127                        looks 178
  printing 492                         in Calc 532                          toolbar 170
      options 493                      key to press to accept 128           turning documents into
  proxy setup 135                      making useful 130                      HTML 179
  Quick Start checklist 442            options 127                          tutorial 170
  searching from program 438           turning off 130                      using templates 262
  templates 452                     WordPerfect 4, 9, 20, 411               work area 169
  URLs relative or absolute 138     words
  view options 435                     adding to spell check 193
  warning about                        controlling hyphenation 196
    interchangeability of              counting in document 186
                                                                         X
    HTML 462                           counting in paragraph 187
  what source looks like 450           in document 154                   X axis
  work area 443                        specifying separator characters      bitmaps 765
WebCast                                  for word count 187                 chart 590
                                  Index   1019



  duplicating object 817
  grid setup 779
  positioning objects 776
XML
  configuration you can do 146
  converting War and Peace
   to 577
  DTD 10
  DTD location 147
  unzipping documents 146
XPM, description 787


Y
Y axis field
   bitmaps 765
   chart 590
   duplicating object 817
   grid setup 779
yellow 803


Z
zero values, hiding 541
zeroes, leading 543
zipping or unzipping files 146
zoom
   changing on status bar 170
   changing (Impress, Draw) 663
   setting default values 114

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:12/26/2011
language:English
pages:43