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 2013/09/25 11:24:43 UTC
[Bug 55594] New: SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
Bug ID: 55594
Summary: SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Product: POI
Version: 3.9
Hardware: Other
OS: other
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: c.pagenkopp@googlemail.com
Created attachment 30880
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30880&action=edit
Content of sheet1.xml in text editor and error messages by excel
Hello,
we are using the POI-API in version 3.9 on a z/OS system.
On this platform we have the default encoding "EBCDIC".
We are now facing problems using the SXXSFWorkbook.
We receive corrupt Excel-XML, because within "\xl\worksheets" the sheets are
corrupt.
The data between <sheetData> and </sheetData> is in wrong Encoding.
Please find attached a screenshot of the xml-content and the Excel message
boxes.
I think, that the writing into sheet-file will be done in platform encoding,
but writing of resulting workbook will explicity be done using "UTF-8".
Thanks and best regards
Constantin
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
--- Comment #4 from Paul Vonnahme <vo...@gmail.com> ---
Created attachment 31421
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31421&action=edit
Patch as described in previous comment
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
Constantin <c....@googlemail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME
--- Comment #1 from Constantin <c....@googlemail.com> ---
Hi all,
we found a way to fix this problem:
We changed method
Writer createWriter(File fd)
in org.apache.poi.xssf.streaming.GZIPSheetDataWriter and
org.apache.poi.xssf.streaming.SheetDataWriter.
Following changes have been done:
GZIPSheetDataWriter.createWriter(File fd) ... {
return new BufferedWriter(new OutputStreamWriter(new GZIPOutputStream(new
FileOutputStream(fd)), "UTF-8"));
}
SheetDataWriter.createWriter(File fd) ... {
return new BufferedWriter(new OutputStreamWriter(new FileOutputStream(fd),
"UTF-8"));
}
We force writing data with UTF-8 encoding, because the whole workbook will be
written in UTF-8 as well.
Best regards
Constantin
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution|--- |FIXED
--- Comment #5 from Nick Burch <ap...@gagravarr.org> ---
Thanks for the patch, applied in r1580314.
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
--- Comment #3 from Paul Vonnahme <vo...@gmail.com> ---
I can confirm the fix reported works for us as well.
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|WORKSFORME |---
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Reopen as I changing this in general sounds like the right thing to do to avoid
similar issues for other environments with other encodings as well.
--
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 55594] SXSSF producing corrupt workbooks on z/OS with
EBCDIC-Encoding
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55594
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |saipraveen.sai9@gmail.com
--- Comment #6 from Dominik Stadler <do...@gmx.at> ---
*** Bug 56999 has been marked as a duplicate of this bug. ***
--
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