5/31/2010

Fixing Open Office Writer auto-"corrected" date

Open Office Writer is the the word processor in the free, open-source OpenOffice.org Productivity Suite. OOo Writer shares some "features" with Microsoft Office Word, including, unfortunately, automatic "corrections" that are a bit tricky to disable. Open Office developers should really fix this! By default, all auto corrections should be off (disabled). Users who want  auto corrections could enable them selectively.

Currently, you can disable most automatic corrections according to How to Set Up Open Office Writer for Easy Use. However, even after you think you have turned off all automatic corrections, there are still a few active mines waiting for you to step on them. For example, today, while creating a table in Open Office Writer, I came upon a NASTY glich, bug, problem, and royal pain. To sort by dates across multiple years, I needed to enter dates as yyyy-mm-dd, such as "2009-09-23." Each time I tried this, OOo Writer automatically "corrected" it to "09/23/09," which I did NOT want.

If you have the same problem, do the following:
  1. Select the table column that contains your date fields.
  2. Right-click your date column to display its menu, and then click Number Format to display its window.
  3. In the Category frame, scroll to and select Text, and then click OK to close the Number Format window.
Note: I found the above solution in the Ubuntu forum. (See #8.)

I am a huge fan of Open Office, and I really want to break my M$ addiction, but sometimes I am almost ready to give up.