Issue 11404 - dot vs. comma
Summary: dot vs. comma
Alias: None
Product: Native-Lang
Classification: NLC
Component: www (show other issues)
Version: current
Hardware: All All
: P3 Trivial
Target Milestone: ---
QA Contact: issues@fr
Keywords: oooqa
Depends on:
Reported: 2003-02-12 07:43 UTC by rcabane
Modified: 2012-01-31 01:01 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description rcabane 2003-02-12 07:43:11 UTC
Cell numeric entry in Calc can become tedious because french PC keyboards
(except MacOS & swiss-french kbds) give a dot (.) on the numeric keypad, not
comma (,). However, the french localization uses the comma as decimal separator.
Some users proposed to change the keyboard decoding radically, at OS-level to
change this. I think that this is too radical.

Example: typing 12.56 on the keypad SHOULD be interpreted as 12,56
At present (OO.o 1.0.1) the french localization leads to a date interpretation:
Calc understands "décembre 2056", which is quite stupid. If I type 56.48 Calc
thinks it's a character string because 56 is greater than 12.
Now, if I type 12/56 or 10/2/3 Calc properly understands these entries as dates
("à la française", french styled-dates).
So the present dot interpretation seems useless.

My proposition:
1) suppress the dot interpretation so it doesn't mean a date anymore
2) interpret the dot just as a comma
3) in case of error (illegitimate numery entry like 12..56) consider the entry
as text string.

Si je tape 12.56 l'interpréteur d'entrée de cellule DEVRAIT comprendre que c'est
un nombre équivalent à 12,56.
Actuellement, cette entrée (lorsque le format de la cellule est en langue
française) est interprétée comme une date.
Si je tape 12.56, Calc comprend "décembre 2056", ce qui est assez bête; si je
tape 56.48, il comprend que c'est une chaîne de caractères parce que 56 dépasse
12 !!!
De fait, si je tape 12/56 ou 10/2/3 Calc comprend aussi très bien que ce sont
des dates composées "à la française", donc l'interprétation du point n'a pas
lieu d'être.
Enfin je crois que personne n'utilise le séparateur des milliers en entrée de
cellule (en français ce devrait être une espace).

Ma proposition:
1) retirer l'interprétation syntaxique du point conduisant à une date
2) tenter l'interprétation du point exactement comme celle de la virgule (car il
y en a une! si on entre 45,,12 ou 45,12,3, Calc considère cela comme une chaîne
de caractères).
3) en cas d'échec (ce n'est pas un nombre légitime) considérer le contenu comme
du texte.
Comment 1 2003-03-01 14:38:59 UTC
This script resolving the problem,
I close this issue. As Remy should include it in OOo this will close
the issue.
Comment 2 ace_dent 2008-05-17 21:00:43 UTC
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
Comment 3 ace_dent 2008-05-17 23:02:41 UTC
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).