https://issues.apache.org/bugzilla/show_bug.cgi?id=57008
Bug ID: 57008
Summary: Wrting _x0427_ to a string cell changes the string to
some strange UTF-8 character
Product: POI
Version: 3.8-FINAL
Hardware: PC
Status: NEW
Severity: minor
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
I've created a Workbook using "new XSSFWorkbook()", created a sheet, a row and
a cell. Into this cell I wrote "sometext_x0427_sometext" using "setCellValue".
When storing the resulting workbook in a file and then try to open it with
Excel, Excel tells me that the file is corrupted. After saying "ok, repair the
file" I can see some strange character instead of the "_0x427_". If you send
the excel file from Web-Server to IE-Client over a response stream you cannot
even open the Excel data.
This seems to be an Excel "feature" and if you prepend this string with
"_0x005F" the string stays at it is.
Of course I might change my code and check the strings I want to write whether
they contain strings in a certain format and then prepend this "_0x005F". But I
think "nobody" knows about this feature and every one is wondering what
happened to their data.
So I think the prepending of "_0x005f" should happen in POI.
If a programmer wants to use this "feature" he might call a new POI function
i.e. setUseStrangeExcelFeature(true).
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
