[Bug 57008] Wrting _x0427_ to a string cell changes the string to some strange UTF-8 character

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=57008

--- Comment #7 from carlo.dellacqua <ca...@ext.piksel.it> ---
Created attachment 32621
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32621&action=edit
Test classes and description of the results

Test_xNNNN_inCell is a test class which calls setCellValue(...) (for
XSSF,SXSSF, HSSF) to write a text string containing the substring "_x0046_";
Utils is a class which contains methods used to escape the previous code;
Test_xNNNN_inCell_HSSF.xls, Test_xNNNN_inCell_XSSF.xlsx,
Test_xNNNN_inCell_SXSSF.xlsx are the excel files written by the test class.

Test_xNNNN_inCell_HSSF.xls contains:
row 0, cell 0 _x0046_ without changes
row 0, cell 1 _x005f_x0046_ with changes
that is the right original and escaped text strings.

Test_xNNNN_inCell_XSSF.xlsx contains:
row 0, cell 0 F without changes
row 0, cell 1 _x0046_ with changes
that is the first cell contains 'F' which is the character related to the
unicode x0046, which is the text written in the cell,
the second cell contains the expected text "_x0046_", obtained adding the text
"_x005F".

-- 
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