Bug 64642 - XSSFRow.getCell returns null incorrectly
Summary: XSSFRow.getCell returns null incorrectly
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2020-08-04 09:53 UTC by george
Modified: 2020-10-30 10:14 UTC (History)
0 users

intellij_debug_screenshot (115.76 KB, image/png)
2020-08-04 09:53 UTC, george
workbook_with_cells_that_return_null (4.21 KB, application/xml)
2020-08-04 09:56 UTC, george

Note You need to log in before you can comment on or make changes to this bug.
Description george 2020-08-04 09:53:07 UTC
Created attachment 37380 [details]

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
Comment 1 george 2020-08-04 09:56:17 UTC
Created attachment 37381 [details]

this workbook is the one which the XSSFCell.getCell is having an issue with
Comment 2 george 2020-08-04 09:58:52 UTC
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
Comment 3 Dominik Stadler 2020-10-25 04:39:15 UTC
To make sure: Did upgrading POI trigger this? Or a new way of generating the XLSX file?
Comment 4 george 2020-10-30 10:14:32 UTC
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 

George Wheatcroft