@Override protected void appendValueText(StringBuilder sb) { if (isBoolean()) { sb.append(" .boolVal = "); sb.append(getBooleanValue()); } else { sb.append(" .errCode = "); sb.append(FormulaError.forInt(getErrorValue()).getString()); sb.append(" (").append(HexDump.byteToHex(getErrorValue())).append(")"); } } @Override
/** * get the value of the cell as an error code. For strings, numbers, and booleans, we throw an exception. * For blank cells we return a 0. */ @Override public byte getErrorCellValue() { switch(_cellType) { case ERROR: return (( BoolErrRecord ) _record).getErrorValue(); case FORMULA: FormulaRecord fr = ((FormulaRecordAggregate)_record).getFormulaRecord(); checkFormulaCachedValueType(CellType.ERROR, fr); return (byte) fr.getCachedErrorValue(); default: throw typeMismatch(CellType.ERROR, _cellType, false); } }
return getBooleanCellValue()?"TRUE":"FALSE"; case ERROR: return ErrorEval.getText((( BoolErrRecord ) _record).getErrorValue()); case FORMULA: return getCellFormula();
return NumberToTextConverter.toText(((NumberRecord)_record).getValue()); case ERROR: return FormulaError.forInt(((BoolErrRecord)_record).getErrorValue()).getString(); case FORMULA:
@Override protected void appendValueText(StringBuilder sb) { if (isBoolean()) { sb.append(" .boolVal = "); sb.append(getBooleanValue()); } else { sb.append(" .errCode = "); sb.append(ErrorConstants.getText(getErrorValue())); sb.append(" (").append(HexDump.byteToHex(getErrorValue())).append(")"); } } @Override
@Override protected void appendValueText(StringBuilder sb) { if (isBoolean()) { sb.append(" .boolVal = "); sb.append(getBooleanValue()); } else { sb.append(" .errCode = "); sb.append(ErrorConstants.getText(getErrorValue())); sb.append(" (").append(HexDump.byteToHex(getErrorValue())).append(")"); } } @Override
@Override protected void appendValueText(StringBuilder sb) { if (isBoolean()) { sb.append(" .boolVal = "); sb.append(getBooleanValue()); } else { sb.append(" .errCode = "); sb.append(FormulaError.forInt(getErrorValue()).getString()); sb.append(" (").append(HexDump.byteToHex(getErrorValue())).append(")"); } } @Override
/** * get the value of the cell as an error code. For strings, numbers, and booleans, we throw an exception. * For blank cells we return a 0. */ public byte getErrorCellValue() { switch(_cellType) { case CELL_TYPE_ERROR: return (( BoolErrRecord ) _record).getErrorValue(); default: throw typeMismatch(CELL_TYPE_ERROR, _cellType, false); case CELL_TYPE_FORMULA: break; } FormulaRecord fr = ((FormulaRecordAggregate)_record).getFormulaRecord(); checkFormulaCachedValueType(CELL_TYPE_ERROR, fr); return (byte) fr.getCachedErrorValue(); }
/** * get the value of the cell as an error code. For strings, numbers, and booleans, we throw an exception. * For blank cells we return a 0. */ @Override public byte getErrorCellValue() { switch(_cellType) { case ERROR: return (( BoolErrRecord ) _record).getErrorValue(); case FORMULA: FormulaRecord fr = ((FormulaRecordAggregate)_record).getFormulaRecord(); checkFormulaCachedValueType(CellType.ERROR, fr); return (byte) fr.getCachedErrorValue(); default: throw typeMismatch(CellType.ERROR, _cellType, false); } }
/** * get the value of the cell as an error code. For strings, numbers, and booleans, we throw an exception. * For blank cells we return a 0. */ public byte getErrorCellValue() { switch(_cellType) { case CELL_TYPE_ERROR: return (( BoolErrRecord ) _record).getErrorValue(); default: throw typeMismatch(CELL_TYPE_ERROR, _cellType, false); case CELL_TYPE_FORMULA: break; } FormulaRecord fr = ((FormulaRecordAggregate)_record).getFormulaRecord(); checkFormulaCachedValueType(CELL_TYPE_ERROR, fr); return (byte) fr.getCachedErrorValue(); }
return getBooleanCellValue()?"TRUE":"FALSE"; case CELL_TYPE_ERROR: return ErrorEval.getText((( BoolErrRecord ) _record).getErrorValue()); case CELL_TYPE_FORMULA: return getCellFormula();
return getBooleanCellValue()?"TRUE":"FALSE"; case CELL_TYPE_ERROR: return ErrorEval.getText((( BoolErrRecord ) _record).getErrorValue()); case CELL_TYPE_FORMULA: return getCellFormula();
return getBooleanCellValue()?"TRUE":"FALSE"; case ERROR: return ErrorEval.getText((( BoolErrRecord ) _record).getErrorValue()); case FORMULA: return getCellFormula();
return NumberToTextConverter.toText(((NumberRecord)_record).getValue()); case CELL_TYPE_ERROR: return HSSFErrorConstants.getText(((BoolErrRecord) _record).getErrorValue()); case CELL_TYPE_FORMULA:
return NumberToTextConverter.toText(((NumberRecord)_record).getValue()); case CELL_TYPE_ERROR: return HSSFErrorConstants.getText(((BoolErrRecord) _record).getErrorValue()); case CELL_TYPE_FORMULA:
return NumberToTextConverter.toText(((NumberRecord)_record).getValue()); case ERROR: return FormulaError.forInt(((BoolErrRecord)_record).getErrorValue()).getString(); case FORMULA:
return brec.getBooleanValue(); } else { return FormulaError.forInt(brec.getErrorValue()).getString();