Hi, I am using... DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator) ...to format a Cell containing a Date.
My (german) Excel shows the Date as follows: "14. Jan" (with a space between the dot and the "J" & no quotes) cell.getCellStyle().getDataFormatString() returns "d-mmm" whereas Excel has a user-defined format of "TT. MMM" (german for "DD. MMM"). DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator) returns "14-Jan" (Likewise, poi formatted Excels "14. Mrz" as "14-Mrz", so the language formatting is ok) Is this a bug? Can anyone help me get the correct results? Best Regards, DaveLaw --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
