Bug 62710

Summary: SXSSFSheet.autoSizeColumn() doesn't run well for Asian characters.
Product: POI Reporter: kevin <kevin.kansin>
Component: SXSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: enhancement CC: kevin.kansin
Priority: P2    
Version: 3.17-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Column A which contains Japanese characters

Description kevin 2018-09-12 11:59:20 UTC
the width of the column is always smaller that expected when the value of cells contains Asian Characters.

*same error exists in version 4.0.0 Final.
Comment 1 kevin 2018-09-13 00:47:36 UTC
Created attachment 36149 [details]
Column A which contains Japanese characters

Column A which contains Japanese characters is set to smaller width than expected.
Comment 2 Nick Burch 2018-09-13 08:03:28 UTC
Does this only happen for SXSSF, or does it happen for XSSF and HSSF too? If SXSSF only, how are you setting up the column size tracking?

Do you have the relevant Asian fonts installed on your machine *and* properly available to Java?