https://bz.apache.org/bugzilla/show_bug.cgi?id=65619
--- Comment #2 from hethal <hethal.j...@gmail.com> --- here is the code that we are using in our app return new DataFormatter() { @Override public String formatRawCellContents (double value, int formatIndex, String formatString) { if ("GENERAL".equalsIgnoreCase(formatString)) { return decimalFormat.format(value); } else if (DateUtil.isADateFormat(formatIndex, formatString) && DateUtil.isValidExcelDate(value)) { DateFormat dateFormat; if (StringUtils.containsIgnoreCase(formatString, "h")) { dateFormat = new SimpleDateFormat("dd MMM yyyy HH:mm:ss"); } else { dateFormat = new SimpleDateFormat("dd MMM yyyy"); } Date date = DateUtil.getJavaDate(value, false); return dateFormat.format(date); } else { return super.formatRawCellContents(value, formatIndex, formatString); } } }; -- 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