O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing the OOo IDE

With our appropriately named Calc spreadsheet open, getting into the IDE (regardless of the OS that you're using) is simple enough:

Start with creating a new Calc document and save it with the name penguin_private_investigators.ods. Next, use Tools | Macros | Organize Macros | OpenOffice.org Basic... to open the Basic IDE.

You'll notice that other than OpenOffice.org Basic, you actually have a choice of three languages in which you can work:

  • Python (a common object-oriented programming language)

  • BeanShell (a Java scripting language)

  • JavaScript (the scripting language behind many web pages)

That's good, because it means ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required