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
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.