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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
