Bug 61029

Summary:	The XSSF setCellValue with Unicode character produces a corrupt workbook
Product:	POI	Reporter:	gauss.gao <gauss.gao>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P2
Version:	3.15-FINAL
Target Milestone:	---
Hardware:	PC
OS:	Linux
Attachments:	the examples java file & result

Description gauss.gao 2017-04-24 06:07:21 UTC

The XSSF can't setcellvalue right to excel file when the world is "𤯥";
The HSSF would work good even if the world id "𤯥", but, Once I export file by using XSSF, the world was an unreadable world "??".

Here is some information that may helpfull:

1."𤯥" unicode:\ud852\udfe5
2."𤯥" Hexadecimal:F0 A4 AF A5

Comment 1 Javen O'Neal 2017-04-24 07:47:45 UTC

*** Bug 61030 has been marked as a duplicate of this bug. ***

Comment 2 Javen O'Neal 2017-04-24 07:52:42 UTC

POI has been used successfully with non-ASCII Unicode characters before, including version 3.15.

Can you include a code snippet so that we can reproduce the problem? What version of Excel are you using?

Comment 3 gauss.gao 2017-04-25 03:01:18 UTC

Created attachment 34948 [details]
the examples java file & result

Thank you for your kind reply.I have upload a zip file which include code & two pic.I will provide the all information what u need, thank u.

Comment 4 gauss.gao 2017-04-25 03:06:02 UTC

I run the code on win/linux , open file with excel2007/excel2010/excel2013.

Comment 5 Dominik Stadler 2017-05-27 21:00:03 UTC

This seems to be a duplicate of bug 54084, unfortunately this happens deep inside XmlBeans for some Unicode characters, likely the ones that require more than 2 bytes in UTF-8 (not sure what the actual Unicode-spec-term is here...).

*** This bug has been marked as a duplicate of bug 54084 ***