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 2012/05/30 09:14:09 UTC
[Bug 53323] New: Saving file with SXSSF produce a file that is not
read corectly with XFFS
https://issues.apache.org/bugzilla/show_bug.cgi?id=53323
Priority: P2
Bug ID: 53323
Assignee: dev@poi.apache.org
Summary: Saving file with SXSSF produce a file that is not read
corectly with XFFS
Severity: major
Classification: Unclassified
Reporter: l.curelaru@scarus.de
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 53323] Saving file with SXSSF produce a file that is not read
corectly with XFFS
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53323
--- Comment #3 from Lucian Curelaru <l....@scarus.de> ---
Oops.. it seems my second comment has been lost.
So... I'll write it again.
In the mean time I've done some debugging and find out that the problem was
somehow in my import code: the inline strings tags was not properly parsed in
my side.
It seems that with same unittest if I save a file with XSSF and SXSSF the
result is quite diffrent . With SXSSF the richtext cells are saved as inline
strings and with XSSF as shared strings. This mislead me and also the fact that
opening the file with excel and save it without any modification has fixed the
problem ( changed from inline to shared )
Still there is a kind of inconsistency. I expected to have same result with
same input if changing from XSSF to SXSSF.
So I've switched to weak priority and enhancement level.
--
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 53323] Saving file with SXSSF produce a file that is not read
corectly with XFFS
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53323
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> ---
> - 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
So you export data with SXSSF, read it back with XSSF and it does not see cells
on the rows, right? If so, a unit test please! Without a sample code it is hard
to tell what is wrong. It might be a bug in POI or a bug in your unit test.
--
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 53323] Saving file with SXSSF produce a file that is not read
corectly with XFFS
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53323
Lucian Curelaru <l....@scarus.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P5
Severity|major |enhancement
--- Comment #2 from Lucian Curelaru <l....@scarus.de> ---
Please see my last comment. It seems we wrote the coments in the same time :)
--
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