Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation
Formats:
save 50%!
save 41%!
Also available on: |
- 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
Book Details
Language : EnglishPaperback : 220 pages [ 235mm x 191mm ]
Release Date : December 2006
ISBN : 1847190979
ISBN 13 : 9781847190970
Author(s) : Dr Mark Alexander Bain
Topics and Technologies : All Books, Open Source
Table of Contents
Preface
Chapter 1: Working with OOo's Basic IDE
Chapter 2: Libraries, Modules, Subroutines, and Functions
Chapter 3: The OOo Object Model
Chapter 4: Using Macros with Spreadsheets
Chapter 5: Formatting your Spreadsheets
Chapter 6: Working with Databases
Chapter 7: Working with Other Documents
Chapter 8: Developing Dialogs
Chapter 9: Creating a Complete Application
Chapter 10: Using Excel VBA
Index
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
Code Downloads
Download the code and support files for this book.
Errata
- 1 submitted: last submission 09 Jan 2012page 13 | Typo | 01 Apr 09 |
page 52 | Technical | 01 Apr 09 |
Submit Errata
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
What you will learn from this book
- 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
Special Offers
Annual subscription:
€150.00 per annum
Monthly subscription:
€14.99 per month
Buy any two eBooks and get 50% off
Add any two eBooks to your cart, and 50% will be taken off their total price
+Simply click below to add these two eBooks to your cart
View our bestselling Open Source bundles
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.
Approach
A fast, fun, and friendly tutorial. Full of practical, step-by-step examples and clear explanations of all of the important concepts.
Who this book is for
You don’t need to be a programmer to use this book, but you do need to be familiar with the concept of a program and how simple things like a loop might work. If all you have is a taster of simple programs from high school then you will be fine.