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 ValueEvalprotected abstract booleanprotected abstract booleanpartialEvaluate(boolean cumulativeResult, boolean currentValue)
-
Field Details
-
AND
-
OR
-
FALSE
-
TRUE
-
NOT
-
-
Constructor Details
-
BooleanFunction
public BooleanFunction()
-
-
Method Details
-
evaluate
- Specified by:
evaluatein interfaceFunction- Parameters:
args- the evaluated function arguments. Empty values are represented withBlankEvalorMissingArgEval, 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.NaNbe sure to translate the result toErrorEval.NUM_ERROR.
-
getInitialResultValue
protected abstract boolean getInitialResultValue() -
partialEvaluate
protected abstract boolean partialEvaluate(boolean cumulativeResult, boolean currentValue)
-