Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

     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 <jlblom@neuroweave.nl> wrote:
>
> From: Joep L. Blom <jlblom@neuroweave.nl>
> Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
> To: users@global.libreoffice.org
> Cc: "Andreas Säger" <villeroy@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+help@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