[Bug 63934] New: The column doesn't exist in Gender lookup table

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 63934] New: The column doesn't exist in Gender lookup table

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63934] The column doesn't exist in Gender lookup table

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934

niketan mishra <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
                   |                            |m

--- Comment #1 from niketan mishra <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63934] The column doesn't exist in Gender lookup table

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934

--- Comment #2 from niketan mishra <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63934] The column doesn't exist in Gender lookup table

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934

niketan mishra <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63934] The column doesn't exist in lookup table

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934

niketan mishra <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 63934] The column doesn't exist in lookup table

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=63934

niketan mishra <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]