Bug 50415 - sheet.autoSizeColumn() uses formula text.
Summary: sheet.autoSizeColumn() uses formula text.
Status: RESOLVED DUPLICATE of bug 50211
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-12-05 23:17 UTC by Clive Paterson
Modified: 2010-12-06 02:35 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Clive Paterson 2010-12-05 23:17:24 UTC
The HSSFSheet.autoSizeColumn() function is using the formula text (ie, C3+C5+C6+C7+C8+C9+C10) to derive a column width instead of inspecting the result of the formula to derive a column width.

Note: Only applies to cells using HSSFCell.setCellFormula().

Comment 1 Yegor Kozlov 2010-12-06 02:35:18 UTC
This was fixed in r1033005. Note, that the fix is not included in POI-3.7. You should try with the latest nightly build from here:



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