Created attachment 37380 [details] 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
Created attachment 37381 [details] workbook_with_cells_that_return_null this workbook is the one which the XSSFCell.getCell is having an issue with
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
To make sure: Did upgrading POI trigger this? Or a new way of generating the XLSX file?
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