https://bz.apache.org/bugzilla/show_bug.cgi?id=69650
--- Comment #2 from hasmukh ginoya <hasmukh.gin...@automationanywhere.com> ---
public String getCellValue() {
DataFormatter formatter = new DataFormatter();
String formattedCellValue = formatter.formatCellValue(cell, evaluator,
cfEvaluator);
CellType cellType = cell.getCellType();
if (CellType.NUMERIC.equals(cellType) &&
DateUtil.isCellDateFormatted(cell, cfEvaluator)) {
// get the index of the data format. Built in formats are defined
at BuiltinFormats.
if (cell.getCellStyle().getDataFormat() ==
BUILT_IN_DATE_FORMAT_INDEX) {
Date date = cell.getDateCellValue();
formattedCellValue = new
CellDateFormatter(DEFAULT_DATE_FORMAT).format(date);
}
formattedCellValue = formattedCellValue.replaceAll("\"",
StringUtils.EMPTY);
}
return formattedCellValue;
}
So when this call formatter.formatCellValue(cell, evaluator, cfEvaluator);
execute after set cell then it throws the exception Caused by:
java.lang.IllegalStateException: value changed
at
org.apache.poi.ss.formula.EvaluationCache.getPlainValueEntry(EvaluationCache.java:135)
~[?:?]
--
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
