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

Reply via email to