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 20061] New: - Can not set data format to a cell style which consist from date and time (e.g : m/d/yy h:mm:ss), problem with time
Date Tue, 20 May 2003 14:29:27 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20061>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20061

Can not set data format to a cell style which consist from date and time (e.g : m/d/yy h:mm:ss),
problem with time

           Summary: Can not set data format to a cell style which consist
                    from date and time (e.g : m/d/yy h:mm:ss), problem with
                    time
           Product: POI
           Version: unspecified
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ranl@amdocs.com


when trying to set cell style format to m/d/yy h:mm then cell value in excel is 
fine. 
but setting format to m/d/yy h:mm:ss then seconds does not appear.

HSSFCellStyle dateCellStyle;
dateCellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy h:mm:ss"));

Mime
View raw message