OpenOffice Calc bug?

[James Wilkinson]

Brian Mury wrote:
> I am using OpenOffice 1.1.1 that was installed along with FC2. I have a
> spreadsheet with a bunch of dates in one of the columns. I cannot get it
> to recognize 7 April 2002 as a date. All other dates are fine. Does
> anyone else see this? Is there a solution?

Clint Harshaw wrote:
> I can confirm the symptoms on mine -- OO isn't recognizing 4/7/02 as a 
> "date" format. When I enter 4/7/02, OO sees it as text, and left 
> justifies it. When I enter 4/6/02, OO right justifies it and inserts 
> "filler" zeros:
> 
> 4/7/02
> 04/06/02

For what it's worth, I've got an up-to-date FC2 with OOo 1.1.1, and I
*can't* reproduce it. Of course, my OOo thinks that 4/7/02 is the Fourth
of July. But even if I change my language settings to the US, it still
works perfectly.

And yes, I have tried both April 7 and July 4.

James.

-- 
E-mail address: james | "She was good at playing abstract confusion in the
@westexe.demon.co.uk  | same way a midget is good at being short."
                      |     -- Clive James, about Marilyn Monroe