Bug 51591

Summary:	org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,col,false) does not apply full HSSFCellStyle
Product:	POI	Reporter:	Peter Costello <peterwcostello>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	NEW ---
Severity:	normal
Priority:	P2
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	All

Description Peter Costello 2011-07-30 21:46:00 UTC

Bug in org.apache.poi.ss.util.SheetUtil.getColumnWidth() (or in code that creates/manipulates HSSFCellStyle).

Define HSSFCellStyle using an underscore, such as "_ \"C$\"* #,##0_);[Red]_ \"C$\"* (#,##0);".  Add HSSFCell using this style and set value to a number, eg "123456789".  Trap at line 173 in SheetUtil.java. Formatted text will be "C$123,456,7890", where the trailing '0' is used to provide the spacing for negative values.  The formatted text needs a leading space as specified by the format string. Net result is that the width returned by the function is slightly too small and when a written file is opened in Excel, the column will display "#########" because the column is too narrow.