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 2017/03/08 04:48:05 UTC
[Bug 60832] New: export xlsx file sometimes can not open using ms
office
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
Bug ID: 60832
Summary: export xlsx file sometimes can not open using ms
office
Product: POI
Version: 3.15-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: icewee@126.com
Target Milestone: ---
Created attachment 34807
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34807&action=edit
ok and error excel files
when I use SXSSF export excel, sometimes can not open, I don't know why.
There is nothing exceptions or errors print.
The broken file's size lager than the file which can open.
The broken file has no author, the right file has author named Apache POI.
The bottom is the OK.xlsx and error.xlsx files.
Help me to find the reason, Thanks!
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|INVALID |---
--- Comment #6 from Nick Burch <ap...@gagravarr.org> ---
Based on your description, it sounds like there might be a bug in how we're
escaping one of the more complicated/less-common values, when writing to the
cell
For your problem file, if I open it in Excel 2010 I get the same error, with
the same line/column. However, reading the unzipped .xlsx file I can't see
anything wrong with the XML at the position indicated. (Does Excel count
differently?)
xmllint is happy with the file, as is libreoffice
For the problematic file, would you be able to change your export logic to
write a new file every 10 lines instead, and then share with us the smaller
problematic file with just 10 lines in that fails the same way?
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
--- Comment #3 from IceWee <ic...@126.com> ---
(In reply to Javen O'Neal from comment #1)
> > sometimes
> For the same input file and code, do you always get a corrupt file?
>
> Can you include the code you used that resulted in corrupt files?
below codes:
cell = row.createCell(cellnum);
cell.setCellValue(value);
the value is from database, if I change the value to common string such as
"hello", export file is OK. But sometimes(debugging) change nothing it's OK.
Crazy....
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
--- Comment #2 from IceWee <ic...@126.com> ---
Thans for your reply!
Using the same code, some data export correctly, open is ok, but some data
failed.
I think whether some special word/sign/char make excel-cell wrong, xml wrong...
This is Microsoft Office Excel's error tips:
Excel file level has been completed verification and repair.This workbook parts
may have been repaired or discarded.
Replaced parts: XML errors/xl/worksheets/sheet1.xml.The attribute value cannot
contain the '<'.Line 1880, 370.
I have checked the OK.xlsx and Error.xlsx, it's the
same,/xl/worksheets/sheet1.xml the same.
Whether compress zip error? when I changed xlsx to zip, overrides Error file's
sheet1.xml with the OK's, WINRAR tip "Compressed file damage"
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #4 from Javen O'Neal <on...@apache.org> ---
(In reply to IceWee from comment #3)
> below codes:
> cell = row.createCell(cellnum);
> cell.setCellValue(value);
This isn't sufficient for me to reproduce this problem. See http://sscce.org
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
IceWee <ic...@126.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INVALID
Status|NEEDINFO |RESOLVED
--- Comment #5 from IceWee <ic...@126.com> ---
I am sorry. I really don't know how to desc.
Maybe the data caused.
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INVALID
Status|REOPENED |RESOLVED
--- Comment #8 from Dominik Stadler <do...@gmx.at> ---
I tried to take a look at the ERROR.xlsx, but the file is an invalid ZIP file,
so it seems the process which created this file somehow corrupted the whole
zip.
Exception in thread "main" java.io.IOException: central directory is empty,
can't expand corrupt archive.
at
org.apache.commons.compress.archivers.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:528)
at
org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:216)
at
org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:192)
at
org.apache.commons.compress.archivers.zip.ZipFile.<init>(ZipFile.java:153)
at
org.apache.poi.openxml4j.util.ZipSecureFile.<init>(ZipSecureFile.java:122)
at
org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:205)
at
org.apache.poi.ooxml.dev.OOXMLPrettyPrint.handleFile(OOXMLPrettyPrint.java:90)
at
org.apache.poi.ooxml.dev.OOXMLPrettyPrint.main(OOXMLPrettyPrint.java:81)
So I don't think we can do much more here unless we know more about how the
file is produced.
If you still have this problem and can provide a more isolated test-case then
please reopen this issue and attach the test-case.
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
--- Comment #7 from IceWee <ic...@126.com> ---
I've no idea.
If I export part data it's OK, for example, 100 rows, 10 rows.
When I export top 714 rows it's failed. So I think 714 row is problem data.
Then I export only 714 row, it's OK...Crazy....
It's work well export other Tables. SO I give up...
--
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 60832] export xlsx file sometimes can not open using ms office
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60832
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
> sometimes
For the same input file and code, do you always get a corrupt file?
Can you include the code you used that resulted in corrupt files?
--
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