| |
| |
|
|
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
|
|
|
Code download
Request a Review Copy
Send us feedback on this title
Ask a question about this title
Download Chapter 6:
Working with Databases[790 KB]
Language English
Paperback 220 pages [191mm x 235mm]
Release date
December 2006
ISBN 1847190979
ISBN 13 978-1-847190-97-0
Author(s)
Dr Mark Alexander Bain
Topics and Technologies
Open Source
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.
Special eBook Discount Offer |
 | + |  | Buy Learn OpenOffice.org Spreadsheet Macro Programming with Linux Email and get 40% off your order! Add both eBooks to your cart and the discount will be applied. |
|
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.
- 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
A fast, fun, and friendly tutorial. Full of practical, step-by-step examples and clear explanations of all of the important concepts.
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.
Dr Mark Alexander Bain
Dr. Mark Alexander Bain first started customizing CRM systems back in the mid '90s when he was team leader for Vodafone's Cascade project – the team took the 'out-of-the-box' Clarify CRM and turned it into a radio base station planning application, complete with a workflow engine for passing jobs between the different departments involved in the planning, building, and implementation of a radio network.
Since then he's lectured at the University of Central Lancashire, and currently Mark writes articles on all things Linux and Open Source for Linux Format, Newsforge.com and Linux Journal. SugarCRM customization, therefore, seems the obvious choice for this, his second book, since it combines Mark's knowledge of working with commercial CRMs and the Open Source philosophy.
Mark works from his home on the edge of the Lake District in the UK, where he lives with his wife, two dogs and two cats, and gets the odd visit from his sons – Michael and Simon.
| |
|
