To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51460 Issue #:|51460 Summary:|Vlookup does not work in spreadsheet that worked with |1.1.4 Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Windows 98 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|sps3000
------- Additional comments from [EMAIL PROTECTED] Fri Jul 1 06:57:38 -0700 2005 ------- The attached is a very old MS Works spreadsheet converted to xls. The cells AH11 to AH27 contain VLOOKUP functions that work perfectly in Ooo 1.1.4, but most of which either do not work or work incorrectly in 1.1.109beta. The errors in AJ18:AM35 are merely a consequence of the VLOOKUP errors.The correct results can be found in the target range of the VLOOKUP functions:- AE70:AH91 --------------------------------------------------------------------- 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]
