Warning: The contents of these pages are likely covered by patents, which would make your use of this information illegal. As existing software patents already cover the most trivial and obvious ideas, it is impossible for us to avoid using patented techniques! Chances are good that your business is already infringing and open to litigious attack. Please visit NoSoftwarePatents.com for more information.
This is a collection of examples and information related to the use of
OpenOffice (as we've been using it at least). It will grow slowly as we
need to do new things, but for now we'll start with some basic macro
scripting -- which if you've tried this before you probably went insane.
- Calc - Macro Basics
- The basics of working with macros / starbasic in OpenOffice.
- Calc - Macro - Retrieving a Defined Name
- An example which shows how to obtain the value associated with a defined name in the spreadsheet. It also demonstates some basic error handling.
- Calc - Array Basics
- The basics of working with arraus in OpenOffice basic.
- Calc - Usings arrays/range of values
- Demonstates how to receive ranges of values into a Macro, and how to pass ranges of values out of a macro.
- Calc - Macro - Data Manipulation
- Shows how to work more with the data in the spreadsheet via the macros. Does some simple filtering and then extraction from a set of data.
- Calc - Sheets
- Some examples of how to copy data between sheets and to move from one sheet to the next. Includes getting the current selection.
- Write - Revert Number Styles
- An example of how to revert the numbering styles for a paragraph to the default specified in the paragraph style.
Feel free to contact me if you need a different example, or some help. I can't make any promises, but I can try and find out what you need to do.