Issue 45343 - colon not recognized as time separator in Italian
Summary: colon not recognized as time separator in Italian
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m79
Hardware: All All
: P4 Trivial with 13 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-03-17 23:09 UTC by Andrea Pescetti
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2005-03-17 23:09:24 UTC
It is common in Italian to use either a dot ('.') or a colon (':') as the time
separator, i.e. "8.40" and "8:40" are both legitimate ways to write the time in

OOo 1.9.79 (Italian) recognizes only the former.

A dot-separated time (e.g. 8.40) in a Calc cell is correctly interpreted and
formatted, while a colon-separated time (e.g. 8:40) is considered a string.
Comment 1 Andrea Pescetti 2005-03-17 23:10:36 UTC
[Credit: the bug was reported by Alessio Bottazzi during QA testing]
Comment 2 frank 2005-04-11 11:07:10 UTC
Hi eike,

as discussed one for you.

If possible for 2.0.1 or 2.0.2

Comment 3 ooo 2005-04-11 12:10:07 UTC
Accepted as enhancement, but probably not for 2.0.1, there are more important
things to do.
Comment 4 Marcus 2017-05-20 11:13:35 UTC
Reset assigne to the default "".