| Summary: | HSSFSheet autosizeColumn() doesn't process formula cells | ||
|---|---|---|---|
| Product: | POI | Reporter: | Maksym Symonov <Maksym_Symonov> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.2-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
|
Description
Maksym Symonov
2009-02-19 06:44:30 UTC
HSSFSheet.autosizeColumn() operates on static, i.e. non-formula cell values. It wasn't written with formula evaluation in mind and I don't think we should change it that way. However, your post suggests a natural improvement to use the cached formula result when autosizing columns. If the cached value is wrong or out of date, you can use HSSFFormulaEvaluator to update it. Yegor |