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

A fast and friendly tutorial to writing macros and spreadsheet applications
Preview in Mapt

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

Dr Mark Alexander Bain

1 customer reviews
A fast and friendly tutorial to writing macros and spreadsheet applications
Mapt Subscription
FREE
$29.99/m after trial
eBook
$16.80
RRP $23.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$16.80
$39.99
$29.99 p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation Book Cover
Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation
$ 23.99
$ 16.80
Mastering Machine Learning Algorithms Book Cover
Mastering Machine Learning Algorithms
$ 35.99
$ 25.20
Buy 2 for $34.30
Save $25.68
Add to Cart

Book Details

ISBN 139781847190970
Paperback220 pages

Book Description

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.

Table of Contents

Chapter 1: Working with OOo's Basic IDE
Before We Start
Accessing the OOo IDE
Designing Dialogs with the IDE
Summary
Chapter 2: Libraries, Modules, Subroutines, and Functions
Using Libraries
Using Modules
Writing Macros
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
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
Chapter 4: Using Macros with Spreadsheets
Opening and Closing Spreadsheets
Manipulating Spreadsheet Cells
Named Worksheets and Cells
Working with Multiple Spreadsheets
Using Ranges of Cells
Summary
Chapter 5: 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
Chapter 6: Working with Databases
Accessing Databases
Putting it All into a Spreadsheet
Adding New Records to the Database
Updating the Database
Summary
Chapter 7: Working with Other Documents
The OpenOffice.org Chart
Using Documents from Other Sources
Processing Web Pages
Summary
Chapter 8: Developing Dialogs
Using OpenOffice.org's Built-In Dialogs
Developing your Own Dialogs
Finding Further Information
Summary
Chapter 9: 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
Chapter 10: 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

What You Will Learn

  • How to create custom Calc applications
  • Creating worksheet functions, automating repetitive tasks, creating new toolbars, menus, and dialog boxes
  • A complete guide to the  IDE, language, and object model
  • Integrating Calc applications with other components of OpenOffice.org
  • Internet-based collaborative applications
  • How to understand, use and adapt the increasing number of freely available Calc Macros

Authors

Table of Contents

Chapter 1: Working with OOo's Basic IDE
Before We Start
Accessing the OOo IDE
Designing Dialogs with the IDE
Summary
Chapter 2: Libraries, Modules, Subroutines, and Functions
Using Libraries
Using Modules
Writing Macros
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
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
Chapter 4: Using Macros with Spreadsheets
Opening and Closing Spreadsheets
Manipulating Spreadsheet Cells
Named Worksheets and Cells
Working with Multiple Spreadsheets
Using Ranges of Cells
Summary
Chapter 5: 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
Chapter 6: Working with Databases
Accessing Databases
Putting it All into a Spreadsheet
Adding New Records to the Database
Updating the Database
Summary
Chapter 7: Working with Other Documents
The OpenOffice.org Chart
Using Documents from Other Sources
Processing Web Pages
Summary
Chapter 8: Developing Dialogs
Using OpenOffice.org's Built-In Dialogs
Developing your Own Dialogs
Finding Further Information
Summary
Chapter 9: 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
Chapter 10: 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

Book Details

ISBN 139781847190970
Paperback220 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Google Apps: Mastering Integration and Customization     Book Cover
Google Apps: Mastering Integration and Customization
$ 23.99
$ 16.80
Inkscape Beginner’s Guide Book Cover
Inkscape Beginner’s Guide
$ 23.99
$ 16.80
Blender 3D Architecture, Buildings, and Scenery Book Cover
Blender 3D Architecture, Buildings, and Scenery
$ 26.99
$ 18.90
Mastering OpenLDAP: Configuring, Securing and Integrating Directory Services Book Cover
Mastering OpenLDAP: Configuring, Securing and Integrating Directory Services
$ 29.99
$ 21.00
GIMP 2.6 cookbook Book Cover
GIMP 2.6 cookbook
$ 26.99
$ 18.90
Scribus 1.3.5: Beginner's Guide Book Cover
Scribus 1.3.5: Beginner's Guide
$ 23.99
$ 16.80