Yes there is and it can be applied in most of the OpenOffice applications. I am demonstrating it in Writer below, however the same steps are applied to cells in Calc.

1. Highlight the area from which you wish to copy the format from.

2. Click on the format painter icon in the toolbar.

3. When the mouse [...]

OpenOffice.org doesn”t natively support the SVG graphics format, which can be an inconvenience, especially considering how many good vector-based images are available in the Open Clip Art Library.

The SVG Import filter adds support for the SVG format, so you can easily open vector-based graphics directly in OpenOffice.org. According to the author, the filter [...]

‘For those that need to convert documents from images and graphics into text, you may find ScanR a very useful tool.

It allows you to email JPG documents to their site, and uses OCR (Optical Character Recognition) to transform the picture into a text document that you [...]

I can”t say it better than the Open Office team, so:

Introducing new functionality with OpenOffice.org 2.3!
OpenOffice.org 2.3 is available for download now! It includes several new features in addition to the usual improvements to stability, performance, Microsoft Office compatibility and Accessibility. Some of the new and exciting features are available as [...]