Openoffice Org 3 Getting Started Guide With OpenOffice.org 3.3

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
  • Extensions and add-ons
  • How to get help
    • Help system
    • Free online support
    • Paid support and training
  • Starting OpenOffice.org
    • Starting from an existing document
    • 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
    • Status bar
  • What are all these things called?
  • Starting a new document
  • Opening an existing document
  • Saving a document
    • Password protection
    • Saving a document automatically
  • Renaming and deleting files
  • Using the Open and Save As dialogs
  • Using the Navigator
  • Undoing and redoing changes
  • Closing a document
  • Closing OpenOffice.org
  • Using OpenOffice.org on a Mac
• 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
      • Security options and warnings
    • Appearance options
    • Accessibility options
    • Java options
    • Online Update options
    • Improvement program
  • 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
  • Changing 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
    • Inserting dashes and non-breaking spaces and hyphens
    • Setting tab stops and indents
    • Changing the default tab stop interval
    • Checking spelling and grammar
    • Using built-in language tools
    • Using AutoCorrect
    • Using word completion
    • Using AutoText
      • Creating AutoText
      • Inserting AutoText
  • Formatting text
    • Using styles is recommended
    • Formatting paragraphs
    • Formatting characters
    • Autoformatting
    • Creating numbered or bulleted lists
      • Using the Bullets and Numbering toolbar
    • Hyphenating words
      • Automatic hyphenation
      • Manual hyphenation
  • 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 comments to a document
  • Creating a table of contents
  • Creating indexes and bibliographies
  • Working with graphics
  • Printing
  • Using mail merge
  • Tracking changes to a document
  • Using fields
  • Linking to another part of a document
    • Using hyperlinks
    • Using cross-references
    • Using bookmarks
  • Using master documents
  • Creating fill-in forms
• Chapter 5 Getting Started with Calc
  • What is Calc?
  • Spreadsheets, sheets and cells
  • Parts of the main Calc window
    • Title bar
    • Menu bar
    • Toolbars
    • Formula bar
    • Individual cells
    • Sheet tabs
    • Status bar
  • Opening and saving CSV files
    • Opening a CSV file
    • Saving as a CSV file
  • Navigating within spreadsheets
    • Going to a particular cell
    • Moving from cell to cell
      • Customizing the Enter key
    • Moving from sheet to sheet
  • Selecting items in a sheet or spreadsheet
    • Selecting cells
    • Selecting columns and rows
    • Selecting sheets
  • Working with columns and rows
    • Inserting columns and rows
    • Deleting columns and rows
  • Working with sheets
    • Inserting new sheets
    • Deleting sheets
    • Renaming sheets
  • Viewing Calc
    • Using zoom
    • Freezing rows and columns
    • Splitting the screen
      • 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
    • Deactivating automatic changes
  • 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
  • Validating cell contents
  • Editing data
    • Removing data from a cell
    • Replacing all the data in a cell
    • Changing part of the data in a cell
  • 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
  • Using conditional formatting
  • Hiding and showing data
    • Outline group controls
    • Filtering which cells are visible
  • Sorting records
  • Printing
    • Using print ranges
      • Defining a print range
      • Adding to the print range
      • Removing a print range
      • Editing a print range
    • Selecting the page order, details, and scale
    • Printing rows or columns on every page
    • Page breaks
      • Inserting a page break
      • Deleting a page break
    • Headers and footers
      • Setting a header or footer
      • Header or footer appearance
      • Setting the contents of the header or footer
• Chapter 6 Getting Started with Impress
  • What is Impress?
  • Starting Impress
  • Parts of the main Impress window
    • Slides pane
    • Tasks pane
    • Workspace
    • Toolbars
    • Status bar
    • Navigator
  • Workspace views
    • Normal view
    • Outline view
    • Notes view
    • Handout view
    • Slide Sorter view
      • Customizing Slide Sorter view
      • Moving a slide using Slide Sorter
      • Selecting and moving groups of slides
      • Working in Slide Sorter view
      • Renaming slides
  • Creating a new presentation
  • Formatting a presentation
    • Inserting slides
    • Selecting a layout
    • Modifying the slide elements
    • Adding text to a slide
    • Modifying the appearance of all slides
    • Modifying the slide show
  • Adding and formatting text
    • Using text boxes created from the Layout pane
    • Using text boxes created from the text box tool
    • Quick font resizing
    • 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
  • Adding pictures, tables, charts and media
    • Adding pictures
    • Adding tables
    • Adding charts
    • Adding media clips
    • Adding graphics, spreadsheets, and other objects
  • Working with slide masters and styles
    • Styles
    • Slide masters
    • Creating a slide master
    • Applying a slide master
    • Loading additional slide masters
    • Modifying a slide master
    • Using a slide master to add text to all slides
  • Adding comments to a presentation
  • Setting up the slide show
    • One slide set – multiple presentations
    • Slide transitions
    • Automatic slides advance
  • Running the slide show
• Chapter 7 Getting Started with Draw
  • What is Draw?
  • The Draw workspace
    • Rulers
    • Status bar
    • Toolbars
  • Choosing and defining colors
  • Positioning objects with snap functions
    • Snap to grid
    • Showing the grid
    • Configuring the grid
    • Changing the color of the grid points
  • Positioning objects with guiding lines
  • The basic drawing shapes
    • Drawing a straight line
    • Drawing an arrow
    • Choosing line endings
    • 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
  • Inserting and editing pictures
  • Working with 3D objects
  • Exporting graphics
  • Adding comments to a drawing
• 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
  • Defining relationships
  • Creating a database form
    • Using the Wizard to create a form
    • Modifying a form
    • Creating forms and subforms in Design View
  • Accessing other data sources
    • Accessing a spreadsheet as a data source
    • Registering *.odb databases
  • Using data sources in OpenOffice.org
    • Viewing data sources
    • Editing data sources
    • Launching Base to work on data sources
    • Using data sources in Writer and Calc
      • 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
      • Vacations table report
      • Vacation fuel 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 Elements 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
    • How do I add limits to my sum/integral?
    • Brackets with matrices look ugly!
    • How do I make a derivative?
    • How do I align my equations at the equals sign?
  • Numbering equations
• Chapter 10 Printing, Exporting, and E‑mailing
  • Introduction
  • Quick printing
  • Controlling printing
    • Selecting general printing options
    • Printing multiple pages on a single sheet of paper
    • Selecting pages/sheets/slides to print
      • Writer
      • Calc
      • Impress and Draw
    • Printing handouts, notes, or outlines in Impress
    • Printing a brochure
    • Printing envelopes, labels, business cards
    • Printing in black and white (on a color printer)
    • Previewing pages/sheets before printing
      • Writer
      • Calc
  • 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
  • Removing personal data
• Chapter 11 Graphics, the Gallery, and Fontwork
  • Introduction
  • Adding images to a document
    • Inserting an image file
      • Drag and drop
      • Insert Picture dialog
    • Linking an image file
      • Embedding linked images
    • Inserting an image from the clipboard
    • Inserting an image using a scanner
    • Inserting an image from the Gallery
    • Inserting an image as a background
  • Modifying and positioning graphics
  • Managing the OpenOffice.org 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
  • Creating an image map
  • Using OOo’s drawing tools
    • Creating drawing objects
    • Set or change properties for drawing objects
    • Resizing a drawing object
    • Grouping drawing objects
  • Using Fontwork
    • The Fontwork toolbars
    • Creating a Fontwork object
    • Editing a Fontwork object
      • Using the Fontwork toolbar
      • Using the Formatting toolbar
      • Using menu options
      • Using the 3D-Settings toolbar
    • Moving and resizing Fontwork objects
• Chapter 12 Creating Web Pages
  • Introduction
  • Relative and absolute hyperlinks
  • Creating hyperlinks
    • Using the Navigator
    • Using the Hyperlink dialog
    • Editing hyperlinks
    • Removing 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 macros
    • Adding an existing 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
    • Printed and eBook materials
• 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
    • Some popular extensions
• Appendix A Keyboard Shortcuts
  • Introduction
    • Tip for Macintosh users
  • General keyboard shortcuts
    • Opening menus and menu items
    • Controlling dialogs
    • Getting help
    • Managing documents
    • Navigating across OpenOffice.org
    • Editing
    • Stopping macros
  • Defining keyboard shortcuts
  • Further reading
• Appendix B Open Source, Open Standards, OpenDocument
  • Introduction
  • A short history of OpenOffice.org
  • The OpenOffice.org community
  • How is OpenOffice.org licensed?
  • What is “open source”?
  • What are “open standards”?
  • What is OpenDocument?
    • OpenDocument filename extensions
  • Frequently asked questions
  • 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
  • Exporting to other formats
• Index