Use the OpenOffice.org template package to save time and professional "look and feel" of templates ensure output is noticed and read. Each template makes creating personalised and individual OpenOffice.org documents a breeze with built-in images and text styles. All you need to do is to add your own content.
More than 80 templates for OpenOffice.org Writer, Calc, Draw and Impress

EuroOffice Online Clipart allows you to quickly add free images from the Wikimedia Commons collection to your text documents in OpenOffice.org Writer. OpenOffice.org Impress and Draw documents are not supported directly at the moment, but there is a workaround to solve this problem: You are able to copy-paste the inserted images from text documents into presentations or drawings.

This is an extension for Draw. This extension draws patterns of shapes, grouped objects and bitmap pictures, rotating and scaling them, and, if possible, changing fillcolors and linecolors. You draw a few shapes or paste it from somewhere, select them with mouse and then go to Tools-->Add-ons menu in OpenOffice.org Draw.

NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard. MONEYTEXT is functionally top-compliant with the ECMA/ISO standard BAHTTEXT function.

Barcode is a simple extension for creating UPC-A, EAN-13, ISBN and JAN barcodes in OpenOffice.org Draw.

Allows to change the picture of an existing image in a document. It mimics a function of MS Word 2007 which is only available when working with docx documents.
http://www.youtube.com/watch?v=Qzryfx2GveY
http://www.oooforum.org/forum/viewtopic.phtml?t=91059&highlight=

Additional instructions

This extension generates a data input form for tables in calc, reproducing the Data - Form feature of Microsoft Office Excel.

Installation
Double-click on the extension file and follow the instructions.
After installation close both OpenOffice.org and the Quickstarter (the icon in the traybar), and start OpenOffice.org again.

The Switchboard extension generates a Switchboard/Main Menu interface to access Base forms and reports. The switchboard can be grouped into categories, each of which can contain any number of menu entries. Furthermore, you can specify the size and screen location of the form to be opened.

The generators creates three database objects.

You can organize your important family dates and contact information with this database. It can produce a list of upcoming birthdays & anniversaries, print address labels, store miscellaneous family information, and export the contact information to PDA. If you are new to OpenOffice Base, this can serve as an introduction.

Unzip or extract this download before use.

This very simple extension allows you to view and change the background color of cells (Calc) , shapes (draw Writer). Now working with the background color of text and paragraphs (Writer) . In all these cases, on the active selection.