Issue 77186 - Date auto-recognition with French (Switzerland) setting
Summary: Date auto-recognition with French (Switzerland) setting
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.2
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.oooforum.org/forum/viewtop...
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-10 11:01 UTC by hagar_de_lest
Modified: 2013-02-07 22:05 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description hagar_de_lest 2007-05-10 11:01:12 UTC 
Problem raised here : http://www.oooforum.org/forum/viewtopic.phtml?t=55767

When the Tools>Options>Language Settings>Language>Locale setting is set to
French (Switzerland), here is what happens :
- Type a text with the "##/##.." formatting and it is recognized as a date.
  Example: "1/1234.." -> "01.01.1234"

No problem with other locale setting. With French (France) setting for example,
the string is considered as text and not as date, even if periods (decimal
separator for Switzerland) are replaced by commas (decimal separator for France).
Comment 1 frank 2007-05-10 22:42:37 UTC 
Hi,

could you please give us the output of the locale command on a shell ?

Thanks

Frank
Comment 2 hagar_de_lest 2007-05-11 07:16:39 UTC 
Here it is :
LANG=fr_FR.UTF-8
LANGUAGE=fr_FR.UTF-8
LC_CTYPE="fr_FR.UTF-8"
LC_NUMERIC="fr_FR.UTF-8"
LC_TIME="fr_FR.UTF-8"
LC_COLLATE="fr_FR.UTF-8"
LC_MONETARY="fr_FR.UTF-8"
LC_MESSAGES="fr_FR.UTF-8"
LC_PAPER="fr_FR.UTF-8"
LC_NAME="fr_FR.UTF-8"
LC_ADDRESS="fr_FR.UTF-8"
LC_TELEPHONE="fr_FR.UTF-8"
LC_MEASUREMENT="fr_FR.UTF-8"
LC_IDENTIFICATION="fr_FR.UTF-8"
LC_ALL=
Comment 3 jbf.faure 2008-07-31 11:37:09 UTC 
Confirmed under Kubuntu 6.06. FR
If we add two points after 1/1234 ("1/1234.." then OOo should keep this input 
as text. It is the behaviour with French (France) settings but not with French 
(Switzerland). May be because the dot is a date separator for Switzerland.
Comment 4 jbf.faure 2008-07-31 11:44:32 UTC 
Additionnal comment : it is the same behaviour for DE-CH than for FR-CH.