https://issues.apache.org/bugzilla/show_bug.cgi?id=57450
Bug ID: 57450
Summary: A way to autosize columns on SXSSF
Product: POI
Version: unspecified
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
So it makes sense why the standard "autoSize" mechanism doesn't function on
SXSSF Worksheets. However if you provided a tool which allows us to feed one
row at a time and keep track of the largest value for each column desired,
which can then be applied to the worksheet, we could get the autosize behavior
without having to loop through everything at the end.
tracker = new AutosizeTracker(sheet) // assume flush size is 10
tracker.monitorColumn(1)
tracker.monitorColumn(5)
...
tracker.trackRow(row1) // tracks widths, holds no reference to row1
tracker.trackRow(row2)
...
tracker.trackRow(row5000)
...
tracker.applyWidths();
I was considering writing one of these, but it seems that there is no well
factored tool for getting the width of a single cell with all the knowledge
cooked into the autoSizeColumn method of SXSSFSheet
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
