OpenOffice.org Training, Tips, and Ideas: Correcting a Small Annoyance: OpenOffice Calc Spreadsheet Cells Don't Wrap By Default, Plus Making a Spreadsheet Template

July 26, 2007

Correcting a Small Annoyance: OpenOffice Calc Spreadsheet Cells Don't Wrap By Default, Plus Making a Spreadsheet Template

Me, I like cell contents to wrap.

This is wrapping.

This is not wrapping.
Notwrapping1

This is more not wrapping.
Notwrapping2

So, wrapping is nice.

You can make cell contents wrap by selecting one, two, five, or all the cells, then choosing Format > Cells, clicking the Alignment tab, and selecting the Wrap Text Automatically option.

But then, when you cut the contents out of a wrapped cell, those wrapping attributes aren't applied any longer. This is a small point but one I find annoying. Look at this first example, where I applied the Wrap formatting to alllll cells in the spreadsheet.

Cut1

Now here I cut out the middle item, paste it to the right, and type in the empty cell. The Wrap formatting left along with the contents.

Cut2

Correcting the Problem
There are a few ways to get around this. Here's one way. Just redefine the cell Default Cell Style to be wrapped.

- Choose Format > Styles and Formatting.
- Right-click on Default and choose Modify.
Wrap1_2

- In the Alignment tab, select Wrap Text Automatically.

- Click OK.

Now forever and ever, for that spreadsheet, all cells will wrap period. (You can overwrite them on a cell by cell basis if you like.)

If you want to set up allllll new spreadsheets to be like this so you don't need to redefine the default style for every new spreadsheet, do this.

- Create a new spreadsheet.
- Define the default style as wrapping as shown in the last set of instructions. Before you click OK, set up any other formatting that you want to always be there by default. For instance, you might want the font to be different.

Or you might want the number format to be always a specific, different format.

- Click OK.

- Choose File > Templates > Save.

- Select the My Templates category (or another if you want) and name the template something obvious.

- Click OK.

- Choose File > Templates > Organize.

- In the left-hand pane, open the category you choose previously when saving the template. Find the template. Right-click on it and choose Set as Default Template.

- Click Close.

Now, when you create a new spreadsheet, it'll be based on that template you created: cells will all wrap, they'll all have the font you wanted, etc.

To go back to the regular way of creating new spreadsheets, just choose File > Templates > Organize again, right-click on the template, choose Reset Default Template > Spreadsheet.