You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2011/07/30 23:46:00 UTC

DO NOT REPLY [Bug 51591] New: org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,col,false) does not apply full HSSFCellStyle

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

DO NOT REPLY [Bug 51591] org.apache.poi.ss.util.SheetUtil.getColumnWidth(sheet,col,false) does not apply full HSSFCellStyle

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51591

Peter Costello <pe...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         OS/Version|                            |All

-- 
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