@Override public int getErrorCellValue() { return _cell.getErrorCellValue(); } @Override
return getBooleanCellValue() ? TRUE : FALSE; case ERROR: return ErrorEval.getText(getErrorCellValue()); default: return "Unknown Cell Type: " + getCellType();
@Override public int getErrorCellValue() { return _cell.getErrorCellValue(); } @Override
public int getErrorCellValue() { return _cell.getErrorCellValue(); } public double getNumericCellValue() {
case 5: cellTypeDesc = "ERROR"; byte byteValue = cell.getErrorCellValue(); cellValue = "" + byteValue; break;
break; case XSSFCell.CELL_TYPE_ERROR : builder.append(cell.getErrorCellValue()).append(" "); break; case XSSFCell.CELL_TYPE_STRING :
value[r][c] = ""+cell.getErrorCellValue(); break; default:
return getBooleanCellValue() ? TRUE : FALSE; case ERROR: return ErrorEval.getText(getErrorCellValue()); default: return "Unknown Cell Type: " + getCellType();
break; case ERROR: cellValue = cell.getErrorCellValue(); break;
public Object evaluate(XLXContext context) throws Exception { switch (cell.getCellType()) { case Cell.CELL_TYPE_BLANK : return ""; case Cell.CELL_TYPE_NUMERIC : return cell.getNumericCellValue(); case Cell.CELL_TYPE_STRING : return cell.getStringCellValue(); case Cell.CELL_TYPE_FORMULA : return cell.getCTCell().getV(); case Cell.CELL_TYPE_BOOLEAN : return cell.getBooleanCellValue(); case Cell.CELL_TYPE_ERROR : return cell.getErrorCellValue(); default: return null; } }
/** * Returns a string representation of the cell * <p> * Formula cells return the formula string, rather than the formula result. * Dates are displayed in dd-MMM-yyyy format * Errors are displayed as #ERR<errIdx> * </p> */ public String toString() { switch (getCellType()) { case CELL_TYPE_BLANK: return ""; case CELL_TYPE_BOOLEAN: return getBooleanCellValue() ? "TRUE" : "FALSE"; case CELL_TYPE_ERROR: return ErrorEval.getText(getErrorCellValue()); case CELL_TYPE_FORMULA: return getCellFormula(); case CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(this)) { DateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy"); return sdf.format(getDateCellValue()); } return getNumericCellValue() + ""; case CELL_TYPE_STRING: return getRichStringCellValue().toString(); default: return "Unknown Cell Type: " + getCellType(); } }
break; case Cell.CELL_TYPE_ERROR: cellNew.setCellValue(cellOld.getErrorCellValue()); break; case Cell.CELL_TYPE_FORMULA:
break; case HSSFCell.CELL_TYPE_ERROR: targetCell.setCellErrorValue(sourceCell.getErrorCellValue()); break; case HSSFCell.CELL_TYPE_FORMULA:
break; case Cell.CELL_TYPE_ERROR: sheetCell.setCellValue(tplSheetCell.getErrorCellValue()); break; case Cell.CELL_TYPE_FORMULA: