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)
That's good, because it means ...