Class HiddenValuesHandlingFunction

Base class for functions that needs to handle cells that is not visible.

Inheritance

object

ExcelFunction

HiddenValuesHandlingFunction

Inherited Members

ExcelFunction.NumberOfSignificantFigures

ExcelFunction.Execute(IList<FunctionArgument>, ParsingContext)

ExcelFunction.ArgumentMinLength

ExcelFunction.GetNewParameterAddress(IList<CompileResult>, int, ref Queue<FormulaRangeAddress>)

ExcelFunction.IsErrorHandlingFunction

ExcelFunction.ExecutesLambda

ExcelFunction.ArrayBehaviour

ExcelFunction.ConfigureArrayBehaviour(ArrayBehaviourConfig)

ExcelFunction.HandlesVariables

ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)

ExcelFunction.ArgToAddress(IList<FunctionArgument>, int)

ExcelFunction.ArgToInt(IList<FunctionArgument>, int, out ExcelErrorValue, int)

ExcelFunction.ArgToInt(IList<FunctionArgument>, int, bool, out ExcelErrorValue)

ExcelFunction.ArgToInt(IList<FunctionArgument>, int, RoundingMethod)

ExcelFunction.ArgToString(IList<FunctionArgument>, int)

ExcelFunction.ArgToDecimal(object, out ExcelErrorValue)

ExcelFunction.ArgToDecimal(object, PrecisionAndRoundingStrategy, out ExcelErrorValue)

ExcelFunction.ArgToDecimal(IList<FunctionArgument>, int, out ExcelErrorValue, PrecisionAndRoundingStrategy)

ExcelFunction.ArgToDecimal(IList<FunctionArgument>, int, double, out ExcelErrorValue)

ExcelFunction.GetDecimalSingleArgument(FunctionArgument)

ExcelFunction.ArgToRangeInfo(IList<FunctionArgument>, int)

ExcelFunction.Divide(double, double)

ExcelFunction.IsNumericString(object)

ExcelFunction.IsInteger(object)

ExcelFunction.ArgToBool(IList<FunctionArgument>, int)

ExcelFunction.ArgToBool(IList<FunctionArgument>, int, bool)

ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string)

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

ExcelFunction.ThrowExcelErrorValueException(eErrorType)

ExcelFunction.ThrowExcelErrorValueException(ExcelErrorValue)

ExcelFunction.ThrowExcelErrorValueExceptionIf(Func<bool>, eErrorType)

ExcelFunction.IsNumeric(object)

ExcelFunction.IsBool(object)

ExcelFunction.IsString(object, bool)

ExcelFunction.AreEqual(double, double)

ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, Action<DoubleEnumerableParseOptions>, out ExcelErrorValue)

ExcelFunction.ArgsToDoubleEnumerable(FunctionArgument, ParsingContext, Action<DoubleEnumerableParseOptions>, out ExcelErrorValue)

ExcelFunction.ArgsToDoubleEnumerable(FunctionArgument, ParsingContext, out ExcelErrorValue)

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

ExcelFunction.CreateResult(object, DataType)

ExcelFunction.CreateResult(object, DataType, FormulaRangeAddress)

ExcelFunction.CreateDynamicArrayResult(object, DataType)

ExcelFunction.CreateDynamicArrayResult(object, DataType, CompileResultType)

ExcelFunction.CreateDynamicArrayResult(object, DataType, FormulaRangeAddress)

ExcelFunction.CreateDynamicArrayResult(object, DataType, FormulaRangeAddress, CompileResultType)

ExcelFunction.CreateAddressResult(IRangeInfo, DataType)

ExcelFunction.CreateResult(eErrorType)

ExcelFunction.CheckForAndHandleExcelError(FunctionArgument, out ExcelErrorValue)

ExcelFunction.CheckForAndHandleExcelError(ICellInfo, out ExcelErrorValue)

ExcelFunction.GetResultByObject(object)

ExcelFunction.IsVolatile

ExcelFunction.ReturnsReference

ExcelFunction.IsAllowedInCalculatedPivotTableField

ExcelFunction.ParametersInfo

ExcelFunction.NamespacePrefix

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.FormulaParsing.Excel.Functions

Assembly: EPPlus.dll

Syntax

public abstract class HiddenValuesHandlingFunction : ExcelFunction

Constructors

HiddenValuesHandlingFunction()

Hidden values handling function

Declaration

public HiddenValuesHandlingFunction()

Properties

IgnoreErrors

Set to true to indicate whether the function should ignore error values

Declaration

public bool IgnoreErrors { get; set; }

Property Value

Type	Description
bool

IgnoreHiddenValues

Set to true or false to indicate whether the function should ignore hidden values.

Declaration

public bool IgnoreHiddenValues { get; set; }

Property Value

Type	Description
bool

IgnoreNestedSubtotalsAndAggregates

Set to true to indicate whether the function should ignore nested SUBTOTAL and AGGREGATE functions

Declaration

public bool IgnoreNestedSubtotalsAndAggregates { get; set; }

Property Value

Type	Description
bool

Methods

ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, out ExcelErrorValue)

Args to double enumerable

Declaration

protected override IList<double> ArgsToDoubleEnumerable(IEnumerable<FunctionArgument> arguments, ParsingContext context, out ExcelErrorValue error)

Parameters

Type	Name	Description
IEnumerable<FunctionArgument>	arguments
ParsingContext	context
ExcelErrorValue	error

Returns

Type	Description
IList<double>

Overrides

ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, out ExcelErrorValue)

ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, bool, bool, out ExcelErrorValue)

Declaration

protected IList<double> ArgsToDoubleEnumerable(IEnumerable<FunctionArgument> arguments, ParsingContext context, bool ignoreErrors, bool ignoreNonNumeric, out ExcelErrorValue error)

Parameters

Type	Name	Description
IEnumerable<FunctionArgument>	arguments
ParsingContext	context
bool	ignoreErrors
bool	ignoreNonNumeric
ExcelErrorValue	error

Returns

Type	Description
IList<double>

Exceptions

Type	Condition
ExcelErrorValueException

ShouldIgnore(FunctionArgument, ParsingContext)

Should ignore with argument

Declaration

protected bool ShouldIgnore(FunctionArgument arg, ParsingContext context)

Parameters

Type	Name	Description
FunctionArgument	arg
ParsingContext	context

Returns

Type	Description
bool

ShouldIgnore(ICellInfo, ParsingContext)

Should Ignore

Declaration

protected bool ShouldIgnore(ICellInfo c, ParsingContext context)

Parameters

Type	Name	Description
ICellInfo	c
ParsingContext	context

Returns

Type	Description
bool