Class MultipleRangeCriteriasFunction

Namespace

OfficeOpenXml.FormulaParsing.Excel.Functions.Math

Assembly

Magicodes.EPPlus.dll

public abstract class MultipleRangeCriteriasFunction : ExcelFunction

Inheritance

object

ExcelFunction

MultipleRangeCriteriasFunction

Derived

AverageIfs

CountIfs

SumIfs

Inherited Members

ExcelFunction.Execute(IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.BeforeInvoke(ParsingContext)

ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int, eErrorType)

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, int, ParsingContext)

ExcelFunction.ArgToInt(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToString(IEnumerable<FunctionArgument>, int)

ExcelFunction.ArgToDecimal(object)

ExcelFunction.ArgToDecimal(IEnumerable<FunctionArgument>, int)

ExcelFunction.Divide(double, double)

ExcelFunction.IsNumericString(object)

ExcelFunction.ArgToBool(IEnumerable<FunctionArgument>, int)

ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string)

ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string, params object[])

ExcelFunction.ThrowExcelErrorValueException(eErrorType)

ExcelFunction.ThrowExcelErrorValueExceptionIf(Func<bool>, eErrorType)

ExcelFunction.IsNumeric(object)

ExcelFunction.AreEqual(double, double)

ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerable(bool, bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerable(bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.ArgsToDoubleEnumerableZeroPadded(bool, ExcelDataProvider.IRangeInfo, ParsingContext)

ExcelFunction.ArgsToObjectEnumerable(bool, IEnumerable<FunctionArgument>, ParsingContext)

ExcelFunction.CreateResult(object, DataType)

ExcelFunction.CalculateCollection(IEnumerable<FunctionArgument>, double, Func<FunctionArgument, double, double>)

ExcelFunction.CheckForAndHandleExcelError(FunctionArgument)

ExcelFunction.CheckForAndHandleExcelError(ExcelDataProvider.ICellInfo)

ExcelFunction.GetResultByObject(object)

ExcelFunction.IsLookupFuction

ExcelFunction.IsErrorHandlingFunction

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Constructors

MultipleRangeCriteriasFunction()

protected MultipleRangeCriteriasFunction()

MultipleRangeCriteriasFunction(ExpressionEvaluator)

protected MultipleRangeCriteriasFunction(ExpressionEvaluator evaluator)

Parameters

evaluator ExpressionEvaluator

Methods

Evaluate(object, string)

protected bool Evaluate(object obj, string expression)

Parameters

obj object

expression string

Returns

bool

GetMatchIndexes(IRangeInfo, string)

protected List<int> GetMatchIndexes(ExcelDataProvider.IRangeInfo rangeInfo, string searched)

Parameters

rangeInfo ExcelDataProvider.IRangeInfo

searched string

Returns

List<int>