Bug 51781 - Blank rows vs content deleted rows
Summary: Blank rows vs content deleted rows
Alias: None
Product: POI
Classification: Unclassified
Component: POIFS (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2011-09-07 12:37 UTC by Murthy
Modified: 2011-09-09 14:51 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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