To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109826 Issue #|109826 Summary|Match, Lookup, and other functions do not work correct |ly Component|Spreadsheet Version|OOO320m9 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|jrsprick
------- Additional comments from jrspr...@openoffice.org Thu Mar 4 17:53:09 +0000 2010 ------- Match, Lookup, Vlookup, and Hlookup do not work properly when searching arrays of strings. Match works fine when looking up number arrays, but returns strange indexes when looking through string-based arrays after the 12th item in the array. Example: Array A1:A17 Looks like this: Alchemy Armorsmith Craftsman Create Potion Create Scroll Create Trap Disarm/Arm Trap Evaluate Item Herbal Lore Pick Locks Weaponsmith Break Charm Detect Celestial Magic Gypsy Curse Resist Charm Resist Poison Resist Sleep Match returns the proper index up through Break Charm. Detect Celestial Magic returns 6, Gypsy Curse returns 8, and the last three return 10 each. -JR Sprick NERO Colorado player --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
