On Wed, 13 Oct 2004, dale wrote: > 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? > > Brian, > I have confirmed this bug exists on OO.o 1.1.1 in FC2. Also, OO.o > 1.1.2 in WinXP works as expected. > > Thanks, > > Dale I could have sworn swear this was a known bug, but I don't see a reference to it in Red Hat's bugzilla. I think it's this one (or one of the related ones) upstream: http://www.openoffice.org/issues/show_bug.cgi?id=24082 The above is reported as fixed in 1.1.2. To forestall a bunch of "works for me", "doesn't work for me" posts, yes it works for some people and not for others. (Doesn't work for me.) It seems to be related to timezone/daylight time issues. -- Matthew Saltzman Clemson University Math Sciences mjs AT clemson DOT edu http://www.math.clemson.edu/~mjs