To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=78256
User hywelm changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Aug 6 20:30:39 +0000
2007 -------
I tried the modified spreadsheet but this gave an incorrect result when run in
OOo 2.0, but the correct result in OOo 1.1. The problem is with the LOOKUP
function, not YEARFRAC. LOOKUP should find a match for all donors in the
spreadsheet, but it doesn't. I ran in debug after placing a breakpoint at the
modified line of code. Looking at the values
of "donor_first_name", "donor_last_name" and "declaration_date" variables after
hitting the breakpoint shows that none of them have been updated by the result
of the LOOKUP functions - presumably because LOOKUP has not found any matches.
---------------------------------------------------------------------
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]
