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

A fast and friendly tutorial to writing macros and spreadsheet applications

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

Dr Mark Alexander Bain

2 customer reviews
A fast and friendly tutorial to writing macros and spreadsheet applications
Packt Subscription
$5.00
$9.99/m after first month
eBook
$5.00
RRP $23.99
Save 79%
Print + eBook
$39.99
RRP $39.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
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 subscription 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 subscription 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 subscription reader
$5.00
$5.00
$39.99
$9.99/m after first month
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Subscribe Now

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
$ 5.00
Cloning Internet Applications with Ruby Book Cover
Cloning Internet Applications with Ruby
$ 23.99
$ 5.00
Buy 2 for $10.00
Save $37.98
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

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

Book Details

ISBN 139781847190970
Paperback220 pages
Read More
From 2 reviews

Read More Reviews

Recommended for You

Cloning Internet Applications with Ruby Book Cover
Cloning Internet Applications with Ruby
$ 23.99
$ 5.00
UML 2.0 in Action: A project-based tutorial  Book Cover
UML 2.0 in Action: A project-based tutorial
$ 20.99
$ 5.00
Blender 2.49 Scripting Book Cover
Blender 2.49 Scripting
$ 23.99
$ 5.00
Scribus 1.3.5: Beginner's Guide Book Cover
Scribus 1.3.5: Beginner's Guide
$ 23.99
$ 5.00
Blender Game Engine: Beginner's Guide Book Cover
Blender Game Engine: Beginner's Guide
$ 23.99
$ 5.00
ImageMagick Tricks Book Cover
ImageMagick Tricks
$ 20.99
$ 2.10