poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51591] New: org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,col,false) does not apply full HSSFCellStyle
Date Sat, 30 Jul 2011 21:46:00 GMT
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: dev@poi.apache.org
        ReportedBy: peterwcostello@gmail.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message