Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Hi :)
The fact of something appearing in a format dialogue box is not really proof of that format being 
used!  I've never seen nor heard of the USA way being used in the UK.  Perhaps it's used in the US 
airbases.  Wouldn't it be a tad confusing if both ways were really being used here?  I think you 
have found a bug in the format dialogue but i would be amazed if those dialogues are really 
specific to a locale setting.  
Regards from
Tom :)  

--- On Tue, 24/7/12, Dan <> wrote:

From: Dan <>
Subject: Re: [libreoffice-users] Re: LibO - Calc: date notation
Date: Tuesday, 24 July, 2012, 0:02

     Let me see: open Calc in LO 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.


Tom Davies wrote:
Hi :)
I thought the USA way was the amazingly weird

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 <> wrote:

From: Joep L. Blom <>
Subject: Re: [libreoffice-users] Re: LibO - Calc: date notation
Cc: "Andreas Säger" <>
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, 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
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).

-- For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.