https://bz.apache.org/bugzilla/show_bug.cgi?id=66620
Bug ID: 66620
Summary: Heap dump when using SXSSF for large XLSX files
containing RichTextStrings
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: t.greger...@elsevier.com
Target Milestone: ---
Created attachment 38567
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38567&action=edit
Export of many RichTextStrings with font styles To Excel
If you create Excel (XLSX) files using SXSSF and you want to have font
attributes (e.g. sub and superscript) applied to sub parts of a string then you
have to use RichTextStrings. Currently, it is only possible to get it to work
with SXSSF if you set the parameter 'useSharedStringTable' to 'true' on the
SXSSFWorkbook.
Setting 'useSharedStringTable' to 'true' will make it store the strings in
memory in a structure which encapsulates the string. The problem is that when
the Workbook flush its rows it does not clear the structure containing the
string data. Hence, it piles up when you export many rows and may eventually
result in a heap dump depending on the number of rows being exported and the
available memory.
When using SXSSF and 'useSharedStringTable' set to 'true' then it should clear
the underlying structure for the rows which has been flushed in order to keep
memory consumption low.
I've attached a little Java example which can be used to reproduce the problem.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
