Peter Hillier-Brook wrote:
Kyle Bowles wrote:
I'm a student at Oregon State University where you may know Open
Office has its server in the Open Source Labs. I just began using
open office since I came to campus and am finding one feature
extremely annoying. I 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 way. 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 date to be kept, but unless I
insert an additional symbol, it is the format Open Office is trying to
inflict upon me. For the sake of people who use different formats
everywhere, open your options to include all the date types windows
supports. Everytime it's changed is another time I feel like I should
just reinstall Microsoft Office. My date format is perfect for my
use, and my company's use. It's also the most intuitive, and its a
big problem if I can't easily insert it. And if I'm having problems
with software, I'm not going to be refering people to it so much.
Thank you for your time. Have a nice day.
What on Earth are you talking about? Have a look at Format>Cells>Numbers
and either use one of the many formats available there, or roll your own!!
Of course, if you are referring to the input line, then it shows the
date in the style of the underlying operating system - which you have
presumably specified - but it appears formatted as you have chosen in
the cell(s).
Peter HB
Peter HB
Peter, the default option for OOo is the issue. It takes the system
info with no chance of overriding. I use Linux and there is no easy way
to change the system date to YYYY.MM.DD. I have tried with no success
for years.
It would be nice to have the option to set a default format in the Tools
> Options for all documents.
Just checking out, there is no way to set the date in the Default Style,
at least in the version of OOo that I am using. At least in Writer.
Nor do I see a way of setting individual default settings in Calc when I
just tried. I ended up screwing up my spreadsheet as changing the
default date changed a lot of data that were not formatted as dates.
I believe that this is already a bug report or enhancement request.
--
Robin Laing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
