OPENOFFICE BASIC MACROS SOFTWARE
OPENOFFICE BASIC MACROS CODE
OPENOFFICE BASIC MACROS WINDOWS

I just mention it, as in a moment I hope you'll find what we're going to do is pretty cool, better than 'mere word-processing.'

I bet you didn't know that your wordprocessor (ooWriter) could create 'computer programs', did you? But as soon as we put our button on the 'page', we will have left behind the 'word-processor as modern typewriter' world. While what we are going to do can be done in almost the same way on an ooCalc spreadsheet, an ooBase form, an ooImpress presentation, for this tutorial we are going to do it on a 'sheet of paper' in ooWriter. The next four sections of this tutorial address each of those in turn. A way to trigger the macro (We'll use an event.).We need several pieces in place before everything will work. When you know more, you'll be ready to start making your own choices. Macros can be stored in various places, not just the place I'm going to recommend here. There are other ways to record one than the one we will use here. A macro is a recorded sequence of instructions. But if I do that, will you promise to read the 'principles' material I've moved elsewhere? They explain things you need to understand to create and use macros.įor our 'Hello World' button, we need a macro. In this essay, however, I will try to keep to the point, and present a 'cook-book' answer. With those principles, you are far better equipped to adapt what I've presented, to meet your needs. I tend in these tutorials to try to teach you the principles behind all that arises. Where the difference is important, you will be told. There are some strong reasons to move to Open Office 3.1 if you want to use macros with ooBase.

OPENOFFICE BASIC MACROS WINDOWS

This tutorial was written using ooBase version 3.0 on Windows XP, but many things should work the same way under other post version 1 OpenOffice installations, and under other operating systems. We will put the button on an ooWriter document, but it could also go on an ooCalc worksheet, or an ooBase form. This tutorial shows how you can put a button on an Open Office page, and arrange for that button to put a 'Hello World' message on the screen.

OPENOFFICE BASIC MACROS SOFTWARE

Page contents © TK Boyd, Sheepdog Software ®, 2/06-3/11. (Enlarge, reduce, restore to default, respectively.) (This is more fully explained, and there's another tip, at my Power Browsing page.) With most browsers, pressing plus, minus or zero while the control key (ctrl) is held down will change the texts size. Make your browser window as wide as you want it. There's more about ooBase in the main index to this material. and saving million$, and still Getting The Job Done. Big organizations, government and civilian, are adopting it as their standard office suite. Remember that Open Office, including ooBase, is free! But don't let that fool you. They are allied with a larger set concentrating on ooBase. This page is one of several trying to help you get the most out of the splendid Open Office. Bookmark on Delicious Recommend to StumbleUpon Open Office Tutorials Such tools give a list of all properties and methods available for an object, and since the list is flat, there is less need to dig into the interface of an inherited interface of another interface and so on.TABLE OF CONTENTS for Open Office database tutorials.

OPENOFFICE BASIC MACROS CODE

Andrew Pitonyak's macro document contains a set of examples that cover many needs, and searching in Google will bring up example code from sites such as .Īlso, an introspection tool such as XrayTool or MRI is essential. Before trying that, it's better to search for example code. Searching through the API documentation is not easy.

Both of these properties are members of oDoc when writing in Basic or Python. Similarly, the method XDocumentSupplier.getDocumentProperties() gets a shortcut property DocumentProperties. So, the method XSpreadsheetDocument.getSheets() gets a shortcut property Sheets. For one thing, they do not need queryInterface to get a specific object, because they don't care about the type.Īnother shortcut is that they provide properties that can be used as alternatives to the method of a particular interface. Now, languages that are less strict than Java, such as Basic and Python, have various shortcuts to work with UNO. In short, there is no Sheets in Java, so Sheets must not be part of the UNO API.

Nor is there any property named Sheets in the property set. Using code like this, we can verify that getSheets() works in Java, but Sheets() does not. XPropertySet propSet = (XPropertySet)UnoRuntime.queryInterface( XSpreadsheets xSpreadsheets = xSpreadSheetDocument.getSheets() XSpreadsheetDocument xSpreadSheetDocument = UnoRuntime.queryInterface( Here is some code that you don't need to read, but I show it here because the results will be helpful. To really understand the UNO API, it's best to use Java. Sheets can be obtained by name, index or enumeration through the interface .XSpreadsheetDocument.

Openoffice basic macros