Apache OpenOffice (AOO) Bugzilla – Issue 72235
In function TEXT date format code guessed wrong
Last modified: 2017-05-20 11:11:30 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.
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.
Created attachment 41105 [details] DateTime_example
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.
Thanks for the doc, but this is a calc doc. Why is component set to presentation then? Reassigning.
Sorry, didn't noticed I put it to presentation. Should indeed be spreadsheet.
Hi Eike, seems to be yours. Frank
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()
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.
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
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)
Reset assigne to the default "issues@openoffice.apache.org".