org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in lookup table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in lookup table

niketanmishra
Hi folks,

I have an issue with vlookup on table.
im trying to get the vlookup result in another sheet by referencing through
Gender_lookup table. I am using formula =VLOOKUP(TRIM(CLEAN([@[Gender
]])),Gender_lookup,2,0) which takes Gender value from current row in my
table and checks for corresponding Gender value in Gender_lookup table in
another sheet to return answer. i have raised same issue in bugzilla :
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934 for reference with all
attachments for reproducing issue easily.

I tried evaluating with
XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook); which gives
exception as

org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in
table Gender_lookup.

I need a solution without altering formula in excel if possible.
Please help me with your valuable solution.im attaching here screenshot and
sample file to test.

Vlookup.java
<http://apache-poi.1045710.n5.nabble.com/file/t340747/Vlookup.java>  
VlookupBug.xlsx
<http://apache-poi.1045710.n5.nabble.com/file/t340747/VlookupBug.xlsx>  
<http://apache-poi.1045710.n5.nabble.com/file/t340747/TableBug.png>



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]