Bug 19377 - [RFE] #VALUE! in the function of Vlookup
Summary: [RFE] #VALUE! in the function of Vlookup
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks: 34973
  Show dependency tree
 
Reported: 2003-04-28 03:37 UTC by Jacky
Modified: 2008-05-05 11:38 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jacky 2003-04-28 03:37:10 UTC
util.setcellFormula(noColumn++, "VLOOKUP(E"+String.valueOf(noRow).trim()
+",A80:B90,2)");

util.CreateRow(79);
util.CreateCell(0,"099");
util.CreateCell(1,"TAN");
util.CreateRow(80);
util.CreateCell(0,"123");
util.CreateCell(1,"TESt");

I set the Fuction VLOOKUP and the Result is #VALUE!
Comment 1 Andy Oliver 2003-07-24 16:23:06 UTC
I suppose we don't support Vloolup ....
Comment 2 Josh Micich 2008-05-05 11:38:49 UTC
Re-tested in 3.1-beta1.

This was probably fixed in bug 44675 (second part - if the parameter operand class is wrong Excel evaluates VLOOKUP to '#VALUE!')

Also changed 'Vloolup' to 'Vlookup' in summary of this bugzilla record.