Bug 51781

Summary: Blank rows vs content deleted rows
Product: POI Reporter: Murthy <murthy.mvvr>
Component: POIFSAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Murthy 2011-09-07 12:37:12 UTC

We have an issue while reading the Excel file.

If a Row is deleted by right click and selecting delete from options retrieved, the row is not being retrieved while reading. (I assume this is the correct way)

But if the complete row is selected and clicked on Delete button (from keyboard) ( i mean content deletion), the row is being treated as Empty values and this row is being considered. (I assume this is wrong)

Is there anyway the later section be work similar to first way?

Comment 1 Nick Burch 2011-09-09 14:51:10 UTC
POI gives you the data that is actually present in the file. What excel chooses to write / not write is up to it

Look at MissingCellPolicy and MissingRowPolicy if you want more control of how empty or missing rows/cells are treated by the API