To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95763
Issue #|95763
Summary|Date function DAY/TAG
Component|Spreadsheet
Version|OOO300m8
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|hawe
------- Additional comments from [EMAIL PROTECTED] Sun Nov 2 12:59:08 +0000
2008 -------
Date function DAY/TAG calcualtes wrong?
Application test
Calculate Easter Date
Long version
=DATUM(A1;3;28)+REST(24-REST(A1;19)*10,63;29)-REST(KÜRZEN(A1*5/4)+REST(24-REST(A1;19)*10,63;29)+1;7)
or
"=DATE(A2,3,28)+MOD(24-MOD(A2,19)*10.63,29)-MOD(TRUNC(A2*5/4)+MOD(24-MOD(A2,19)*10.63,29)+1,7)"
short version
=RUNDEN((TAG(MINUTE(A2/38)/2+55)&".4."&A2)/7;0)*7-6
or
=ROUND((DAY(MINUTE(A2/38)/2+55)&".4."&A2)/7,0)*7-6
both versions should calculate the same date from 1900 - 2099
31.12.1899 set day 0
debugging shows diffs in DAY-Function (short version calculates wrong)
Excel Calc
TAG(58) = 27 (XL) = 26 (Calc)
TAG(56,5) = 25 (XL) = 24 (Calc)
TAG(55) = 24 (XL) = 23 (Calc)
TAG(59,5) = 28 (XL) = 27 (Calc)
January has 31 days as we know, so Calc is not quite correct...
---------------------------------------------------------------------
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]
