[Bug 66899] Get cell value return dd/mm/yy when cell format is *dd-mm-yyyy. The expectation need to return year in 4 digit

[bugzilla]

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

--- Comment #10 from hasmukh ginoya <hasmukh.gin...@automationanywhere.com> ---
I have found this stack over flow link -
https://stackoverflow.com/questions/34900605/excel-cell-style-issue/34902174#34902174

Is it right solution for this ?
if (DateUtil.isCellDateFormatted(cell)) {
    Date date = cell.getDateCellValue();

    System.out.println(date);

    String dateFmt = "";

    if (cell.getCellStyle().getDataFormat() == 14) { //default short date
without explicit formatting
     dateFmt = "dd/mm/yyyy"; //default date format for this
    } else { //other data formats with explicit formatting
     dateFmt = cell.getCellStyle().getDataFormatString();
    }

    System.out.println("dateFmt " + dateFmt);

    String value = new CellDateFormatter(dateFmt).format(date);

    System.out.println("Date " + value);

   }

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