/** * set the error value for the cell. See {@link FormulaError} for valid codes. * * @param value error representing the error value * this value can only be 0,7,15,23,29,36 or 42 * see bugzilla bug 16560 for an explanation */ public void setValue(byte value) { setValue(FormulaError.forInt(value)); }
/** * set a boolean value for the cell * * @param value the boolean value to set this cell to. For formulas we'll set the * precalculated value, for booleans we'll set its value. For other types we * will change the cell to a boolean cell and set its value. */ @SuppressWarnings("fallthrough") public void setCellValue(boolean value) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CellType.BOOLEAN, false, row, col, styleIndex); // fall through case BOOLEAN: (( BoolErrRecord ) _record).setValue(value); break; case FORMULA: ((FormulaRecordAggregate)_record).setCachedBooleanResult(value); break; } }
/** * set a error value for the cell * * @param error the error value to set this cell to. For formulas we'll set the * precalculated value , for errors we'll set * its value. For other types we will change the cell to an error * cell and set its value. */ @SuppressWarnings("fallthrough") public void setCellErrorValue(FormulaError error) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CellType.ERROR, false, row, col, styleIndex); // fall through case ERROR: (( BoolErrRecord ) _record).setValue(error); break; case FORMULA: ((FormulaRecordAggregate)_record).setCachedErrorResult(error.getCode()); break; } }
/** * set the error value for the cell. See {@link FormulaError} for valid codes. * * @param value error representing the error value * this value can only be 0,7,15,23,29,36 or 42 * see bugzilla bug 16560 for an explanation */ public void setValue(byte value) { setValue(FormulaError.forInt(value)); }
/** * set a boolean value for the cell * * @param value the boolean value to set this cell to. For formulas we'll set the * precalculated value, for booleans we'll set its value. For other types we * will change the cell to a boolean cell and set its value. */ public void setCellValue(boolean value) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CELL_TYPE_BOOLEAN, false, row, col, styleIndex); case CELL_TYPE_BOOLEAN: (( BoolErrRecord ) _record).setValue(value); break; case CELL_TYPE_FORMULA: ((FormulaRecordAggregate)_record).setCachedBooleanResult(value); break; } }
/** * set a boolean value for the cell * * @param value the boolean value to set this cell to. For formulas we'll set the * precalculated value, for booleans we'll set its value. For other types we * will change the cell to a boolean cell and set its value. */ public void setCellValue(boolean value) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CELL_TYPE_BOOLEAN, false, row, col, styleIndex); case CELL_TYPE_BOOLEAN: (( BoolErrRecord ) _record).setValue(value); break; case CELL_TYPE_FORMULA: ((FormulaRecordAggregate)_record).setCachedBooleanResult(value); break; } }
/** * set a error value for the cell * * @param errorCode the error value to set this cell to. For formulas we'll set the * precalculated value , for errors we'll set * its value. For other types we will change the cell to an error * cell and set its value. */ public void setCellErrorValue(byte errorCode) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CELL_TYPE_ERROR, false, row, col, styleIndex); case CELL_TYPE_ERROR: (( BoolErrRecord ) _record).setValue(errorCode); break; case CELL_TYPE_FORMULA: ((FormulaRecordAggregate)_record).setCachedErrorResult(errorCode); break; } } /**
/** * set a boolean value for the cell * * @param value the boolean value to set this cell to. For formulas we'll set the * precalculated value, for booleans we'll set its value. For other types we * will change the cell to a boolean cell and set its value. */ @SuppressWarnings("fallthrough") public void setCellValue(boolean value) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CellType.BOOLEAN, false, row, col, styleIndex); // fall through case BOOLEAN: (( BoolErrRecord ) _record).setValue(value); break; case FORMULA: ((FormulaRecordAggregate)_record).setCachedBooleanResult(value); break; } }
/** * set a error value for the cell * * @param errorCode the error value to set this cell to. For formulas we'll set the * precalculated value , for errors we'll set * its value. For other types we will change the cell to an error * cell and set its value. */ public void setCellErrorValue(byte errorCode) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CELL_TYPE_ERROR, false, row, col, styleIndex); case CELL_TYPE_ERROR: (( BoolErrRecord ) _record).setValue(errorCode); break; case CELL_TYPE_FORMULA: ((FormulaRecordAggregate)_record).setCachedErrorResult(errorCode); break; } } /**
/** * set a error value for the cell * * @param error the error value to set this cell to. For formulas we'll set the * precalculated value , for errors we'll set * its value. For other types we will change the cell to an error * cell and set its value. */ @SuppressWarnings("fallthrough") public void setCellErrorValue(FormulaError error) { int row=_record.getRow(); short col=_record.getColumn(); short styleIndex=_record.getXFIndex(); switch (_cellType) { default: setCellType(CellType.ERROR, false, row, col, styleIndex); // fall through case ERROR: (( BoolErrRecord ) _record).setValue(error); break; case FORMULA: ((FormulaRecordAggregate)_record).setCachedErrorResult(error.getCode()); break; } }