To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45243 Issue #:|45243 Summary:|LOOKUP function fails on columns with empty spaces Component:|Spreadsheet Version:|680m84 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|gooddamon
------- Additional comments from [EMAIL PROTECTED] Wed Mar 16 21:18:46 -0800 2005 ------- If a LOOKUP() is run on a column of data, and each of the following is true: 1. One of the cells is empty. 2. The value being looked up appears BELOW the empty cell then OO.org produces #N/A output, instead of the correct value. This function works perfectly in 1.1.4. To reproduce this issue: 1. Create a column of data with a few empty cells. (Example: A1:A10) 2. Assign another cell a value from from the column BELOW an empty cell. (Example: B3) 3. Use this syntax in a formula: =LOOKUP(B3;A1:A10) 4. The formula will return #N/A instead of the value that matches B3. --------------------------------------------------------------------- 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]
