Bug 25695

Summary: String formula return swap byte unicode characters
Product: POI Reporter: Sompop Kumnoonsate <sompopk>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P3    
Version: 2.0-pre3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: Test data
Test case

Description Sompop Kumnoonsate 2003-12-22 12:46:45 UTC 
HSSFCell.getStringCellValue() on cell which has string formula will return 
swap bye unicode characters.
For example, cell A1 contains "\u0e2a\u0e2b" and cell A2 contains string 
formula "=A1". If we getStringCellValue from cell A2 we will 
get "\u2a0e\u2b0e". It returns correct value if the return string in US 
codepage.
Comment 1 Sompop Kumnoonsate 2003-12-26 07:50:49 UTC 
Created attachment 9704 [details]
Test data
Comment 2 Sompop Kumnoonsate 2003-12-26 07:51:45 UTC 
Created attachment 9705 [details]
Test case
Comment 3 Avik Sengupta 2004-01-01 17:34:55 UTC 
Ooops! More proof that the way excel handles unicode leaves much to be desired!

Fixed. Thanks for a good bug report, in particular, great testcase. I wouldnt
have been able to fix it so soon without the testcases.