Bug 62710 - SXSSFSheet.autoSizeColumn() doesn't run well for Asian characters.
Summary: SXSSFSheet.autoSizeColumn() doesn't run well for Asian characters.
Status: RESOLVED LATER
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-12 11:59 UTC by kevin
Modified: 2020-11-11 13:03 UTC (History)
1 user (show)


Attachments
Column A which contains Japanese characters (10.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-09-13 00:47 UTC, kevin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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?
Comment 3 Dominik Stadler 2020-03-08 09:37:38 UTC 
No additional information provided for a long time and we cannot properly reproduce this with the amount of information given, thus I have to cose this for now, please reopen with more information and source-code which reproduces the problem.
Comment 4 W T 2020-11-11 13:03:38 UTC 
Seems similar to https://bz.apache.org/bugzilla/show_bug.cgi?id=64811