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 +0000 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