Learn OpenOffice.org Spreadsheet Macro Programming
Designing Dialogs with the IDE
Libraries, Modules, Subroutines, and Functions
Subroutines and Functions in Different Libraries
Overview of the OOo Object Model
A Real Example: Using the Table UNO to Access a Cell
List of Everything You Want to Know About UNOs
Using Macros with Spreadsheets
Opening and Closing Spreadsheets
Manipulating Spreadsheet Cells
Working with Multiple Spreadsheets
The Most Basic Formatting—Column and Row Dimensions
Updating the Document Information
Formatting Cells and Ranges of Cells
Putting it All into a Spreadsheet
Adding New Records to the Database
Using Documents from Other Sources
Using OpenOffice.org's Built-In Dialogs
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
Running Macros from the Command Line
Creating Background or Batch Processes
Building OpenOffice.org from Source
Importing an Excel Spreadsheet that Contains Macros
Starting to Code with Excel VBA in Calc