When you’re have a report due, the last thing you want OpenOffice Writer doing is maddeningly truncating your dates in tables like it’s 1999. Fortunately, after a cup of tea I realised table cells in Writer behave the same way as spreadsheet cells in Calc. By which I mean, the documentation said so.

To fix:

  1. Click on the offending 02/09/13 cell
  2. Choose “Number format…” from the Table menu
  3. Choose “31/12/1999″ from the Format listbox

I’m assuming this would work for LibreOffice too.