Created attachment 38222 [details]
SXSSF doesn't support Rich Text Strings

Comment on attachment 38222 [details]
SXSSF doesn't support Rich Text Strings

Can you try using setCellValue(String) and adding a CellStyle with the right font to the cell?

I added r1898801 which includes a test case - the new rich text support only works with SXSSFWorkbook instances that have useSharedStringsTable=true - useSharedStringsTable defaults to false

(In reply to PJ Fanning from comment #3)
> I added r1898801 which includes a test case - the new rich text support only
> works with SXSSFWorkbook instances that have useSharedStringsTable=true -
> useSharedStringsTable defaults to false

when can i use it

There are no planned releases - we've recently done 2 releases and we normally only do 1 or 2 a year.

You could try the potential solution in Commment 2 or you can build POI yourself from the latest source files and use those jars.

(In reply to PJ Fanning from comment #3)
> I added r1898801 which includes a test case - the new rich text support only
> works with SXSSFWorkbook instances that have useSharedStringsTable=true -
> useSharedStringsTable defaults to false

You don't have permission to access this resource. ﷐[U+1F449]﷑﷐[U+1F3FB]﷑ r1898801

forbidden access, I want to have access.

https://svn.apache.org/viewvc?view=revision&revision=1898801 is a publicly accessible URL.

Talk to your ISP or your network admin.

Can you post the example code in the comments section? 
thanks!