https://issues.apache.org/bugzilla/show_bug.cgi?id=53323
Priority: P2
Bug ID: 53323
Assignee: [email protected]
Summary: Saving file with SXSSF produce a file that is not read
corectly with XFFS
Severity: major
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: 3.8
Component: SXSSF
Product: POI
I work on an aplication which exports/imports data from/to XLS files using POI.
The reading is implemented using event model the the writing of excels is using
usermodel. Recently we decided to add XLSX suport. Firstly I made the export
using XSSF and it worked fine. But after that have the ideea to use SXSSF
because we are sometimes dealing with huge data amounts. At the first test all
seemed fine, but when I tried one of the unittests I discovered a strage
behiviour.
That unit test is creating a sample file using the export function and
afterthat is importing it with our import function and checks if content is the
same. I discovered that same export code is working fine when using HSSF or
XSSF but is not working properly when exporting with SXSSF. I notice that:
- The file exported with SXSSF can be open with excel and looks ok.
- Same file can be imported with XSSF but it imports as a excel with the
correct number of rows but with no cells on it
- If I just open the file with Excel and save it ( whithout changing anything
) the import will work fine ( so the problem seems to be fixed - so I presumed
that something is not saved correctly there )
- using XSSF to export with same code works also fine.
- the export and neither the import code does not throw any error or exception
I checked the code and compare it with examples and seems ok.
The file I save is pretty simple. It have only one sheet containg 3 columns and
100 rows which are filed with numbers formated as richtext strings.
Is there any workaround to avoid this problem for POI 3.8?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
