Openoffice Org 3 0 Getting Started Guide With OpenOffice.org

2015-07-27

• Chapter 1 Introducing OpenOffice.org
  • What is OpenOffice.org?
    • Writer (word processor)
    • Calc (spreadsheet)
    • Impress (presentations)
    • Draw (vector graphics)
    • Base (database)
    • Math (formula editor)
  • The advantages of OpenOffice.org
  • Minimum requirements
  • How to get the software
  • How to install the software
  • How to get help
    • Help system
    • Free online support
    • Paid support and training
  • Extensions and add-ons
  • Starting OpenOffice.org
    • Note for Mac users
    • Starting from an existing document
      • Note for Windows users
    • Using the Quickstarter under Windows
      • Using the Quickstarter icon
      • Disabling the Quickstarter
      • Reactivating the Quickstarter
    • Using the Quickstarter in Linux
    • Preloading OOo under Linux/KDE
    • Starting from the command line
  • Parts of the main window
    • Menu bar
    • Toolbars
      • Displaying or hiding toolbars
      • Submenus and tear-off toolbars
      • Moving toolbars
      • Floating toolbars
      • Docking/floating windows and toolbars
      • Customizing toolbars
    • Right-click (context) menus
  • Starting a new document
  • Opening an existing document
  • Saving documents
    • Password protection
    • Saving a document automatically
  • Renaming and deleting files
  • Using the Open and Save As dialogs
  • Using the Navigator
  • Closing a document
  • Closing OpenOffice.org
• Chapter 2 Setting up OpenOffice.org
  • Choosing options for all of OOo
    • User Data options
    • General options
    • Memory options
    • View options
    • Print options
    • Path options
    • Color options
    • Font options
    • Security options
    • Appearance options
    • Accessibility options
    • Java options
    • Online Update options
  • Choosing options for loading and saving documents
    • General Load/Save options
    • VBA Properties Load/Save options
    • Microsoft Office Load/Save options
    • HTML compatibility Load/Save options
  • Choosing language settings
    • Install the required dictionaries
    • Change locale and language settings
    • Choose spelling options
  • Choosing Internet options
  • Controlling OOo’s AutoCorrect functions
• Chapter 3 Using Styles and Templates
  • What is a template?
  • What are styles?
  • Applying styles
    • Using the Styles and Formatting window
    • Using Fill Format mode
    • Using the Apply Style list
    • Using keyboard shortcuts
  • Modifying styles
    • Changing a style using the Style dialog
    • Updating a style from a selection
    • Using AutoUpdate
    • Updating styles from a document or template
  • Creating new (custom) styles
    • Creating a new style using the Style dialog
    • Creating a new style from a selection
    • Dragging and dropping to create a style
  • Copying and moving styles
    • Using the Template Management dialog
    • Loading styles from a template or document
  • Deleting styles
  • Using a template to create a document
  • Creating a template
    • Creating a template from a document
    • Creating a template using a wizard
  • Editing a template
    • Updating a document from a changed template
  • Adding templates using the Extension Manager
  • Setting a default template
    • Setting a custom template as the default
    • Resetting the default template
  • Associating a document with a different template
  • Organizing templates
    • Creating a template folder
    • Deleting a template folder
    • Moving a template
    • Deleting a template
    • Importing a template
    • Exporting a template
  • Examples of style use
    • Defining a different first page for a document
    • Dividing a document into chapters
    • Changing page orientation within a document
    • Different headers on right and left pages
    • Controlling page breaks automatically
    • Compiling an automatic table of contents
    • Defining a sequence of styles
• Chapter 4 Getting Started with Writer
  • What is Writer?
  • The Writer interface
    • Status bar
    • Document views
    • Moving quickly through a document
  • Working with documents
    • Saving as a Microsoft Word file
  • Working with text
    • Selecting items that are not consecutive
    • Selecting a vertical block of text
    • Cutting, copying, and pasting text
    • Finding and replacing text and formatting
    • Inserting special characters
    • Setting tab stops and indents
    • Checking spelling
    • Using language tools
    • Using AutoCorrect
    • Using word completion
    • Using AutoText
    • Inserting dashes and non-breaking spaces
  • Formatting text
    • Using styles
    • Formatting paragraphs
    • Formatting characters
    • Autoformatting
    • Creating numbered or bulleted lists
      • Using the Bullets and Numbering toolbar
    • Hyphenating words
  • Undoing and redoing changes
  • Formatting pages
    • Which layout method to choose?
    • Creating headers and footers
    • Numbering pages
      • Including the total number of pages
      • Restarting page numbering
    • Changing page margins
  • Adding notes to a document
  • Creating a table of contents
  • Creating indexes and bibliographies
  • Working with graphics
  • Printing from Writer
    • Quick printing
    • Controlling printing
    • Selecting print options for a document
    • Printing in black and white on a color printer
    • Previewing pages before printing
    • Printing a brochure
    • Printing envelopes
    • Printing labels
  • Sending a fax using Writer
    • Sending a fax through the Print dialog
    • Adding a Fax icon to the toolbar
  • Tracking changes to a document
  • Using mail merge
  • Using master documents
  • Creating fill-in forms
  • Using fields
  • Using cross-references
  • Using bookmarks
• Chapter 5 Getting Started with Calc
  • What is Calc?
  • Spreadsheets, sheets and cells
  • Parts of the main Calc window
    • Title bar and Menu bar
    • Toolbars
    • Formula bar
    • Individual cells
    • Sheet tabs
    • Status bar
  • Starting new spreadsheets
  • Opening existing spreadsheets
  • Saving spreadsheets
  • Navigating within spreadsheets
    • Going to a particular cell
      • Using the mouse
      • Using a cell reference
      • Using the Navigator
    • Moving from cell to cell
      • Using the mouse
      • Using the Tab and Enter keys
      • Customizing the Enter key
      • Using the arrow keys
      • Using Home, End, Page Up and Page Down
    • Moving from sheet to sheet
      • Using the keyboard
      • Using the mouse
  • Selecting items in a sheet or spreadsheet
    • Selecting cells
      • Single cell
      • Range of contiguous cells
      • Range of non-contiguous cells
    • Selecting columns and rows
      • Single column or row
      • Multiple columns or rows
      • Entire sheet
    • Selecting sheets
      • Single sheet
      • Multiple contiguous sheets
      • Multiple non contiguous sheets
      • All sheets
  • Working with columns and rows
    • Inserting columns and rows
      • Single column or row
      • Multiple columns or rows
    • Deleting columns and rows
      • Single column or row
      • Multiple columns or rows
  • Working with sheets
    • Inserting new sheets
    • Deleting sheets
    • Renaming sheets
  • Viewing Calc
    • Using zoom
    • Freezing rows and columns
      • Freezing single rows or columns
      • Freezing a row and a column
      • Unfreezing
    • Splitting the window
      • Splitting the screen horizontally
      • Splitting the screen vertically
      • Removing split views
  • Entering data using the keyboard
    • Entering numbers
    • Entering text
    • Entering numbers as text
    • Entering dates and times
  • Speeding up data entry
    • Using the Fill tool on cells
      • Using a fill series
      • Defining a fill series
    • Using selection lists
    • Sharing content between sheets
  • Editing data
    • Removing data from a cell
      • Removing data only
      • Removing data and formatting
    • Replacing all the data in a cell
    • Changing part of the data in a cell
      • Using the keyboard
      • Using the mouse
  • Formatting data
    • Formatting multiple lines of text
      • Using automatic wrapping
      • Using manual line breaks
    • Shrinking text to fit the cell
    • Formatting numbers
    • Formatting the font
    • Formatting the cell borders
    • Formatting the cell background
  • Autoformatting cells and sheets
    • Defining a new AutoFormat
  • Formatting spreadsheets using themes
  • Hiding and showing data
    • Outline group controls
    • Filtering which cells are visible
  • Sorting records
  • Printing
    • Selecting sheets to print
    • Selecting the page order, details, and scale
      • Page Order
      • Print
      • Scale
    • Using print ranges
      • Defining a print range
      • Removing a print range
    • Printing rows or columns on every page
    • Page breaks
      • Inserting a page break
      • Deleting a page break
    • Headers and footers
      • Header or footer appearance
      • Contents of the header or footer
• Chapter 6 Getting Started with Impress
  • What is Impress?
  • Parts of the main Impress window
    • Slides pane
    • Tasks pane
    • Workspace
    • Toolbars
    • Navigator
  • Working with views
    • Normal view
    • Outline view
    • Notes view
    • Slide Sorter view
    • Handout view
  • Creating a new presentation
    • Planning a presentation
    • Using the Presentation Wizard
  • Formatting a presentation
    • Creating the first slide
    • Inserting additional slides
    • Modifying the appearance of slides
    • Modifying the slide show
  • Slide masters and styles
  • Working with slide masters
    • Creating slide masters
    • Applying a slide master
    • Loading additional slide masters
    • Modifying a slide master
    • Adding text to all slides
  • Adding and formatting text
    • Using text boxes created from the Layout pane
    • Using text boxes created from the text box tool
    • Pasting text
      • Pasting unformatted text
      • Formatting pasted text
    • Creating bulleted and numbered lists
      • Creating lists in AutoLayout text boxes
      • Creating lists in other text boxes
      • Creating a new outline level
      • Changing the appearance of the list
  • Creating tables
  • Adding graphics, spreadsheets, charts, and other objects
  • Setting up the slide show
  • Running the slide show
• Chapter 7 Getting Started with Draw
  • What is Draw?
  • The Draw workspace
    • Rulers
    • Status bar
    • Toolbars
  • Positioning objects with snap functions
    • Snap to grid
    • Showing the grid
    • Configuring the grid
    • Changing the color of the grid points
  • Positioning objects with helper lines
  • The basic drawing shapes
    • Drawing a straight line
    • Drawing an arrow
    • Drawing lines and arrows
    • Drawing a rectangle or square
    • Drawing a circle or ellipse
    • Drawing curves
    • Writing text
    • Gluepoints and connectors
  • Drawing geometric shapes
  • Selection modes
    • Changing the selection mode
  • Selecting objects
    • Direct selection
    • Selection by framing
    • Selecting hidden objects
    • Arranging objects
    • Selecting several objects
  • Moving and dynamically adjusting an object’s size
    • Dynamic movement of objects
    • Dynamic size modification of objects
    • Rotation
    • Inclination and perspective
  • Editing objects
    • The context menu
    • Editing lines and borders
    • Common line properties
    • Drawing arrows
    • Customizing line and arrow styles
    • Editing the inside (fill) of an object
    • Adding a shadow
    • Adding transparency
  • Using styles
  • Special effects
    • Flip an object
    • Mirror copies
    • Distorting an image
    • Dynamic gradients
    • Duplication
    • Cross-fading
  • Combining multiple objects
    • Grouping by common selection
    • Maintaining groups and undoing groups
    • Combining objects
  • Aids for positioning objects
  • Editing pictures
  • Working with 3D objects
  • Inserting pictures from other sources
  • Exchanging objects with other programs
• Chapter 8 Getting Started with Base
  • Introduction
  • Planning a database
  • Creating a new database
  • Creating database tables
    • Using the Wizard to create a table
    • Creating a table by copying an existing table
    • Creating tables in Design View
    • Creating tables for the list box
    • Adding data to the list table
    • Creating a View
  • Defining relationships
  • Creating a database form
    • Using the Wizard to create a form
    • Modifying a form
    • Creating forms in Design View
    • Creating subforms in Design View
  • Accessing other data sources
    • Accessing a dBase database
    • Accessing a Mozilla address book
    • Accessing spreadsheets
    • Registering databases created by OOo2.x and later
  • Using data sources in OpenOffice.org
    • Viewing data sources
    • Editing data sources
    • Launching Base to work on data sources
    • Using data sources in OOo documents
      • Writer documents
      • Calc spreadsheets
  • Entering data in a form
  • Creating queries
    • Using the Wizard to create a query
    • Using the Design View to create a query
  • Creating reports
    • Creating a static report
    • Creating a dynamic report
    • Modifying a report
    • More ways to create reports
• Chapter 9 Getting Started with Math
  • What is Math?
    • Getting started
  • Entering a formula
    • The Selection window
    • Example 1:
    • Right-click menu
    • Markup
    • Greek characters
    • Example 2:
  • Customizations
    • Formula editor as a floating window
    • How can I make a formula bigger?
  • Formula layout
    • Brackets are your friends
    • Equations over more than one line
  • Common problem areas
    • How do I add limits to my sum/integral?
    • Brackets with matrices look ugly!
    • How do I make a derivative?
    • Numbering equations
• Chapter 10 Printing, Exporting, and E‑mailing
  • Introduction
  • Quick printing
  • Controlling printing
  • Exporting to PDF
    • Quick export to PDF
    • Controlling PDF content and quality
      • General page of PDF Options dialog
      • Initial View page of PDF Options dialog
      • User Interface page of PDF Options dialog
      • Links page of PDF Options dialog
      • Security page of PDF Options dialog
  • Exporting to other formats
  • E-mailing documents
    • E-mailing a document to several recipients
  • Digital signing of documents
• Chapter 11 Graphics, the Gallery, and Fontwork
  • Introduction
  • Inserting an image from a file
    • Linking an image file
    • Embedding linked images
  • Inserting images from a graphics program
  • Inserting images using a scanner
  • Modifying and positioning graphics
  • Using the OpenOffice.org Gallery
    • Inserting images into a document
    • Inserting objects as links
    • Inserting an object as a background
  • Managing the Gallery
    • Adding objects to the Gallery
    • Deleting images from the Gallery
    • Adding a new theme to the Gallery
    • Deleting a theme from the Gallery
    • Location of the Gallery and the objects in it
  • What is Fontwork?
  • The Fontwork toolbars
  • Creating a Fontwork object
  • Editing a Fontwork object
    • Using the Fontwork toolbar
    • Using the Formatting toolbar
      • Line options
      • Area options
      • Positioning options
    • Using menu options
  • Moving and resizing Fontwork objects
• Chapter 12 Creating Web Pages
  • Introduction
  • Inserting hyperlinks
    • Editing hyperlinks
  • Saving Writer documents as web pages
    • Saving a document as a single web page
    • Saving a document as a series of web pages
    • Creating web pages using a Wizard
  • Saving Calc spreadsheets as web pages
  • Saving Impress presentations as web pages
  • Saving Draw documents as web pages
• Chapter 13 Getting Started with Macros
  • Your first macro
    • Creating a simple macro
    • Running the macro
    • Viewing and editing the macro
      • Comments start with REM
      • Defining subroutines with SUB
      • Defining variables using DIM
      • Pulling the macro together
  • Creating a macro
    • A complicated example
    • Running the macro quickly
  • Sometimes the macro recorder fails
    • The dispatch framework
    • How the macro recorder uses the dispatch framework
    • Other options
  • Macro organization
    • Where are macros stored?
    • Importing macros
    • Downloading macros to import
  • How to run a macro
    • Toolbar
    • Menu item
    • Keyboard shortcuts
    • Event
  • Extensions
  • Writing macros without the recorder
  • Finding more information
    • Included material
    • Online resources
    • Published material
• Chapter 14 Customizing OpenOffice.org
  • Introduction
  • Customizing menu content
    • Creating a new menu
    • Modifying existing menus
    • Adding a command to a menu
    • Modifying menu entries
  • Customizing toolbars
    • Creating a new toolbar
    • Adding a command to a toolbar
    • Choosing icons for toolbar commands
      • Example: Adding a Fax icon to a toolbar
  • Assigning shortcut keys
    • Example: Assigning styles to shortcut keys
    • Saving changes to a file
    • Loading a saved keyboard configuration
    • Resetting the shortcut keys
  • Assigning macros to events
  • Adding functionality with extensions
    • Installing extensions
  • Using extensions
    • PDF Import
    • Presenter Console
    • Report Builder
    • Professional Template Pack II
    • Template Changer
• Appendix A Keyboard Shortcuts
  • Introduction
  • Function key shortcuts
  • General shortcut keys for OpenOffice.org
  • Shortcut keys in the Gallery
    • In the New Theme area of the Gallery
    • In the Gallery preview area
  • Selecting rows and columns in a database table (opened by F4)
  • Shortcut keys for drawing objects
• Appendix B Background Information
  • Introduction
  • A short history of OpenOffice.org
  • The OpenOffice.org community
  • How is OpenOffice.org licensed?
  • What is “open source”?
  • What is OpenDocument?
  • File formats OOo can open
    • Opening text documents
    • Opening spreadsheets
    • Opening presentations
    • Opening graphic files
    • Opening formula files
  • File formats OOo can save to
    • Saving text documents
    • Saving spreadsheet files
    • Saving presentations
    • Saving drawings
    • Writer/Web can save in these formats
  • Frequently asked questions
• Index