Issue 72235

Summary: In function TEXT date format code guessed wrong
Product: Calc Reporter: gustaaf <gustaaf.cuyvers>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cno, issues
Version: OOo 2.1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
DateTime_example none

Description gustaaf 2006-12-04 06:52:02 UTC 
Dear,

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]
DateTime_example
Comment 3 gustaaf 2006-12-04 09:36:04 UTC 
Dear,

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 
Sorry,

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.

Frank
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
SvNumberFormatter::GetPreviewStringGuess()
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
http://wiki.services.openoffice.org/wiki/Target_3x
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"
=TEXT(A1;"JJJJ-MM-TT HH:MM:SS") works

Same for the com.sun.star.util.NumberFormatter 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 "issues@openoffice.apache.org".