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

Learn OpenOffice.org Spreadsheet Macro Programming

Credits

About the Author

About the Reviewer

Preface

Working with OOo's Basic IDE

Before We Start

Accessing the OOo IDE

Designing Dialogs with the IDE

Summary

Libraries, Modules, Subroutines, and Functions

Using Libraries

Using Modules

Writing Macros

Getting more Information

Subroutines and Functions in Different Libraries

Summary

The OOo Object Model

Why be Interested in UNOs?

Overview of the OOo Object Model

Starting to Work with UNOs

Online Reference Material

A Real Example: Using the Table UNO to Access a Cell

Services within Services

List of Everything You Want to Know About UNOs

Summary

Using Macros with Spreadsheets

Opening and Closing Spreadsheets

Manipulating Spreadsheet Cells

Named Worksheets and Cells

Working with Multiple Spreadsheets

Using Ranges of Cells

Summary

Formatting your Spreadsheets

The Most Basic Formatting—Column and Row Dimensions

Formatting the Printed Page

Customizing Worksheet Names

Updating the Document Information

Formatting Cells and Ranges of Cells

Online Reference Material

Summary

Working with Databases

Accessing Databases

Putting it All into a Spreadsheet

Adding New Records to the Database

Updating the Database

Summary

Working with Other Documents

The OpenOffice.org Chart

Using Documents from Other Sources

Processing Web Pages

Summary

Developing Dialogs

Using OpenOffice.org's Built-In Dialogs

Developing your Own Dialogs

Finding Further Information

Summary

Creating a Complete Application

Making Macros and Dialogs Available to Everyone

Using a Global Library to Automate OOo Calc

Adding Macros to the OpenOffice.org Calc Menu

Keeping It All Hidden

Running Macros from the Command Line

Creating Background or Batch Processes

Sending Emails

Summary

Using Excel VBA

The Current State

Installing SUSE Linux 10.1

Building OpenOffice.org from Source

Importing an Excel Spreadsheet that Contains Macros

Starting to Code with Excel VBA in Calc

Comparing VBA and OOo Basic Code

Further VBA Examples

Further Information

Summary