[Bug 54327] New: cellIterator skips blank/unformatted cells in a row

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=54327

            Bug ID: 54327
           Summary: cellIterator skips blank/unformatted cells in a row
           Product: POI
           Version: 3.5-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: mandicha.smitha@gmail.com
    Classification: Unclassified

Created attachment 29778
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29778&action=edit
sample excel

Summary: I need to process excel sheets by finding a header (i.e the first row
with 8 consecutive columns). The subsequent rows' following the header becomes
the data for the header cell values. 

Problem Statement: In a row if 2nd cell is blank and unformatted but the rest
of the cells in that row are formatted, then the 2nd cell is not read and hence
the values are messed up. 

Example: In the attached excel sheet, cell B4 and B6 are skipped by the
cellIterator and thus the header 'Completion Date' has the values of the next
columns i.e., M India Limited & Steel in row 4 and 6 respectively. But the same
is not true for 5th row. It is read properly though B5 is blank.

Please let me know the solution at the earliest. Also, the possible way to
un-format the entire excel sheet before processing.

-- 
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 54327] cellIterator skips blank/unformatted cells in a row

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=54327

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |INVALID
                 OS|                            |All

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
This is expected behaviour, the iterator only processes the cells that are
defined in the file

If you need to fetch all cells, you should use a for loop, and call
getCell(columnNumber, MissingCellPolicy) to control how missing / blank cells
are handled

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