Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation

Table of Contents

• Preface

• Chapter 1: Working with OOo's Basic IDE
  • Before We Start
  • Accessing the OOo IDE
    • Controls in IDE
    • Navigating around the IDE
      • The Object Catalog
      • Select Macro
      • The OpenOffice.org Basic Macro Organizer
  • Designing Dialogs with the IDE
  • Summary

• Chapter 2: Libraries, Modules, Subroutines, and Functions
  • Using Libraries
    • Managing Modules using Libraries
    • Using Libraries in a Multi-User Environment
    • Adding a Library to the OpenOffice.org Macros Area
  • Using Modules
  • Writing Macros
    • Writing Subroutines
      • Declare Variables
      • Assign Values to the Variables
      • Do the Work!
      • Inputting Variables
    • Writing Functions
  • Getting more Information
  • Subroutines and Functions in Different Libraries
  • Summary

• Chapter 3: The OOo Object Model
  • Why be Interested in UNOs?
  • Overview of the OOo Object Model
    • The Interface
    • The Service
    • The Module
  • Starting to Work with UNOs
    • Opening and Closing Spreadsheets Automatically
  • Online Reference Material
  • A Real Example: Using the Table UNO to Access a Cell
  • Services within Services
    • Finding Included Services
  • List of Everything You Want to Know About UNOs
  • Summary

• Chapter 4: Using Macros with Spreadsheets
  • Opening and Closing Spreadsheets
  • Manipulating Spreadsheet Cells
    • Using OOo's Builtin Functions
  • Named Worksheets and Cells
    • Accessing Existing Named Worksheets and Cells
    • Creating New Named Worksheets and Cells
    • Deleting Worksheets
  • Working with Multiple Spreadsheets
  • Using Ranges of Cells
  • Summary

• Chapter 5: Formatting your Spreadsheets
  • The Most Basic Formatting—Column and Row Dimensions
    • Optimizing Column Widths
    • Optimizing Column Widths across a Whole Worksheet
    • Setting Fixed Widths and Heights
    • Hiding Columns
  • Formatting the Printed Page
    • Adding a Page Break
    • Defining a Print Area
    • Setting the Header and Footer
    • Adding Page Numbers
    • Setting the Page Size and Orientation
  • Customizing Worksheet Names
  • Updating the Document Information
  • Formatting Cells and Ranges of Cells
    • Changing Cell Styles
    • Changing Cell Formats
      • Cell Background Colors
      • Text Colors
      • Cell Fonts
      • Character Heights
      • The Underline
      • Word Wrapping
      • Number Formats
  • Online Reference Material
  • Summary

• Chapter 6: Working with Databases
  • Accessing Databases
    • Which Databases can We Use?
    • Registering the Database as an OOo Data Source
    • Viewing Registered Data Sources
    • Connecting to a Database
    • Accessing Database Tables
      • Running Queries on the Tables
  • Putting it All into a Spreadsheet
    • Loading Data into Custom Worksheets
  • Adding New Records to the Database
  • Updating the Database
  • Summary

• Chapter 7: Working with Other Documents
  • The OpenOffice.org Chart
    • Inserting a Simple Chart into a Spreadsheet
    • Formatting OpenOffice.org Charts
      • Chart Size
      • Chart Title
      • Adding Chart Axis Labels
      • Y Axis Text Orientation
      • A fully Formatted Bar Chart
      • Other Chart Types
  • Using Documents from Other Sources
    • Stock Market Analysis—Yahoo! Finance
      • Importing an Historical CSV File from Yahoo! Finance
      • Comparing Companies within Yahoo! Finance
  • Processing Web Pages
  • Summary

• Chapter 8: Developing Dialogs
  • Using OpenOffice.org's Built-In Dialogs
    • Customizing Message Boxes
    • Customizing Input Boxes
  • Developing your Own Dialogs
    • Creating a Dialog
    • Loading a Dialog
    • Assigning Actions to a Dialog
    • Using Information in a Dialog
    • Populating Controls in a Dialog
    • The Finished Dialog
  • Finding Further Information
  • Summary

• Chapter 9: Creating a Complete Application
  • Making Macros and Dialogs Available to Everyone
    • Creating a Global Library
  • Using a Global Library to Automate OOo Calc
    • Running Macros Automatically when Calc Opens
  • Adding Macros to the OpenOffice.org Calc Menu
    • Adding a Macro to the Menu Manually
    • Distributing a Menu
  • Keeping It All Hidden
  • Running Macros from the Command Line
    • Running Macros in Linux
    • Running Macros in MS Windows
  • Creating Background or Batch Processes
    • Running Background Processes on Linux
    • Running Background Processes on Windows
  • Sending Emails
  • Summary

• Chapter 10: Using Excel VBA
  • The Current State
    • OpenOffice.org's Excel VBA Support under MS Windows
    • OpenOffice.org's Excel VBA Support under Linux
  • Installing SUSE Linux 10.1
  • Building OpenOffice.org from Source
    • Building on Linux
    • Support your Local OpenOffice.org Issue
  • Importing an Excel Spreadsheet that Contains Macros
    • Opening Up an Excel Spreadsheet
    • Viewing Code without VBA Support
    • Viewing Code with VBA Support
    • Closing your Spreadsheet
  • Starting to Code with Excel VBA in Calc
    • Combining VBA Code and OOo Basic Code
  • Comparing VBA and OOo Basic Code
    • Simplifying Code
    • VBA—No Strings Attached
    • Getting the Right Cell Position
      • Using Named Cells and Ranges
  • Further VBA Examples
    • Using Active Cells and Cell Offsets
    • Using the Workbooks Object
    • Using the Worksheets Object
  • Further Information
  • Summary

• Index

Dr Mark Alexander Bain

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Find your book in our support section to find errata and to download code samples.