Add On Installer
Author: Didier Lachièze, with code from Danny Brewer, Bernard Marcelly and Andrew Brown
This is an installer for OOo add-ons. It is designed to be generic, allowing easy installation of Basic macros for the end-user. Customisation is done by editing a spreadsheet.
Latest release: December 21, 2003
Download Add On Installer
Top of page
Add On Tool
Author: Bernard Marcelly
This Writer document explains how to create and install OOo add-ons, and includes an interactive tool (written in OOo Basic) that creates the .xcu file required. The xcu file is complex, and difficult to write by hand, so this tool makes the creation of add-ons much simpler.
The macro tool within the document is released under the LGPL. The instruction document is released under the Public Documentation License version 1.0
Latest release: Version 1.1 (November 20, 2003)
Download Add On Tool
Top of page
Andrew Pitonyak's Macro Document
Author: Andrew Pitonyak
An excellent reference, in OpenDocument (.odt) and PDF formats. This document is over 300 pages long, and includes many examples.
Andrew has also written a book, OpenOffice.org Macros Explained
Released under the Public Documentation License Version 1.0
Latest release: January 25th, 2006
Download Andrew Pitonyak's Macro Document
Top of page
Basic Library Installer
Author: Danny Brewer, with code from Andrew Brown & Didier Lachièze
This is a set of libraries and routines that will allow macro developers to make easily-installed add-ins. For more information, see this thread on OOoForum.
Note that this code is still in a very early stage of development, and so could be very buggy.
Latest release: December 8, 2003
Download Basic Library Installer
Top of page
Calc Macro Recorder
Author: Paolo Mantovani
This is a macro recorder for OOo Calc, that produces API-based code, rather than the dispatcher-based code produced by the built-in macro recorder.
The code produced is clean enough that it could be used as a useful tool for anyone starting to learn how to program OOo in Basic. Note that this macro will not work in OOo 1.0.x
Latest release: December 16, 2003
Download Calc Macro Recorder
Top of page
Clueless Crossword Solver
Author:
This is a macro to solve clueless crosswords. A sample clueless crossword puzzle is included, complete with a starting letter and solution.
The author wrote this set of macros as an exercise in learning how to use macros in OOo Calc, and so it may be of use to others wishing to learn how to write Calc macros.
This file is released under the GNU GPL
Latest release: April 11, 2004
Download Clueless Crossword Solver
Top of page
Danny Brewer's Examples
Author: Danny Brewer
Various example macros, most of which were written in response to questions asked on OOoForum.
Latest release: June 3, 2004
Download Danny Brewer's Examples
Top of page
Danny's DataGen Tools
Author: Danny Brewer
This is a library of routines that generate somewhat realistic looking test data. This is useful when you need to populate database tables or spreadsheets with somewhat realistic looking data.
Latest release: July 20, 2004
Download Danny's DataGen Tools
Top of page
Danny's Draw Power Tools
Author: Danny Brewer
This is a collection of tools for OOo Draw, written in StarBasic. The tools are accessed by opening up a draw document which contains a control panel of buttons. Each button activates a different tool. Clicking a button brings up a dialog box allowing you to configure how you wish to use the tool. From the tool's dialog box, you can click the Create button, and the tool creates a new drawing of the shape you defined.
The following tools are included in the package:
- Star/Polygon is a tool for creating stars and/or polygons
- Star Outline creates outline star shapes (different to those created by Star/Polygon)
- Flower Gears creates beautiful, complex shapes, such as the one shown above
- Color Wheel creates a wheel of colour. Possibilities include bullseye-type targets, and wheels similar to radar displays
- Squares/Checkerboard draws squares in a regular repeating pattern
- Rulers creates straight rulers, linear dials, or sliding volume controls
- Dials creates round dials, meters, clock faces and similar shapes
- Calendar Maker creates single or multi page calendars
- Understanding HSB Color explains HSB color notation
Documentation for each tool is included in the package.
Latest release: August 9, 2003
Download Danny's Draw Power Tools
Top of page
Danny's Library
Author: Danny Brewer
This is a set of libraries that are frequently used by the author, with examples that show how they are used.
Latest release: January 30, 2004
Download Danny's Library
Top of page
Danny's Stupid OOo Tricks
Author: Danny Brewer
This package includes several macros that are not especially useful, but help to demonstrate how to do things, and show that OOo can be used as a development environment.
Included are working clocks (digital and analogue), bouncing balls, and a working calculator
Latest release: January 28, 2004
Download Danny's Stupid OOo Tricks
Top of page
Delphi OOo
Author: Bernard Marcelly
This is a toolbox to help programmers drive the application OpenOffice.org from the programming language Delphi using COM Automation technology. It contains:
- A unit with routines similar to some OpenOffice.org Basic routines used to access API,
- A unit which defines all API constants and enumerations
- A Delphi version of the Xray tool
- Typical programming examples and all source code
- A HowTo describing the toolbox
The source code included in the package is released under the LGPL. The instruction document is released under the Public Documentation License version 1.0
Latest release: Version 1.2 (August 1, 2007)
Download Delphi OOo
Top of page
Document Explorer
Author: Danny Brewer
This Java program allows you to explore the contents of OOo documents. The program displays a tree
view of the file contents, and allows the user to explore the nodes of the XML trees. Full
documentation, including an explanation of how to read the OOo XML files from a Java program, is
included in the .zip file.
Latest release: August 2, 2003
Download Document Explorer
Top of page
Duplicate Shape
Author: Danny Brewer
This installs four new drawing commands into the office. The four commands duplicate the currently selected drawing shape, and then slide the new shape up, down, right or left such that it just touches the original shape.
The commands can be installed as....
- A single Add On menu item containing four sub menu items.
- Four menu items directly on the Add On menu.
- A new top level menu item in the menu bar with four commands.
- Four toolbar items
Removing this from the office, i.e. uninstalling, is as easy as clicking a button.
Latest release: April 16, 2004
Download Duplicate Shape
Top of page
Dynamic UKIYO-E Prints
Author: Kazutaka Kisi
This is based on ukiyo-e prints that are a traditional art in Japan since Edo era.
I adopted techniques as follows:
- - OO Basic
- - UNO
- - LineShape
- - ClosedBezierShape
- - GraphicObjectShape
- - GradientStyle
- - Graphic Layer
- - GIF89a format
Latest release: Version 0.5 (September 24, 2007)
Download Dynamic UKIYO-E Prints
Top of page
Maze Builder
Author: Danny Brewer
This is a Java maze generator for OOo Draw. When the program is run, a dialog box appears. Fill out
some parameters, such as maze complexity, number of pages you want in the final drawing, etc. Click
the 'Generate' button, and a running copy of OOo creates a new drawing of a maze. Full documentation
is included in the .zip file.
Latest release: June 11, 2003
Download Maze Builder
Top of page
OOo FBTools
Author: Vadim Kuznetsov & Jegors Cemisovs
Tools to prepare e-books in open FictionBook format.
Released under the GNU General Public License v2
Installation instructions (in Russian) included
User Manual (in Russian) included
Home page: http://code.google.com/p/ooofbtools/
Latest release: Version 1.0.2 (July 20, 2008)
Download OOo FBTools
Top of page
OOoXMLFiltersInstaller
Author: Kazutaka Kisi
OOoXMLFiltersInstaller is an installer for OOo XML filters.
This is designed for an end user to be able to easily install an OOo XML filter.
This tool is based on self-descriptive comment declaration (the
description that resembled javadoc) in the XML filter and registers the filter.
Licence: The OOo Basic macro included in this drawing document is released under the LGPL.
Implementation: OpenOffice ver.3 under MS Windows 2000/XP/Vista or MacOSX.
Latest release: Version 0.5 (July 23, 2008)
Download OOoXMLFiltersInstaller
Top of page
Open Source Licences
Author: various
Open source licences, formatted as OOo files, for distribution with macros. Currently only the GNU FDL & GPL are available.
Latest release: GNU GPL 2.0 (April 28, 2004)
Download Open Source Licences
Top of page
Random Drawings
Author: Danny Brewer
This file has several Draw documents, each of which creates a new Draw document filled with random drawings. One creates flowers, another creates Christmas trees (with or without lights) and a third creates 100 hearts.
Latest release: January 2, 2004
Download Random Drawings
Top of page
Turtle Graphics Tutorial
Author: Danny Brewer
A document describing how to use Turtle Graphics routines in OOo Basic to create graphics in OOo Draw. Includes the routines and a tutorial on how to use them.
Latest release: July 19, 2003
Download Turtle Graphics Tutorial
Top of page
UNO & C++
Author: Serge Moutou
The goal of this document is to provide an accessible introduction to UNO programming using C++
Latest release: February 10, 2005
Download UNO & C++
Top of page
UNO Connection Listener
Author: Danny Brewer
In order to program OOo in Java or Python, OOo has to be set up to listen for connections. This macro uses the Configuration Manager API to make OOo listen for connections.
This macro is useful in several ways...
1. A quick easy way to change a hidden configuration aspect of OOo that is not brought out in any of OOo's User Interface.
2. A programming example of using the configuration manager.
and perhaps most importantly...
3. A document that you can distribute with a Java or Python program that makes it easy for an end user to make this difficult configuration change to their OOo
Latest release: March 12, 2004
Download UNO Connection Listener
Top of page
VBx OOo
Author: Bernard Marcelly
This Package contains 3 VB-like toolboxes:
- VBA_OOo for VBA (or VB6)
- VB_OOo for VB.NET
- VBS_OOo for VBScript
These 3 toolboxes help programmers drive the application OpenOffice.org from a VB-like programming language using COM Automation technology.
Each toolbox contains:
- A module with routines similar to the OpenOffice.org Basic routines used to access API. With it you may use the well-known X-Ray tool from your language.
- A module which defines all API constants and enumerations
- A module with several programming examples
- A HowTo giving all necessary explanations
The source code included in the package is released under the LGPL. The instruction document is released under the Public Documentation License version 1.0
Latest release: Version 1.0 (August 1, 2007)
Download VBx OOo
Top of page
Visual FoxPro Examples
Author: Danny Brewer
Some useful code to show how to create drawings in OOo from Microsoft Visual FoxPro
Latest release: May 28, 2003
Download Visual FoxPro Examples
Top of page
Worksheet Maker
Author: Chip Quoos
Worksheet Maker is designed to generate documents that are styled as either homework assignments, or quizzes, or tests. Each worksheet generated is unique, insofar as random numbers are used for each selected problem. Worksheet Maker will optionally also generate an answer key document for the worksheet(s).
Works by default with OpenOffice 1.1.3, and instructions are included for using the macro with OpenOffice 2.0.2.
This macro is intended for both End-Users and Developers.
Latest release: Version 1.0 (August 3, 2006)
Download Worksheet Maker
Top of page
X - Ray Tool
Author: Bernard Marcelly
This is a tool that allows OOo Basic programmers to display the properties, methods, services and interfaces provided by an object. Values of properties can be displayed, and if the property or interface is an API object, it can also be analysed by X-Ray.
If the SDK is installed, X-Ray can display the relevant page in a web browser.
The macro libraries within the document are released under the LGPL. The instruction document is released under the Public Documentation License version 1.0
Latest release: Version 5.2 (December 8, 2006)
Download X - Ray Tool
Top of page
| 
