Book Image

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

By : Dr Mark Alexander Bain
Book Image

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

By: Dr Mark Alexander Bain

Overview of this book

<p>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.<br /><br />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.<br /><br />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.</p>

Related Content you might be interested in

Current Title:

Small book image
Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation
Dr Mark Alexander Bain
Dec, 2006 | 220 pages
No titles found
Table of Contents (15 chapters)
Learn OpenOffice.org Spreadsheet Macro Programming
Learn OpenOffice.org Spreadsheet Macro Programming
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Working with OOo's Basic IDE
Working with OOo's Basic IDE
Before We Start
Accessing the OOo IDE
Designing Dialogs with the IDE
Summary
2
Libraries, Modules, Subroutines, and Functions
Libraries, Modules, Subroutines, and Functions
Using Libraries
Using Modules
Writing Macros
Getting more Information
Subroutines and Functions in Different Libraries
Summary
3
The OOo Object Model
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
4
Using Macros with Spreadsheets
Using Macros with Spreadsheets
Opening and Closing Spreadsheets
Manipulating Spreadsheet Cells
Named Worksheets and Cells
Working with Multiple Spreadsheets
Using Ranges of Cells
Summary
5
Formatting your Spreadsheets
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
6
Working with Databases
Working with Databases
Accessing Databases
Putting it All into a Spreadsheet
Adding New Records to the Database
Updating the Database
Summary
7
Working with Other Documents
Working with Other Documents
The OpenOffice.org Chart
Using Documents from Other Sources
Processing Web Pages
Summary
8
Developing Dialogs
Developing Dialogs
Using OpenOffice.org's Built-In Dialogs
Developing your Own Dialogs
Finding Further Information
Summary
9
Creating a Complete Application
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
10
Using Excel VBA
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

Learn OpenOffice.org Spreadsheet Macro Programming

OOoBasic and Calc Automation

Copyright © 2006 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, Packt Publishing, nor its dealers or distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: December 2006

Production Reference: 1041206

Published by Packt Publishing Ltd. 32 Lincoln Road Olton Birmingham, B27 6PA, UK.

ISBN 10: 1-84719-097-9

ISBN 13: 978-1-847190-97-0

www.packtpub.com

Cover Image by www.visionwt.com

Previous Section
Next Chapter