https://issues.apache.org/bugzilla/show_bug.cgi?id=51591
Bug #: 51591
Summary: org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,
col,false) does not apply full HSSFCellStyle
Product: POI
Version: unspecified
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
