In OpenOffice Spreadsheet, how can I set the default Date format?

Posted by Joe Casadonte on Super User See other posts from Super User or by Joe Casadonte
Published on 2010-02-04T15:20:07Z Indexed on 2010/03/08 18:08 UTC
Read the original article Hit count: 196

Filed under:

ubuntu-9.10

I'm using OO 3.1.1 on Ubuntu 9.10 (in case that matters to the answer).

I like my dates to appear as YYYY-MM-DD. I can't think of a time when I want to see a date in any other format, so I'm constantly changing how dates look. That's manageable, though annoying. What's gotten me to the point of posting is that when I edit a cell with a date value, I have to edit it in the format MM/DD/YYYY, which is really, really annoying, as I'm usually mucking with the day (or possibly the month), and very seldom the year. So there's lots of cursor or mouse use, wasting my time.

So is there a way that I can change how dates are edited, or at least the default display format? Thanks!

Related posts about open-office

Install OpenOffice for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOffice headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
apt-get is broken

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I Cannot install any package in the server, As I am newbie in Server. In Morning I found that some, I am not able to install any package from command line in the server,Now every package is now manually downloaded packages and then installed in the server. Can any one Please tell me what is the issue… >>> More
How to recover dpkg from corrupted downloads?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just upgraded to the 10.10 RC earlier and had a few problems with graphic drivers (x didnt start) But i have remedied that now. When i run 'sudo apt-get install -f' i get this: will@UbuntuBox:/mnt/slax$ sudo apt-get install -f [sudo] password for will: Reading package lists... Done Building dependency… >>> More
Problem with running open office from the command line

as seen on Super User - Search for 'Super User'
Yesterday I installed OpenOffice on my Linux server. But when I go to run it through the command line, it says command cannot be found. I've also tried other things like OOWriter, etc. Has anyone had this problem? Installation process went like below: root@aserver [OOO330_m20_native_packed-1_en-US… >>> More
Rotate image with open office 3.2

as seen on Super User - Search for 'Super User'
I import a picture into an open office document from file. However, I cannot figure out how to rotate image in open office 3.2 writer. Is there any way to do that? >>> More

Developer IT