Kyle wrote:
personally like to write my dates yyyy.mm.dd however, as you may know
Open Office Calc is VERY picky about them being one way and ONLY one
That "pickyness" is because OOo is style dependent. Everything in OOo
revolves around styles, and if you don't grok styles, you wont' be able
to use OOo successfully. OTOH, once you grok styles, you'll wonder how
you survived without them.
Even Microsoft Office has more date options that really do work.
Whenever I happen to write a date, I have my date changed, to the format
mm/dd/yy not only is this one of the worst, most illogical ways for a
That happens because you:
* Selected the default locale to be English(USA)
and
* Did not change the default date format in your cell styles to
something more logical.
Go into your default calc template, and change the default date format
to the one that you want.
who use different formats everywhere, open your options to include all
the date types windows supports.
The last time I counted, OOo supported five different calender systems,
and about 35 different formats for entering dates in those calender
systems. IOW, it covers the same date formats, and calender systems as
windows covers.
Everytime it's changed is another time
There are two known time issues with OOo & calenders.
It does not correctly calculate the start of the day for either the
Jewish Calender, or the traditional African (Swahili) calender.
Other than miscalculating the date of Easter, it works correctly with
both the standard Julian Calender, and standard Gregorian Calender.
[I'd file an issue here, but it gets into theology, and the feast of the
Apostles.
and its a big problem if I can't easily insert it. And if I'm having
Spend a couple of hours learning about styles, and how to use them. The
issue here is that you configured styles for one date format, and want
to use a different date format.
xan
jonathon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]