You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/03/29 01:14:39 UTC
[Bug 57775] New: XSSFSheetXMLHandler does not generate event for
empty cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=57775
Bug ID: 57775
Summary: XSSFSheetXMLHandler does not generate event for empty
cells
Product: POI
Version: 3.11-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: jan.palus@gmail.com
I'm parsing big XLSX file using XSSFSheetXMLHandler and its
SheetContentsHandler interface. The crucial thing though is to track column
number to which reported cell belongs. Unfortunately if cell is empty there is
no event generated and hence column number cannot be tracked. Please raise
cell() event with formattedValue = null / "" or provide option to do so.
Codewise to report cell() event it is required to have some additional value
tag between <c></c> while in case of empty cells there is none.
--
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 57775] XSSFSheetXMLHandler does not generate event for empty
cells
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=57775
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WONTFIX
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
This is by design, it returns only the cells physically present in the file
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
provides an example of the handful of lines of code needed to track + process
missing cells. Exactly how to process them, how many columns to generate
missing cells for, handling missing cells at the end of the row etc are
application-specific decisions, so you need to do that yourself
--
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