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