O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learn OpenOffice.org Spreadsheet Macro Programming

Book Description

A fast and friendly tutorial to writing macros and spreadsheet applications

  • Discover the power of the OpenOffice.org macro language and Calc object model

  • Fast, fun, friendly step-by-step OOoBasic tutorial

  • Practical and realistic examples to apply to your daily work

  • This book covers OpenOffice.org version 2.0.4 for Windows and version 2.0.2 for Linux

  • In Detail

    Adding macros to your spreadsheets enables you to add data processing features to your work, automate repetitive tasks, and even create complete data-driven programs that use the spreadsheet as their back end.

    This book teaches the OOoBasic language and the Calc object model, so that you can manipulate spreadsheets and data from within your programs. You will also see how to create dialog boxes and windows for friendly user interfaces, and how to integrate your spreadsheets with other applications, for example writing spreadsheet data to a document, or capturing data from a database, and using the spreadsheet for generating advanced calculations and reports.

    Calc is OpenOffice.org's spreadsheet module. Like the rest of OpenOffice.org Calc can be programmed using the built-in language OOoBasic. Both simple macros and complex applications can be developed in this language by controlling Calc through its object model. The book is compatible with the commercial version of OpenOffice.org, StarOffice, and the StarBasic language.

    Learn how to extend and customize Calc, the OpenOffice.org spreadsheet, using OOoBasic, OOo's built-in programming language. You don’t need to be a developer to create useful and powerful routines and applications. This well structured and practical tutorial will walk you though every step, and inspire you with great ways to save time and increase your productivity using Calc.

    Table of Contents

    1. Copyright
    2. Credits
    3. About the Author
    4. About the Reviewer
    5. Preface
    6. Working with OOo's Basic IDE
      1. Before We Start
      2. Accessing the OOo IDE
      3. Designing Dialogs with the IDE
      4. Summary
    7. Libraries, Modules, Subroutines, and Functions
      1. Using Libraries
      2. Using Modules
      3. Writing Macros
      4. Getting more Information
      5. Subroutines and Functions in Different Libraries
      6. Summary
    8. The OOo Object Model
      1. Why be Interested in UNOs?
      2. Overview of the OOo Object Model
      3. Starting to Work with UNOs
      4. Online Reference Material
      5. A Real Example: Using the Table UNO to Access a Cell
      6. Services within Services
      7. List of Everything You Want to Know About UNOs
      8. Summary
    9. Using Macros with Spreadsheets
      1. Opening and Closing Spreadsheets
      2. Manipulating Spreadsheet Cells
      3. Named Worksheets and Cells
      4. Working with Multiple Spreadsheets
      5. Using Ranges of Cells
      6. Summary
    10. Formatting your Spreadsheets
      1. The Most Basic Formatting—Column and Row Dimensions
      2. Formatting the Printed Page
      3. Customizing Worksheet Names
      4. Updating the Document Information
      5. Formatting Cells and Ranges of Cells
      6. Online Reference Material
      7. Summary
    11. Working with Databases
      1. Accessing Databases
      2. Putting it All into a Spreadsheet
      3. Adding New Records to the Database
      4. Updating the Database
      5. Summary
    12. Working with Other Documents
      1. The OpenOffice.org Chart
      2. Using Documents from Other Sources
      3. Processing Web Pages
      4. Summary
    13. Developing Dialogs
      1. Using OpenOffice.org's Built-In Dialogs
      2. Developing your Own Dialogs
      3. Finding Further Information
      4. Summary
    14. Creating a Complete Application
      1. Making Macros and Dialogs Available to Everyone
      2. Using a Global Library to Automate OOo Calc
      3. Adding Macros to the OpenOffice.org Calc Menu
      4. Keeping It All Hidden
      5. Running Macros from the Command Line
      6. Creating Background or Batch Processes
      7. Sending Emails
      8. Summary
    15. Using Excel VBA
      1. The Current State
      2. Installing SUSE Linux 10.1
      3. Building OpenOffice.org from Source
      4. Importing an Excel Spreadsheet that Contains Macros
      5. Starting to Code with Excel VBA in Calc
      6. Comparing VBA and OOo Basic Code
      7. Further VBA Examples
      8. Further Information
      9. Summary
    16. Index