To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103291 Issue #|103291 Summary|MATCH and VLOOKUP in unordered mode fails with large n |umbers Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|villeroy
------- Additional comments from [email protected] Thu Jul 2 18:43:08 +0000 2009 ------- 842020700000001 1 =MATCH($A1;$A$1:$A$5;0) 842020700000002 1 =MATCH($A2;$A$1:$A$5;0) 842020700000003 1 =MATCH($A3;$A$1:$A$5;0) 842020700000004 2 =MATCH($A4;$A$1:$A$5;0) 842020700000005 3 =MATCH($A5;$A$1:$A$5;0) Expected results: 1;2;3;4;5 --------------------------------------------------------------------- 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]
