Bug 65943

Summary: SXSSF doesn't support Rich Text Strings
Product: POI Reporter: 284088891 <284088891>
Component: SXSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 5.2.0-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: SXSSF doesn't support Rich Text Strings

Description 284088891@qq.com 2022-03-09 02:28:31 UTC

    
Comment 1 284088891@qq.com 2022-03-09 02:46:58 UTC
Created attachment 38222 [details]
SXSSF doesn't support Rich Text Strings
Comment 2 PJ Fanning 2022-03-09 11:43:29 UTC
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?
Comment 3 PJ Fanning 2022-03-09 20:08:59 UTC
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
Comment 4 284088891@qq.com 2022-03-10 00:49:51 UTC
(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
Comment 5 PJ Fanning 2022-03-10 10:52:49 UTC
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.
Comment 6 yrc 2023-02-08 14:06:38 UTC
(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. 👉🏻 r1898801

forbidden access, I want to have access.
Comment 7 PJ Fanning 2023-02-08 14:11:56 UTC
https://svn.apache.org/viewvc?view=revision&revision=1898801 is a publicly accessible URL.

Talk to your ISP or your network admin.
Comment 8 yrc 2023-02-08 15:09:31 UTC
Can you post the example code in the comments section? 
thanks!