Issue 72235 - In function TEXT date format code guessed wrong
Summary: In function TEXT date format code guessed wrong
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-12-04 06:52 UTC by gustaaf
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

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

DateTime_example (17.29 KB, application/vnd.sun.xml.calc)
2006-12-04 09:34 UTC, gustaaf
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gustaaf 2006-12-04 06:52:02 UTC

During tests with OOo21 RC2 the date coding combination DD/MMM is displayed as 
04-dec i.s.o. 04/dec in the Dutch(nl) version.
Comment 1 wolframgarten 2006-12-04 07:58:47 UTC
Please give a detailed step by step description of your action. Where and how do
you insert the date and which version exactly do you use? Thanks in advance.
Comment 2 gustaaf 2006-12-04 09:34:42 UTC
Created attachment 41105 [details]
Comment 3 gustaaf 2006-12-04 09:36:04 UTC

I'm testing OOo 2.1 RC2 and used the fr-document datetime_fr.sxc place as 
testdocument on the site for test Calc-34 (Calc test part 2 - 17)
I changed the document for the NL-localisation codes in stead of the French 
codes. All codes work well except the one I just mention.I saved the document 
as .ods. Closed it and opened it again to be sure the fault is still there. 
I will add an attachment with the document and a screenshot. The setting is 
marked yellow.
Comment 4 wolframgarten 2006-12-04 09:49:21 UTC
Thanks for the doc, but this is a calc doc. Why is component set to presentation
then? Reassigning.
Comment 5 gustaaf 2006-12-04 10:26:08 UTC

didn't noticed I put it to presentation. Should indeed be spreadsheet.
Comment 6 frank 2006-12-04 10:51:53 UTC
Hi Eike,

seems to be yours.

Comment 7 ooo 2006-12-04 14:37:05 UTC
Accepted. Note that you need to have a Dutch (Netherlands) [nl_NL] locale
activated to make all format codes work, and the yellow one fail.

Failure is probably due to the handling in
Comment 8 gustaaf 2007-06-15 23:09:40 UTC
72235 still exists in version 2.2.1 NL for Windows. DD/MMM still translated as 
DD-MMM. Also DD/MM and D/M are guessed wrong where slash is translated as dash.
DD/MMM	16-jun
DD-MMM	16-jun
DD/MM/JJJJ	16/06/2007
DD/MM	16-06
D/MM	16-06
D/M/JJ	16/6/07
If a year parameter is added, it is guessed correct.
Comment 9 Martin Hollmichel 2007-11-09 16:52:05 UTC
change target from 2.x to 3.x according to
Comment 10 erack 2008-03-08 13:11:04 UTC
Closely related, when using a de-DE locale:

=TEXT(A1;"YYYY-MM-DD") works just fine
=TEXT(A1;"YYYY-MM-DD HH:MM:SS") returns "YYYY-03-DD 08:17:40"

Same for the service,
convertNumberToPreviewString ("YYYY-MM-DD HH:MM:SS", date, "de-DE", true)
Comment 11 Marcus 2017-05-20 11:11:30 UTC
Reset assigne to the default "".