https://bz.apache.org/bugzilla/show_bug.cgi?id=66899
Bug ID: 66899 Summary: Get cell value return dd/mm/yy when cell format is *dd-mm-yyyy. The expectation need to return year in 4 digit Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: major Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: hasmukh.gin...@automationanywhere.com Target Milestone: --- Created attachment 38757 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38757&action=edit The Format cell is configured here This is my cell value 13-07-2019 Format cell is *dd-mm-yyyy When i try to get the cell value using Cell cell; // this is active cell FormulaEvaluator evaluator; // this is properly assing ConditionalFormattingEvaluator cfEvaluator; DataFormatter formatter = new DataFormatter(); String formattedCellValue = formatter.formatCellValue(cell, evaluator, cfEvaluator); CellType cellType = cell.getCellType(); // this return NUMERIC DateUtil.isCellDateFormatted(cell, cfEvaluator) // this return true String cellFormat = cell.getCellStyle().getDataFormatString(); // this return m/d/yy formattedCellValue value return me 7/13/19 - This is not return me the year in 4 digit -- 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