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!
I suppose we don't support Vloolup ....
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.