Let me see: open Calc in LO 3.6.0.2 and format a column selecting the Category as Date and the Language as English(UK). It does not seem to matter what is selected as the Format. (I selected 31/12/99.) Enter 20-7 in a cell. It becomes 20/7/12. When 20/7 is entered in a cell of the column, 20/7/12 is the result. It is a matter of formatting the column, cell, or row for the type of data to be placed in the sheet. With the correct format [English(USA)], I can enter 20-7 in a cell, and it will become Saturday, July 20,2012 or Saturday, 20 July 2012 depending upon what format I use. (The last one would require selecting User-defined Category and the appropriate entries in the Format code box.) Ah yes, the "weird" USA way. While I had the Format dialog open with UK as the Language, I noticed something in the list of Format examples: MM-DD! If it should be DD/MM/YY, then why should it also be MM/DD? OK so the USA way is weird, but then so is the British. Check it out. Chuckle, Chuckle! (From where this is located in the Format example list, I think I know why it is this way. (ISO 8601) But I could not resist replying to Tom's comment.

--Dan

Tom Davies wrote:
Hi :)
I thought the USA way was the amazingly weird
mm/dd/yy

Apparently it's important to use / instead of - in order to make sure it's 
easier to mis-read.  With some people's handwriting an 11 might look like 1/ or 
vice-versa.
Regards from
Tom :)


--- On Mon, 23/7/12, Joep L. Blom <jlb...@neuroweave.nl> wrote:

From: Joep L. Blom <jlb...@neuroweave.nl>
Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
To: users@global.libreoffice.org
Cc: "Andreas Säger" <ville...@t-online.de>
Date: Monday, 23 July, 2012, 22:18

On 23-07-12 21:02, Andreas Säger wrote:
Am 23.07.2012 14:44, Guy Voets wrote:
Hi folks,

A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past).

      - In LibO 3.5.5, I used to give in dates as 20-7 and they were
shown as
      20 Jul 12.
      - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell.

If I enter 20-7-12, the date is inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the
desired
notation 20 Jul 12.

Is this a new feature, or a bug?


This is just another anti-feature that has been added to Calc against
all reason simply because too many inexperienced users who never really
used any spreadsheets insisted loudly enough.
I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.


I resent the US way of ISO 8601. We Dutch and other Europeans use the
more logical sequence of day-month-year instead of the illogical
year-month-day.(most important first, least important last: very often
the year can be missed).
Joep






--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to