To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82725
------- Additional comments from [EMAIL PROTECTED] Wed Oct 17 18:42:20 +0000 2007 ------- Hi, this is not a bug from Calc but from Excel I think. An empty cell is not Zero but empty. So your example isn't with the correct parameter. If you use "" instead of 0 the lookup works as expected. A formula must have a result. A simple reference as in your case is a formula and it's assumed that the referenced cell is nummerical the resulting cell shows a zero as lowest neutral number. IMHO this Issue should be closed invalid. Any other opinions here ? Frank --------------------------------------------------------------------- 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]