Bug 51740

Summary: SXSSFSheet autoSizeColumn not considering all rows
Product: POI Reporter: jerome.neuville
Component: SXSSFAssignee: POI Developers List <dev>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: P2    
Version: 3.8-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description jerome.neuville 2011-08-29 15:26:37 UTC
The autoSizeColumn method deals only with the last rows flushed. I would like do an autosize when all rows are flushed. It's not possible with POI-3.8 beta 4 and an SXSSFWorkbook.
Comment 1 Nick Burch 2011-08-29 15:49:00 UTC
This is as expected. SXSSF only has the un-flushed data around to decide based on. If it kept more, then you'd loose all the memory benefits!

You should either use regular XSSF (and ensure you have enough memory), or adjust the flush size
Comment 2 Stefan Thurnherr 2015-12-07 19:45:37 UTC
FYI: This has been solved in 3.14beta1, see #57450 .
Comment 3 Javen O'Neal 2015-12-07 19:50:23 UTC

*** This bug has been marked as a duplicate of bug 57450 ***