[Bug 58607] DateTime formatting

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=58607

--- Comment #5 from Dominik Stadler <dominik.stad...@gmx.at> ---
Testcase which I used with manual verification in Excel:

@Test
    public void test58607() throws IOException {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFCellStyle style = wb.createCellStyle();

        style.setDataFormat(wb.createDataFormat().getFormat("dd/MM/yyyy
HH:mm:ss"));

        final Cell cell = wb.createSheet("test").createRow(0).createCell(0);
        cell.setCellType(Cell.CELL_TYPE_NUMERIC);
        cell.setCellStyle(style);
        cell.setCellValue(new Date());

        OutputStream out = new FileOutputStream("C:\\temp\\58607.xls");
        try {
            wb.write(out);
        } finally {
            out.close();
        }
    }

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org