Parameter descriptions
range	is the range of cells to be counted based on the criteria
criteria	is used to determine which cells to count

Modifier and Type	Class and Description
private static class	Countif.BooleanMatcher
private static class	Countif.CmpOp
public static class	Countif.ErrorMatcher
private abstract static class	Countif.MatcherBase
private static class	Countif.NumberMatcher
public static class	Countif.StringMatcher

Access	Constructor and Description
public	Countif()

Method Summary

Modifier and Type	Method and Description
private double	Returns: the number of evaluated cells in the range that match the specified criteria countMatchingCellsInArea(ValueEval rangeArg, CountUtils.I_MatchPredicate criteriaPredicate)
pack-priv static CountUtils.I_MatchPredicate	Returns: `null` if the arg evaluates to blank. createCriteriaPredicate(ValueEval arg, int srcRowIndex, int srcColumnIndex) Creates a criteria predicate object for the supplied criteria arg
private static CountUtils.I_MatchPredicate	createGeneralMatchPredicate(StringEval stringEval) When the second argument is a string, many things are possible
public ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate. see `Function#evaluate(ValueEval[], int, int)`
private static ValueEval	Returns: the de-referenced criteria arg (possibly `ErrorEval`) evaluateCriteriaArg(ValueEval arg, int srcRowIndex, int srcColumnIndex)
pack-priv static Boolean	Returns: `null` to represent blank values parseBoolean(String strRep) Boolean literals ('TRUE', 'FALSE') treated similarly but NOT same as numbers.
private static ErrorEval	parseError(String value)

Inherited from org.apache.poi.ss.formula.functions.Fixed2ArgFunction:: evaluate

Countif	back to summary
public Countif()

Method Detail

countMatchingCellsInArea	back to summary
private double countMatchingCellsInArea(ValueEval rangeArg, CountUtils.I_MatchPredicate criteriaPredicate) Returns:double the number of evaluated cells in the range that match the specified criteria

createCriteriaPredicate back to summary

createCriteriaPredicate	back to summary
pack-priv static CountUtils.I_MatchPredicate createCriteriaPredicate(ValueEval arg, int srcRowIndex, int srcColumnIndex) Creates a criteria predicate object for the supplied criteria arg Returns:CountUtils.I_MatchPredicate `null` if the arg evaluates to blank.

pack-priv static CountUtils.I_MatchPredicate createCriteriaPredicate(ValueEval arg, int srcRowIndex, int srcColumnIndex)

Creates a criteria predicate object for the supplied criteria arg

Returns:CountUtils.I_MatchPredicate: null if the arg evaluates to blank.

createGeneralMatchPredicate	back to summary
private static CountUtils.I_MatchPredicate createGeneralMatchPredicate(StringEval stringEval) When the second argument is a string, many things are possible

evaluate back to summary

evaluate	back to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate. Doc from org.apache.poi.ss.formula.functions.Function2Arg.evaluate. see `Function#evaluate(ValueEval[], int, int)` Annotations @Override

public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)

Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Annotations

@Override

evaluateCriteriaArg	back to summary
private static ValueEval evaluateCriteriaArg(ValueEval arg, int srcRowIndex, int srcColumnIndex) Returns:ValueEval the de-referenced criteria arg (possibly `ErrorEval`)

parseBoolean back to summary

parseBoolean	back to summary
pack-priv static Boolean parseBoolean(String strRep) Boolean literals ('TRUE', 'FALSE') treated similarly but NOT same as numbers. Returns:Boolean `null` to represent blank values

pack-priv static Boolean parseBoolean(String strRep)

Boolean literals ('TRUE', 'FALSE') treated similarly but NOT same as numbers.

Returns:Boolean: null to represent blank values

parseError	back to summary
private static ErrorEval parseError(String value)

org.apache.poi.ss.formula.functions back to summary

private final Class Countif.BooleanMatcher

Class Inheritance

extends MatcherBase

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.MatcherBase
org.apache.poi.ss.formula.functions.Countif.BooleanMatcher

Field Summary

Modifier and Type	Field and Description
private final int	_value

Constructor Summary

Access	Constructor and Description
public	BooleanMatcher(boolean value, Countif.CmpOp operator)

Method Summary

Modifier and Type	Method and Description
private static int	boolToInt(boolean value)
protected String	getValueText() Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.
public boolean	matches(ValueEval x) Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Inherited from org.apache.poi.ss.formula.functions.Countif.MatcherBase:: evaluate evaluate getCode toString

Field Detail

_value	back to summary
private final int _value

Constructor Detail

BooleanMatcher	back to summary
public BooleanMatcher(boolean value, Countif.CmpOp operator)

Method Detail

boolToInt	back to summary
private static int boolToInt(boolean value)

getValueText	back to summary
protected String getValueText() Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText. Annotations @Override

getValueText

back to summary

protected String getValueText()

Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.

Annotations

@Override

matches	back to summary
public boolean matches(ValueEval x) Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches. Annotations @Override

matches

back to summary

public boolean matches(ValueEval x)

Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Annotations

@Override

org.apache.poi.ss.formula.functions back to summary

private final Class Countif.CmpOp

Class Inheritance

extends Object

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.CmpOp

Field Summary

Modifier and Type	Field and Description
private final int	_code
private final String	_representation
public static final int	EQ
public static final int	GE
public static final int	GT
public static final int	LE
public static final int	LT
public static final int	NE
public static final int	NONE
public static final Countif.CmpOp	OP_EQ
public static final Countif.CmpOp	OP_GE
public static final Countif.CmpOp	OP_GT
public static final Countif.CmpOp	OP_LE
public static final Countif.CmpOp	OP_LT
public static final Countif.CmpOp	OP_NE
public static final Countif.CmpOp	OP_NONE

Constructor Summary

Access	Constructor and Description
private	CmpOp(String representation, int code)

Method Summary

Modifier and Type	Method and Description
public boolean	evaluate(boolean cmpResult)
public boolean	evaluate(int cmpResult)
public int	getCode()
public int	Returns: number of characters used to represent this operator getLength()
public static Countif.CmpOp	getOperator(String value)
public String	getRepresentation()
private static Countif.CmpOp	op(String rep, int code)
public String	toString() Overrides java.lang.Object.toString. Returns a string representation of the object.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll wait wait wait

Field Detail

_code	back to summary
private final int _code

_representation	back to summary
private final String _representation

EQ	back to summary
public static final int EQ

GE	back to summary
public static final int GE

GT	back to summary
public static final int GT

LE	back to summary
public static final int LE

LT	back to summary
public static final int LT

NE	back to summary
public static final int NE

NONE	back to summary
public static final int NONE

OP_EQ	back to summary
public static final Countif.CmpOp OP_EQ

OP_GE	back to summary
public static final Countif.CmpOp OP_GE

OP_GT	back to summary
public static final Countif.CmpOp OP_GT

OP_LE	back to summary
public static final Countif.CmpOp OP_LE

OP_LT	back to summary
public static final Countif.CmpOp OP_LT

OP_NE	back to summary
public static final Countif.CmpOp OP_NE

OP_NONE	back to summary
public static final Countif.CmpOp OP_NONE

Constructor Detail

CmpOp	back to summary
private CmpOp(String representation, int code)

Method Detail

evaluate	back to summary
public boolean evaluate(boolean cmpResult)

evaluate	back to summary
public boolean evaluate(int cmpResult)

getCode	back to summary
public int getCode()

getLength	back to summary
public int getLength() Returns:int number of characters used to represent this operator

getOperator	back to summary
public static Countif.CmpOp getOperator(String value)

getRepresentation	back to summary
public String getRepresentation()

op	back to summary
private static Countif.CmpOp op(String rep, int code)

toString back to summary

toString	back to summary
public String toString() Overrides java.lang.Object.toString. Doc from java.lang.Object.toString. Returns a string representation of the object. Satisfying this method's contract implies a non-`null` result must be returned. Returns:String a string representation of the object Annotations @Override

public String toString()

Overrides java.lang.Object.toString.

Doc from java.lang.Object.toString.

Returns a string representation of the object. Satisfying this method's contract implies a non-null result must be returned.

Returns:String

a string representation of the object

Annotations

@Override

org.apache.poi.ss.formula.functions back to summary

public final Class Countif.ErrorMatcher

Class Inheritance

extends MatcherBase

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.MatcherBase
org.apache.poi.ss.formula.functions.Countif.ErrorMatcher

Field Summary

Modifier and Type	Field and Description
private final int	_value

Constructor Summary

Access	Constructor and Description
public	ErrorMatcher(int errorCode, Countif.CmpOp operator)

Method Summary

Modifier and Type	Method and Description
public int	getValue()
protected String	getValueText() Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.
public boolean	matches(ValueEval x) Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Inherited from org.apache.poi.ss.formula.functions.Countif.MatcherBase:: evaluate evaluate getCode toString

Field Detail

_value	back to summary
private final int _value

Constructor Detail

ErrorMatcher	back to summary
public ErrorMatcher(int errorCode, Countif.CmpOp operator)

Method Detail

getValue	back to summary
public int getValue()

getValueText

back to summary

protected String getValueText()

Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.

Annotations

@Override

matches

back to summary

public boolean matches(ValueEval x)

Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Annotations

@Override

org.apache.poi.ss.formula.functions back to summary

private abstract Class Countif.MatcherBase

Class Inheritance

extends Object
implements I_MatchPredicate

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.MatcherBase

All Implemented Interfaces

org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate

Known Direct Subclasses

org.apache.poi.ss.formula.functions.Countif.NumberMatcher, org.apache.poi.ss.formula.functions.Countif.BooleanMatcher, org.apache.poi.ss.formula.functions.Countif.ErrorMatcher, org.apache.poi.ss.formula.functions.Countif.StringMatcher

Field Summary

Modifier and Type	Field and Description
private final Countif.CmpOp	_operator

Constructor Summary

Access	Constructor and Description
pack-priv	MatcherBase(Countif.CmpOp operator)

Method Summary

Modifier and Type	Method and Description
protected final boolean	evaluate(int cmpResult)
protected final boolean	evaluate(boolean cmpResult)
protected final int	getCode()
protected abstract String	getValueText()
public final String	toString() Overrides java.lang.Object.toString. Returns a string representation of the object.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll wait wait wait

Field Detail

_operator	back to summary
private final Countif.CmpOp _operator

Constructor Detail

MatcherBase	back to summary
pack-priv MatcherBase(Countif.CmpOp operator)

Method Detail

evaluate	back to summary
protected final boolean evaluate(int cmpResult)

evaluate	back to summary
protected final boolean evaluate(boolean cmpResult)

getCode	back to summary
protected final int getCode()

getValueText	back to summary
protected abstract String getValueText()

toString back to summary

public final String toString()

Overrides java.lang.Object.toString.

Doc from java.lang.Object.toString.

Returns a string representation of the object. Satisfying this method's contract implies a non-null result must be returned.

Returns:String

a string representation of the object

Annotations

@Override

org.apache.poi.ss.formula.functions back to summary

private final Class Countif.NumberMatcher

Class Inheritance

extends MatcherBase

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.MatcherBase
org.apache.poi.ss.formula.functions.Countif.NumberMatcher

Field Summary

Modifier and Type	Field and Description
private final double	_value

Constructor Summary

Access	Constructor and Description
public	NumberMatcher(double value, Countif.CmpOp operator)

Method Summary

Modifier and Type	Method and Description
protected String	getValueText() Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.
public boolean	matches(ValueEval x) Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Inherited from org.apache.poi.ss.formula.functions.Countif.MatcherBase:: evaluate evaluate getCode toString

Field Detail

_value	back to summary
private final double _value

Constructor Detail

NumberMatcher	back to summary
public NumberMatcher(double value, Countif.CmpOp operator)

Method Detail

getValueText

back to summary

protected String getValueText()

Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.

Annotations

@Override

matches

back to summary

public boolean matches(ValueEval x)

Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Annotations

@Override

org.apache.poi.ss.formula.functions back to summary

public final Class Countif.StringMatcher

Class Inheritance

extends MatcherBase

java.lang.Object
org.apache.poi.ss.formula.functions.Countif.MatcherBase
org.apache.poi.ss.formula.functions.Countif.StringMatcher

Field Summary

Modifier and Type	Field and Description
private final Pattern	_pattern
private final String	_value

Constructor Summary

Access	Constructor and Description
public	StringMatcher(String value, Countif.CmpOp operator)

Method Summary

Modifier and Type	Method and Description
protected String	getValueText() Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.
public static Pattern	Returns: `null` if the specified value contains no special wildcard characters. getWildCardPattern(String value) Translates Excel countif wildcard strings into java regex strings
public boolean	matches(ValueEval x) Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Inherited from org.apache.poi.ss.formula.functions.Countif.MatcherBase:: evaluate evaluate getCode toString

Field Detail

_pattern	back to summary
private final Pattern _pattern

_value	back to summary
private final String _value

Constructor Detail

StringMatcher	back to summary
public StringMatcher(String value, Countif.CmpOp operator)

Method Detail

getValueText

back to summary

protected String getValueText()

Implements abstract org.apache.poi.ss.formula.functions.Countif.MatcherBase.getValueText.

Annotations

@Override

getWildCardPattern back to summary

public static Pattern getWildCardPattern(String value)

Translates Excel countif wildcard strings into java regex strings

Returns:Pattern: null if the specified value contains no special wildcard characters.

matches

back to summary

public boolean matches(ValueEval x)

Implements org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate.matches.

Annotations

@Override

public final Class Countif

Nested and Inner Type Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail

private final Class Countif.BooleanMatcher

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

private final Class Countif.CmpOp

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public final Class Countif.ErrorMatcher

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

private abstract Class Countif.MatcherBase

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

private final Class Countif.NumberMatcher

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public final Class Countif.StringMatcher

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail