To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63381 Issue #:|63381 Summary:|1.x to 2.0 incompatibility in LOOKUP should be |documented Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|dridgway
------- Additional comments from [EMAIL PROTECTED] Sun Mar 19 16:37:29 -0800 2006 ------- As described by multiple reporters in issue 58286, and by another in private email, the behavior of LOOKUP on unsorted data has changed between 1.x and 2.0. 1.x returns the expected result, even if the data is unsorted, while 2.0 returns nonsense. Since the documentation for LOOKUP has always required sorted data, the behavior of 2.0 is not a defect. However, for users who developed perfectly functioning spreadsheets with unsorted data using 1.x versions, the lack of compatibility in the undocumented behavior is experienced as a defect. This incompatibility should get documented somewhere, so that people porting spreadsheets to 2.0 can check to make sure their spreadsheets are using LOOKUP correctly. --------------------------------------------------------------------- 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]
