To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58807 Issue #:|58807 Summary:|VLOOKUP output behave strangely Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|bgirin
------- Additional comments from [EMAIL PROTECTED] Fri Dec 2 14:57:52 -0800 2005 ------- I have found that VLOOKUP gives strange output in openoffice 2.0 both on windows XP and linux FC3 platforms. This issue do not happen using openoffice 1.1.3 Here is the way to test this issue : 1. Enter the letters B D A C in the cell A1, A2, A3 & A4 2. Enter the figures 2 4 1 3 in the cell B1, B2, B3 & B4 3. Enter the letters A B C D in the cell C1, C2, C3 & C4 4. Enter the formula VLOOKUP(C1;$A$1:$B$4;2) in cell D1 5. copy cell D1 in D2, D3, D4 -> the result gives 1 2 2 4 in cells D1 to D4 (it should give 1 2 3 4) --------------------------------------------------------------------- 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]