Stop OpenOffice Writer truncating your dates


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.

Author bio and support


Ruben Schade is a technical writer and infrastructure architect in Sydney, Australia who refers to himself in the third person. Hi!

The site is powered by Hugo, FreeBSD, and OpenZFS on OrionVM, everyone’s favourite bespoke cloud infrastructure provider.

If you found this post helpful or entertaining, you can shout me a coffee or send a comment. Thanks ☺️.