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(). TY -Clive
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: http://encore.torchbox.com/poi-cvs-build/ Yegor *** This bug has been marked as a duplicate of bug 50211 ***