To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106911 Issue #|106911 Summary|VLOOKUP specifing a range in another workbook Component|Spreadsheet Version|OOO310m19 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|ant1647
------- Additional comments from ant1...@openoffice.org Sat Nov 14 11:01:22 +0000 2009 ------- VLOOKUP specifing a range in another workbook There is an apparent error in using VLOOKUP when the range is accessed through a file link. Is there a restriction on the size of the range which can be assessed in this way? EXAMPLE: =IF(C26<>"";(VLOOKUP(C26;'file:///C:/FarmPlan/inputs.ods'#$Levies.$B$4:$F$49;5;0));"") returns the correct value =IF(C26<>"";(VLOOKUP(C26;'file:///C:/FarmPlan/inputs.ods'#$Levies.$B$4:$F$50;5;0));"") returns the value #NA The difference in the statements is that the second contains one more row, in the range, than the first. The softwre is: Openoffice.org.3.1.1 OOO310m19 (Build: 9420) The OS version is Microsoft Windows XP Professional Version 5.1.2600 Service Pack 3 Build 2600 The hardware is Lenovo X61. I am not sure that I have given the correct subcomponent. Is this an issue only with my machine? Kindest regards, ant1647 14 November 2009 --------------------------------------------------------------------- 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
