[BUG 52288] DATE: Allow truncated date inputs from numeric keyboard

l10n
#1

Hi Mihovil,

That means you could have entered 31.8 or 31/8 or 31-8 in a
cell and LO would recognise it as 31.08.12
LO 3.6.x removed that support and now you need to enter 31.08.2012
for date to be recognised.

This is not true. It happened to be the case for Croatian hr-HR and
locales for which I got no feedback what incomplete date input patterns
should be added. Other locales have patterns for incomplete date input.
What got lost for locales using '.' was the ability to enter dates on
the numeric keypad with '/' or '-'

Info from Eike is that some people complained about recognition
patters and that's why it got removed totally.

Not "some people", this is experience of over 10 years in OOo/LibO being
responsible in the Calc and i18n area and number formatter/scanner that
users were confused and annoyed by the lax recognition of dates where
they did not expect it.

Eike made a patch which will probably be available in 3.6.2 in which
he returns for functionality, but as I understood not as defult
option.

It would be good if everyone suggests default recognition options
for their locale.

I want to avoid having to explicitly add patterns for each locale and
having to figure out for new locales what the patterns could be. I'd
rather with an algorithm during build time let generate a minimal set of
meaningful patterns from each locale's date and decimal separator and
YMD order. Some locales have additional requirements, these can be
individually added to locale data. That richer set then could be default
from which in the new edit patterns option field the user could remove
patterns.

Now, my suggestion for Croatian locale would be:
D.M;D.M.;D.M.Y;D/M;D/M/;D/M/Y

Any reason why the Croatian locale should have D.M. or D/M/ with
trailing separator?

  Eike

#2

Because I'm not sure which is correct.
I searched online for date writing rules in croatian and what I get is confusing.

Found some student papers in which rule is to write dates as 31.8.2012. (with trailing dot after year) and then I found some other resources in and some common practice in which date is written as 31.8.2012 (without trailing dot).

It seams to me that correct way to write full date is 31.8.2012. but commonly used is 31.8.2012
So croatian locale should also include trailing . and / adter year.

D.M;D.M.;D.M.Y;D.M.Y.;D/M;D/M/;D/M/Y;D/M/Y/

Maybe Robert who is translator for LO croatian l10n can give his thoughts on that.
I'm only concerned user and he is probably more familliar to this then I am.

Best reagards,
Mihovil

#3

Because I'm not sure which is correct.
I searched online for date writing rules in croatian and what I get is confusing.

Found some student papers in which rule is to write dates as 31.8.2012. (with trailing dot after year) and then I found some other resources in and some common practice in which date is written as 31.8.2012 (without trailing dot).

It seams to me that correct way to write full date is 31.8.2012. but commonly used is 31.8.2012
So croatian locale should also include trailing . and / adter year.

D.M;D.M.;D.M.Y;D.M.Y.;D/M;D/M/;D/M/Y;D/M/Y/

Maybe Robert who is translator for LO croatian l10n can give his thoughts on that.
I'm only concerned user and he is probably more familliar to this then I am.

Best reagards,
Mihovil

#4

(from the bug)
A suggestion: I'd like to see the "old" behaviour as a default:

NO! Definitely not. The old behavior was such a pain and it's a
godsend that it's finally fixed. Don't even consider such a stupid
idea. I can't even count how many silent/hidden data losses this
caused (especially on CSV import).

#5

Hi Mihovil,

>>Now, my suggestion for Croatian locale would be:
>>D.M;D.M.;D.M.Y;D/M;D/M/;D/M/Y
>Any reason why the Croatian locale should have D.M. or D/M/ with
>trailing separator?

Because I'm not sure which is correct.
I searched online for date writing rules in croatian and what I get
is confusing.

Found some student papers in which rule is to write dates as
31.8.2012. (with trailing dot after year) and then I found some
other resources in and some common practice in which date is written
as 31.8.2012 (without trailing dot).

This may lead to D.M.Y. but not D.M. or D/M/ unless the situation isn't
similar to German where D.M. is the correct abbreviated form.

It seams to me that correct way to write full date is 31.8.2012. but
commonly used is 31.8.2012
So croatian locale should also include trailing . and / adter year.

D.M;D.M.;D.M.Y;D.M.Y.;D/M;D/M/;D/M/Y;D/M/Y/

I'd say it should be

D.M.Y;D.M;D.M.Y.;D/M/Y;D/M

or maybe

D.M.Y;D.M;D.M.Y.;D.M.;D/M/Y;D/M

The '/' patterns are only for numeric keypad input, aren't they? I doubt
anyone wants to key in an extra character if not needed..

  Eike

#6

Dana 31.8.2012. 14:46, Eike Rathke je napisao:

I'd say it should be D.M.Y;D.M;D.M.Y.;D/M/Y;D/M or maybe D.M.Y;D.M;D.M.Y.;D.M.;D/M/Y;D/M The '/' patterns are only for numeric keypad input, aren't they? I doubt anyone wants to key in an extra character if not needed.. Eike

Yes, you are right.
I would go with D.M.Y;D.M;D.M.Y.;D.M.;D/M/Y;D/M

Thank you.

Mihovil

#7

Hi all,

I apologise for delay.
Yes. you are right about proposed patterns.
Since nobody in Croatia uses Croatian standard of date writing
(yyyy-mm-dd), almost everybody use proposed patterns.

With regards,
Robert