[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    [Bug 66899] New: Get cell value return dd/mm/yy when cell format is *dd-mm-yyyy. The expectation nee
From:       bugzilla () apache ! org
Date:       2023-08-14 8:28:47
Message-ID: bug-66899-47293 () https ! bz ! apache ! org/bugzilla/
[Download RAW message or body]

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.ginoya@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]