[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 User ab changed the following: What|Old value |New value Status|NEW |STARTED Target milestone|--- |OOo 3.x --- Additional comments from a...@openoffice.org Wed Nov 17 08:40:05 + 2010 --- STARTED, OOo 3.x - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 --- Additional comments from j...@openoffice.org Mon Jun 28 08:29:35 + 2010 --- The number format string NN is used to display a day as Sun to Sat and the string NNN is used as a day as Sunday to Saturday. This is described similarly within the help system - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 --- Additional comments from piton...@openoffice.org Mon Jun 28 12:28:24 + 2010 --- When run, the macro demonstrates, on at least the two test systems, that nn, by itself, displays the two digit hour and that when used in the last format string between two colons it displays the three digit day. I tested with the two digit NN and this returned the same result as nn. You describe the values in the Help system for NN and NNN. Where in the help system? What topic shows this? For the Basic Language and the Format statement, none of these are documented. I do not even know where I obtained my original list (but I can guess). If the help documents NN and NNN as you describe, then it is in error because NN does not show the three digit day (at least not on my computer). NNN does appear to display the full day (the same as ). On a whim, I added nnn and received the full day name, for the full day name and a comma, and n for the full day name, a comma, and an n. I suppose that I really should simply read the code. Please point me to the full list of format specifiers in the help (how do I find them). I want to see if , @, and ! are also documented as working. - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 User kr changed the following: What|Old value |New value Assigned to|kr|sb --- Additional comments from k...@openoffice.org Mon Jun 28 12:40:59 + 2010 --- Stephan, please have a look. - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 User sb changed the following: What|Old value |New value Assigned to|sb|ab --- Additional comments from s...@openoffice.org Mon Jun 28 13:07:53 + 2010 --- . - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
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 piton...@openoffice.org Sat Jun 26 13:05:12 + 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, , _ m, mm, mmm, , _ d, dd, ddd, , d, dd, _ w, ww, h, hh, n, nn, s, ss, _ t, c, _ d// 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// 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// 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 112722] Format statement problem with dd and nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112722 --- Additional comments from piton...@openoffice.org Sat Jun 26 13:06:29 + 2010 --- I assume that this will be assigned to sb as usual... but I will not make that call for now. - 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: issues-unsubscr...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org