Jerry Feldman wrote:
<<SNIP>>
On Tue, 15 Jul 2008 14:58:30 -0400
James Knott <[EMAIL PROTECTED]> wrote:
I just had an interesting problem. I have a time sheet I fill out
biweekly and fax to my agency. I added a couple of features to make it
more automatic, specifically I have a date field (formatted as date
12/31/99) with the formula =DATE(F4;B4;D4). B4 is 7, D4 is 25, and F4
is 2008. On Excel, this field displays 7/25/08, but on OpenOffice 2.4.1
(winXP) is displays 7/25/00. (actually it is user defined). If I set the
format to 12/31/1999 (or other 4 digit formats, it comes out as year
2000. I'll probably have to submit this as a bug, but I want to check
this on the Linux version first). However, in the past, I totally
switched my home to OpenOffice (in preference to MS Office 2000 via
WINE) and everything is the way I want it. At my former workplace at
HP, we did several white papers and manuals with OpenOffice even using
HP's special templates.
<<SNIP>>
If you can attach the Calc spreadsheet I will take a look at it and
attempt to either confirm the bug or discover why it is displaying the
wrong date.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
