[users] Date format in template

2010-05-30 Thread James Wilde
I'm using 3.2.0 on a Mac running OSX 10.6.3 I have created a letterhead template which includes the date. When I inserted the date field I got 5/30/10, i.e. the US standard, notwithstandning that my locale is Swedish and my preferred language order in OOo is UK English followed by Swedish.

Re: [users] Date format in template

2010-05-30 Thread Daniel Lewis
James Wilde wrote: I'm using 3.2.0 on a Mac running OSX 10.6.3 I have created a letterhead template which includes the date. When I inserted the date field I got 5/30/10, i.e. the US standard, notwithstandning that my locale is Swedish and my preferred language order in OOo is UK English

Re: [users] Date format in template

2010-05-30 Thread James Wilde
Fantastic, Daniel, thanks! //James On May 30, 2010, at 20:32 , Daniel Lewis wrote: - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Date Format

2009-05-28 Thread Carlos Joel Delgado Pizarrro
2009/5/26 Marko Balokovic marko.baloko...@ymail.com How do I turn off the auto correction of date formats [whenever I write d.m.. (or any other format), I get dd.mm.yy]?. I especially want to turn it off because, in my language, the year should be written with a dot (e.g. 2009., not 2009)

[users] Date Format

2009-05-27 Thread Marko Balokovic
How do I turn off the auto correction of date formats [whenever I write d.m.. (or any other format), I get dd.mm.yy]?. I especially want to turn it off because, in my language, the year should be written with a dot (e.g. 2009., not 2009) and not to say that zeros are totally unnecessary

[users] Date format: filing an issue, avoiding a dupe

2008-12-06 Thread Dotan Cohen
I have a user suffering from the known issue of Calc presenting date formats in American format (mm/dd/) instead of the user-defined format (In my case -mm-dd) when editing cells. I am going through the OOo issue tracker and I am finding tens of date-related issues, but I cannot find this

Re: [users] Date format: filing an issue, avoiding a dupe

2008-12-06 Thread Drew Jensen
I have a user suffering from the known issue of Calc presenting date formats in American format (mm/dd/) hmmm - so where's the problem. LOL Ok seriously. You might want to look at this one: http://qa.openoffice.org/issues/show_bug.cgi?id=58598 Closed as invalid! Maybe you can find a

Re: [users] Date format: filing an issue, avoiding a dupe

2008-12-06 Thread Dotan Cohen
2008/12/6 Drew Jensen [EMAIL PROTECTED]: I have a user suffering from the known issue of Calc presenting date formats in American format (mm/dd/) hmmm - so where's the problem. LOL Ok seriously. You might want to look at this one: http://qa.openoffice.org/issues/show_bug.cgi?id=58598

Re: [users] Date format bug with Open Office Calc

2007-09-22 Thread Cor Nouws
Hi, stevensee schreef: I test OO ver 2.3 today but the problem still persist. Any suggestion? No. But if yours is that issue: keep an eye on it. Currently it is not yet fixed. Regards, Cor -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact

[users] Date format bug with Open Office Calc

2007-09-20 Thread stevensee
Dear Cor Nouws, I test OO ver 2.3 today but the problem still persist. Any suggestion? Original Message Subject: Re:[users] Date format bug with Open Office Calc From: Cor Nouws [EMAIL PROTECTED] To: users@openoffice.org Date: 20/08/2007 15:25 Hi Steven, Steven Lim schreef

Re: [users] [Date Format Default Question] Re: Date format

2007-09-07 Thread LoLo
. LoLo - Original Message - From: NoOp To: users@openoffice.org Sent: Friday, September 07, 2007 2:19 AM Subject: [users] [Date Format Default Question] Re: Date format On 09/06/2007 03:53 AM, LoLo wrote: Hi Can someone please tell me how to change the date format

[users] Date format

2007-09-06 Thread LoLo
Hi Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. Thanks for any help LoLo

Re: [users] Date format

2007-09-06 Thread Brian Barker
At 11:53 06/09/2007 +0100, Loretta Mumble wrote: Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. We are talking about Insert | Fields | Date - right?

Re: [users] Date format

2007-09-06 Thread LoLo
] Date format At 11:53 06/09/2007 +0100, Loretta Mumble wrote: Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. We are talking about Insert | Fields

[users] [Date Format Default Question] Re: Date format

2007-09-06 Thread NoOp
On 09/06/2007 03:53 AM, LoLo wrote: Hi Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. Thanks for any help LoLo In the future it would be

Re: [users] Date format bug with Open Office Calc

2007-08-20 Thread Cor Nouws
Hi Steven, Steven Lim schreef: I'm using the OO 2.2.1 Notice an bug with Calc. When keying in date with format 11-jan-7x. After keying in the date, i click on other fields. When i return to click on the field where i key in this date, the date shown is of another date in the

[users] Date format bug with Open Office Calc

2007-08-19 Thread Steven Lim
Hi. I'm using the OO 2.2.1 Notice an bug with Calc. When keying in date with format 11-jan-7x. After keying in the date, i click on other fields. When i return to click on the field where i key in this date, the date shown is of another date in the early 1970s range but is

Re: [users] Date format bug with Open Office Calc

2007-08-19 Thread Johnny Rosenberg
Works fine in 2.2.0 for Ubuntu 7.04. The date remains the same. J.R. 2007/8/17, Steven Lim [EMAIL PROTECTED]: Hi. I'm using the OO 2.2.1 Notice an bug with Calc. When keying in date with format 11-jan-7x. After keying in the date, i click on other fields. When i return to click

[users] Date format

2007-07-06 Thread Clive Bowley
I'm new to Open Office, and I've opened up an excel file (no macros) one column of which is date formatted to DD/MM/, my problem is that I've inserted a date 26/05/2005 but when I move to the next column or row this date alters to 1 day less ?, ie 25/05/2005 albeit the data input field at

Re: [users] Date format capability of spreadsheet

2007-05-31 Thread Brian Barker
At 14:59 30/05/2007 -0600, William G. Bates wrote: I am a genealogist and have great need of a spreadsheet that will properly display dates before 1900. With the continuing plethora of date related data being prepared for internet display I can see where the need exists for USGENWEB county

[users] Date format capability of spreadsheet

2007-05-30 Thread William G. Bates
I am a genealotist and have great need of a spreadsheet that will properly display dates before 1900. With the continuing plafora of date related data being prepared for internet display I can see where the need exists for USGENWEB county controllers to also have access to a spreadsheet

Re: [users] Date format capability of spreadsheet

2007-05-30 Thread jonathon
William G. Bates wrote: I am a genealotist and have great need of a spreadsheet that will For what you describe a spreadsheet is probably the worst format you can use. [Unless the certainty that you will suffer from random data corruption is acceptable, and provides no problems for you.] the

[users] Date Format Problem

2007-05-21 Thread Louis solomon
I am using version 2.2 of OpenOffice.org. My problem is : how do insert the current date in the format 21 May 2007. I went to Help, and followed the instructions for Inserting a Fixed or Variable Date Field. When I follow the instructions it prints Date(fixed) on my document. This is clearly

Re: [users] Date Format Problem

2007-05-21 Thread Kenn Murrah
are you speaking of Writer? If so, Insert--Fields--Date will get today's date onto the document ... then, if it's not by default in the format you want, right-click on the date and select Fields... and choose the formatting option you want ... On 5/21/07, Louis solomon [EMAIL PROTECTED]

Re: [users] Date Format Problem

2007-05-21 Thread Kenn Murrah
just re-read your question and realized you'll have to go to Fields... and select additional formats and create a custom field by typing DD MMM ... On 5/21/07, Kenn Murrah [EMAIL PROTECTED] wrote: are you speaking of Writer? If so, Insert--Fields--Date will get today's date onto the

Re: [users] Date Format Problem

2007-05-21 Thread Dan Lewis
On Monday May 21 2007 10:19 am, Louis solomon wrote: I am using version 2.2 of OpenOffice.org. My problem is : how do insert the current date in the format 21 May 2007. I went to Help, and followed the instructions for Inserting a Fixed or Variable Date Field. When I follow the instructions

Re: [users] Date Format Problem

2007-05-21 Thread Hagar de l'Est
CTRL+F9 or ViewField Names. Beware, you're not subscribed to the list, you may miss answers. Hagar Le 21.05.2007 17:19, Louis solomon a écrit : I am using version 2.2 of OpenOffice.org. My problem is : how do insert the current date in the format 21 May 2007. I went to Help, and followed

Re: [users] Date Format Problem

2007-05-21 Thread Louis solomon
Thanks for the direction. I am a NEW Mac user, and also a NEW OpenOffice user. I found most of the items, but couldn't get it together. Now, I have entered the format I always want to use for my dates. I checked the green check, and I assume that the program will now always remember the date

Re: [users] Date Format Problem

2007-05-21 Thread Hagar de l'Est
Le 21.05.2007 21:40, Louis solomon a écrit : Now, I have entered the format I always want to use for my dates. I checked the green check, and I assume that the program will now always remember the date format? It depends. Date format is language sensitive (see the Font tab of your paragraph

Re: [users] Date format in Calc

2007-01-03 Thread Alex Zachopoulos
Thanks, people, when I corrected the Language entry in OptionsLanguage SettingsLanguage from Default to Greek, things got alright. BTW, when it was 'Default', I could do what Donald suggested (entering e.g. 13jun7). Now I can't (well, I can, but OOo won't recognize it as date). On Jan

[users] Date format in Calc

2007-01-02 Thread Alex Zachopoulos
I've formatted a column in a Calc .ods file to contain dates in DD/MM/ format. What happens, unfortunately, is that if I enter a date for up to the 12th of any month, Calc formats it as MM/DD/. Example: I want to enter June 13, 2007, so I type in the cell: 13/6/07 or even 13/6.

Re: [users] Date format in Calc

2007-01-02 Thread Dan Lewis
On Tuesday 02 January 2007 2:23 pm, Alex Zachopoulos wrote: I've formatted a column in a Calc .ods file to contain dates in DD/MM/ format. What happens, unfortunately, is that if I enter a date for up to the 12th of any month, Calc formats it as MM/DD/. Example: I want to enter June

Re: [users] Date format in Calc

2007-01-02 Thread Guy Voets
2007/1/2, Alex Zachopoulos [EMAIL PROTECTED]: I've formatted a column in a Calc .ods file to contain dates in DD/MM/ format. What happens, unfortunately, is that if I enter a date for up to the 12th of any month, Calc formats it as MM/DD/. Example: I want to enter June 13, 2007, so I

Re: [users] Date format in Calc

2007-01-02 Thread Donald H Locker
Might I suggest putting dates in as 13 jun 07 (even 13jun7 works,) thereby obviating any ambiguity about which field is the month. I just tried it in 2.1/Solaris10 and it works here. Donald. Dan Lewis wrote: On Tuesday 02 January 2007 2:23 pm, Alex Zachopoulos wrote: I've formatted a

Re: [users] DATE FORMAT IN WRITER

2006-07-30 Thread Royce Faye Green
Thanks Cor; I will try your Styledefault solution next time I use Writer. Regards, Royce G. - Original Message - From: Cor Nouws [EMAIL PROTECTED] To: users@openoffice.org Sent: Sunday, July 30, 2006 8:03 AM Subject: Re: [users] DATE FORMAT IN WRITER Hi Royce, Keith, Royce Faye

Re: [users] DATE FORMAT IN WRITER

2006-07-29 Thread Cor Nouws
Hi Royce, Keith, Royce Faye Green wrote: Thanks Keith; I have just fixed this. Your suggestion did not work in Select All so I selected just the footer changed it from English (US) to (Australia) as you suggested. That solved the situation perfectly. The idea to change the property of

Re: [users] DATE FORMAT IN WRITER

2006-07-26 Thread Royce Faye Green
PROTECTED] To: users@openoffice.org Sent: Tuesday, July 25, 2006 4:29 PM Subject: Re: [users] DATE FORMAT IN WRITER On Tue, 25 Jul 2006 15:50:54 +1000 Royce Faye Green [EMAIL PROTECTED] wrote: I am not a proficient text user; I use spreadsheets 99% of my time, not Text documents. My personal

Re: [users] DATE FORMAT IN WRITER

2006-07-25 Thread Keith Bates
On Tue, 25 Jul 2006 15:50:54 +1000 Royce Faye Green [EMAIL PROTECTED] wrote: I am not a proficient text user; I use spreadsheets 99% of my time, not Text documents. My personal letterhead format (probably converted from MS Word) has a default footer including the filename current date.

[users] DATE FORMAT IN WRITER

2006-07-24 Thread Royce Faye Green
I am not a proficient text user; I use spreadsheets 99% of my time, not Text documents. My personal letterhead format (probably converted from MS Word) has a default footer including the filename current date. This date displays in U.S. numeric format MM/DD/YY, even though I have specified

[users] Date format as default

2005-11-08 Thread Margaret Stanley
Every time I enter a date in Writer I need to explicitly set the format to , for example 31 Oct 05 instead of 10/31/05. Is there any way of setting this as a default date format? Margaret Stanley - To unsubscribe, e-mail:

Re: [users] Date format

2005-06-28 Thread Robin Laing
Peter Kupfer OOo wrote: Robin Laing wrote: Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click

Re: [users] Date format

2005-06-27 Thread Robin Laing
Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style Also, can I ask you to

Re: [users] Date format

2005-06-27 Thread Peter Kupfer OOo
Robin Laing wrote: Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style

[users] Date format

2005-06-25 Thread Graham Window
Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Also, can I ask you to briefly explain Date and Date Fixed? What is the difference? Best wishes, Graham

Re: [users] Date format

2005-06-25 Thread Peter Kupfer OOo
Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style Also, can I ask you to briefly explain Date and

Re: [users] Date format

2005-06-25 Thread Dan Lewis
On Saturday 25 June 2005 12:23 am, Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Also, can I ask you to briefly explain Date and Date Fixed? What is the

Re: [users] Date format

2005-06-25 Thread Peter Kupfer OOo
G. Roderick Singleton wrote: On Sat, 2005-06-25 at 11:36 -0500, Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell,

Re: [users] Date format

2005-06-25 Thread G. Roderick Singleton
On Sat, 2005-06-25 at 12:03 -0500, Peter Kupfer OOo wrote: G. Roderick Singleton wrote: On Sat, 2005-06-25 at 11:36 -0500, Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short