To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 Issue #|112722 Summary|Format statement problem with dd and nn Component|scripting Version|OOo 3.2.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|kr Reported by|pitonyak
------- Additional comments from [email protected] Sat Jun 26 13:05:12 +0000 2010 ------- I see errors in the 64-bit Linux release with this simple macro Sub strangeFormats Dim i% Dim d As Date d = now() Dim s$ Dim formats formats = Array("q", "y", "yy", "yyyy", _ "m", "mm", "mmm", "mmmm", _ "d", "dd", "ddd", "dddd", "ddddd", "dddddd", _ "w", "ww", "h", "hh", "n", "nn", "s", "ss", _ "ttttt", "c", _ "d/mmmm/yyyy h:nn:ss") For i = LBound(formats) To UBound(formats) s = s & formats(i) & " => " & Format(d, formats(i)) & CHR$(10) Next MsgBox s End Sub Individually, each format specifier works correctly. The two in question: dd => Two digit day nn => two digit minute Incorrect: "d/mmmm/yyyy h:nn:ss" => nn produces the expected output from ddd, namely the three letter day name (for me this was fri). I asked for testing on the dev mailing list and Johnny Rosenberg tested on a 32-bit standard build running on Ubuntu. He had the following to say: ************************** Same happens for me, except that day name is two letters (in Swedish): d/mmmm/yyyy h:nn:ss => 26-juni-2010 9:lö:46 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
