You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/11/19 09:39:21 UTC
[Bug 63934] New: The column doesn't exist in Gender lookup table
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
Bug ID: 63934
Summary: The column doesn't exist in Gender lookup table
Product: POI
Version: 4.1.1-FINAL
Hardware: PC
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: niketan.mishra1995@gmail.com
Target Milestone: ---
Created attachment 36886
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36886&action=edit
Attached hereinwith is a sample excel file to reproduce the issue . Created a
simple excel table in two sheets and called
XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook) on workbook .
duplicate bug id - 57721
i have an excel file with named excel tables for vlookup in a sheet.
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.
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 at
org.apache.poi.ss.formula.FormulaParser.parseStructuredReference(FormulaParser.java:821)
According to me the issue is related to named Table range inside Gender lookup
table.
I have checked the table name and its working perfectly in excel.
Please help me with the issue without changing excel table formulaes.
Im attaching a sample excel to reproduce the issue with screenshot.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
niketan mishra <ni...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|The column doesn't exist |The column doesn't exist
|in Gender lookup table |in lookup table
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|critical |normal
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #7 from PJ Fanning <fa...@yahoo.com> ---
https://github.com/apache/poi/pull/514 is now merged
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #4 from Matthias Raschhofer <ma...@gmail.com> ---
Btw, there's a workaround for the issue:
If you specify the range in the lookup table explicitly, both excel and the
apache poi library can evaluate the formula just fine. E.g.:
=VLOOKUP([@[Gender ]];Gender_lookup[[Gender input]:[Gender mod]];2;0)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in Gender lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
niketan mishra <ni...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
niketan mishra <ni...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|All |Windows 10
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #6 from Matthias Raschhofer <ma...@gmail.com> ---
Since there's a workaround, imho this is not a very critical issue, however it
would probably still be good to support this case.
I opened a pull request to offer a fix for this issue:
https://github.com/apache/poi/pull/514
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in Gender lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
niketan mishra <ni...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |niketan.mishra1995@gmail.co
| |m
--- Comment #1 from niketan mishra <ni...@gmail.com> ---
Created attachment 36887
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36887&action=edit
Attached hereinwith is the screenshot for the Exception.
Please find attached screenshot for the bug
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Depends on| |57721
Referenced Bugs:
https://bz.apache.org/bugzilla/show_bug.cgi?id=57721
[Bug 57721] Evaluating formulas in named Excel table
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #5 from Matthias Raschhofer <ma...@gmail.com> ---
According to Microsoft the structure-reference Gender_lookup[] is equivalent to
Gender_lookup[#Data], which poi is able to parse correctly.
See
https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oe376/bcd72180-31a3-423b-8f83-d224b2286da3.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in Gender lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #2 from niketan mishra <ni...@gmail.com> ---
Created attachment 36888
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36888&action=edit
Attached hereinwith is the java code to reproduce the issue
Please find attached java file to reproduce issue. Please replace the excel
path location in java file with your saved excel location.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63934] The column doesn't exist in lookup table
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #3 from maxence.cramet@gmail.com ---
Same issue with 5.2.3
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org