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>
Table of Contents (15 chapters)
Learn OpenOffice.org Spreadsheet Macro Programming
Credits
About the Author
About the Reviewer
Preface

About the Author

Dr. Mark Alexander Bain hasn't always been the leading authority on open‑source software that you know him as now. Back in the late seventies he started work as a woodsman at Bowood Estates in Wiltshire. After that he spent a number of years working at Lowther Wildlife Park in Cumbria—it's not clear if his character made him suitable for looking after packs of wolves, or whether the experience made him the way he is now.

In the mid eighties there was a general downturn in the popularity of animal parks in the UK, and Mark found himself out of work with two young sons (Simon and Michael) but with a growing interest in programming. His wife had recently bought him the state-of-the-art Sinclair ZX 81, and it was she who suggested that he went to college to study computing.

Mark left college in 1989 and joined Vodafone—then a very small company—where he started writing programs using VAX/VMS. It was shortly after that, that he became addicted to something that was to drastically affect the rest of his life—Unix. His demise was further compounded when he was introduced to Oracle. After that there was no saving him. Over the next few years, Vodafone became the multinational company that it is now, and Mark progressed from Technician to Engineer, and from Engineer to Senior Engineer, and finally to Principal Engineer.

At the turn of the century, general ill health made Mark reconsider his career; and his wife again came to his rescue when she saw a job advert for a lecturer at the University of Central Lancashire. It was also she who suggested that he should think about writing.

Today Mark writes regularly for Linux Format, Newsforge.com, and Linux Journal. He's still teaching. And (apparently) he writes books as well.