To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101054
Issue #|101054
Summary|Year counting deffect (lack of error message) in funct
|ions: ISLEAPYEAR, WEEKSINYEAR, DAYSINYEAR
Component|Spreadsheet
Version|OOO310m1
Platform|All
URL|http://pl.wikibooks.org
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|code
Assigned to|spreadsheet
Reported by|montechristof
------- Additional comments from montechris...@openoffice.org Mon Apr 13
22:00:04 +0000 2009 -------
Tere is no error code for functions ISLEAPYEAR, WEEKSINYEAR, DAYSINYEAR when
putting only years, and if so - there is a wrong calculation.
For excample the year 2012 is a leap year:
- function ISLEAPYEAR("2012") returns "0" (FALSE) wether it should be "1"
(TRUE) or at least ERROR code for excample #502
The same issue is in the function DAYSINYEAR or WEEKSINYEAR:
- function DAYSINYEAR("2012") returns 365 wether it should be 366 or ERROR code
of wrong date format
- function WEEKSINYEAR("2009") returns value: 52, while WEEKSINYEAR
("12.02.2009") returns value of 53.
---------------------------------------------------------------------
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
