Class BooleanFunction
java.lang.Object
org.apache.poi.ss.formula.functions.BooleanFunction
- All Implemented Interfaces:
Function
Here are the general rules concerning Boolean functions:
- Blanks are ignored (not either true or false)
- Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false'
- Numbers: 0 is false. Any other number is TRUE
- Areas: *all* cells in area are evaluated according to the above rules
- Author:
- Amol S. Deshmukh < amolweb at ya hoo dot com >
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionfinal ValueEval
protected abstract boolean
protected abstract boolean
partialEvaluate
(boolean cumulativeResult, boolean currentValue)
-
Field Details
-
AND
-
OR
-
FALSE
-
TRUE
-
NOT
-
-
Constructor Details
-
BooleanFunction
public BooleanFunction()
-
-
Method Details
-
evaluate
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, nevernull
.srcRow
- row index of the cell containing the formula under evaluationsrcCol
- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval
, nevernull
. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaN
be sure to translate the result toErrorEval.NUM_ERROR
.
-
getInitialResultValue
protected abstract boolean getInitialResultValue() -
partialEvaluate
protected abstract boolean partialEvaluate(boolean cumulativeResult, boolean currentValue)
-