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 2020/08/04 09:53:07 UTC

[Bug 64642] New: XSSFRow.getCell returns null incorrectly

https://bz.apache.org/bugzilla/show_bug.cgi?id=64642

            Bug ID: 64642
           Summary: XSSFRow.getCell returns null incorrectly
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: georgewheatcroft@hotmail.co.uk
  Target Milestone: ---

Created attachment 37380
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37380&action=edit
intellij_debug_screenshot

We have some java tests running over newly generated worbooks (from poi) and
old, standard, workbooks which are used for comparison to newly generated
workbooks

There seems to be an issue with poi, as now when one runs XSSFRow.getCell over
the rows of either workbook the old, standard workbook worked in previous
tests) XSSFRow.getCell always returns null. This happens even though each row
contains data, has general formatting and has nothing particularly 'weird'
about it. This is happening despite seeing on intellij that POI XSSF* can read
the workbook to some degree in the "watch variables"

I attach a screenshot of what I see on intellij. note in the screen shot how
the treemap (this._cells) contains a value, though this value is ignored as it
returns cells=null (also in screenshot). I cannot seem to add more than one
attachment at a time, so will add the workbook I am running this on in a
comment

-- 
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 64642] XSSFRow.getCell returns null incorrectly

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64642

george <ge...@hotmail.co.uk> changed:

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

--- Comment #2 from george <ge...@hotmail.co.uk> ---
I must add that XSSFRow.getCell has been working fine on other workbooks I have
ran it over, but despite XSSFRow being able to read this document (as shown in
the screenshot, intellij_debug_screenshot) .getCell is strangely always
returning null

-- 
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 64642] XSSFRow.getCell returns null incorrectly

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64642

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
To make sure: Did upgrading POI trigger this? Or a new way of generating the
XLSX file?

-- 
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 64642] XSSFRow.getCell returns null incorrectly

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64642

--- Comment #1 from george <ge...@hotmail.co.uk> ---
Created attachment 37381
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37381&action=edit
workbook_with_cells_that_return_null

this workbook is the one which the XSSFCell.getCell is having an issue with

-- 
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 64642] XSSFRow.getCell returns null incorrectly

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64642

george <ge...@hotmail.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |FIXED

--- Comment #4 from george <ge...@hotmail.co.uk> ---
Sorry - I have just found that our tests aren't actually pulling the data they
should be into analysis, POI was actually performing the correct evaluation
(returning that the cells are blank)

I shall close this ticket - apologies for the inconvenience 

Thanks 
George Wheatcroft

-- 
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