You may well be here because you need help with OpenOffice, and if that’s the case, then please feel free to drop a comment to let me know what pressing issues you face, however sometimes you need the help of many – and that’s one of the benefits of Open Source Software.

OpenOffice.org Forums [...]

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 [...]