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.

Highlight text

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

Format Painter

3. When the mouse looks like a paint bucket, highlight the text to which you want to apply the format.

Highlight target text

4. Let the mouse button go and the format will be applied to that section of text.

Apply format

Related posts:

  1. Changing Units of Measure in OpenOffice [inches to cm] Living in a metric society, it is much more convenient...
  2. Random Number Generator [Calc] A friend of mine is familiar with working in Lotus...

Related posts brought to you by Yet Another Related Posts Plugin.