[sc-issues] [Issue 108362] WEEKNUM("2010/4/1";1) ret urns 2 in English, 1 in other context
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 User cloph changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |INVALID --- Additional comments from cl...@openoffice.org Mon May 17 19:56:03 + 2010 --- invalid. Different countries - different standards wrt. week numbers. In US January 1 is always week number one, so first week of the year can only contain few days. whereas DIN/ISO 8601 is defined as the first week of the year that contains at least 4 days. Besides, start-of-week is either Sunday or Monday. - 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108362] WEEKNUM("2010/4/1";1) ret urns 2 in English, 1 in other context
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 User cloph changed the following: What|Old value |New value CC|''|'cloph' Status|RESOLVED |CLOSED --- Additional comments from cl...@openoffice.org Mon May 17 19:56:32 + 2010 --- closing. No bug, but works as designed. - 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108362] WEEKNUM("2010/4/1";1) ret urns 2 in English, 1 in other context
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 --- Additional comments from ville...@openoffice.org Fri Jan 15 16:39:04 + 2010 --- Oh, Oh, Oh. Sorry it's NOT the WEEKNUM function, only TEXT and number formatting with "WW" - 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108362] WEEKNUM("2010/4/1";1) ret urns 2 in English, 1 in other context
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108362 User villeroy changed the following: What|Old value |New value Version|1.0.0 |OOo 3.2 RC2 - 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108362] WEEKNUM("2010/4/1";1) ret urns 2 in English, 1 in other context
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108362
Issue #|108362
Summary|WEEKNUM("2010/4/1";1) returns 2 in English, 1 in other
| context
Component|Spreadsheet
Version|1.0.0
Platform|Unknown
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|villeroy
--- Additional comments from ville...@openoffice.org Fri Jan 15 16:22:03
+ 2010 ---
WEEKNUM(DATE(2010;1;4);1)
Number format WW with DATE(2010;1;4)
TEXT(DATE(2010;1;4);"WW")
all return 2 in English(UK/US/Australia).
Other locales return 1, which seems to be the correct value (German, French).
However, allow me an additional question:
If ...
WEEKNUM(DATE(2010;1;4);1)
... returns 1 because SUNDAY 4th Jan marks the first week, why does ...
WEEKNUM(DATE(2010;1;4);2)
... return 1 where the first day of week is supposed to be MONDAY, 29/12/1009 ?
-
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...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
