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

Reply via email to