To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48207 Issue #:|48207 Summary:|lookup() function broken from 1.1.4 -> 1.9.95 Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|code Assigned to:|spreadsheet Reported by:|mike_jones
------- Additional comments from [EMAIL PROTECTED] Tue Apr 26 09:02:37 -0700 2005 ------- I downloaded 1.1.95 and opened a spreadsheet which I'd created under 1.1.4 and fields I was calculating using the LOOKUP() function are showing up incorrectly. I have one sheet with an ID number in column 1, a last name in column 2, a first initial in column 3, and a team name in column 4. Fields in another sheet use this formula (and similar) to fill in fields: =IF($A27=0;"";LOOKUP($A27;ID_Number;ID_LastName)) where ID_Number is a named range for the first field in the ID sheet, and ID_LastName is a named range for the second field. In 1.1.4 this worked correctly; in 1.9.95, I'm consistently getting data from the last row of the named range One wrinkle: the value in $a27 (and others in column A) has a hyperlink pointing to another sheet in the same workbook. If I delete the text with the hyperlink and retype the data (it's always a 4-digit number), it still fails the same way. If I go to the ID sheet, copy the cell and paste it into the main sheet, it works. I also tried changing the lookup() call to use vlookup(), but it failed the same way. --------------------------------------------------------------------- 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]
