Class HiddenValuesHandlingFunction

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

Inheritance

System.Object

ExcelFunction

HiddenValuesHandlingFunction

Inherited Members

ExcelFunction.NumberOfSignificantFigures

ExcelFunction.Execute(IList<FunctionArgument>, ParsingContext)

ExcelFunction.ArgumentMinLength

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

ExcelFunction.IsErrorHandlingFunction

ExcelFunction.ArrayBehaviour

ExcelFunction.ConfigureArrayBehaviour(ArrayBehaviourConfig)

ExcelFunction.HandlesVariables

ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)

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

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, Int32)

ExcelFunction.ArgToAddress(IList<FunctionArgument>, Int32)

ExcelFunction.ArgToInt(IList<FunctionArgument>, Int32, ExcelErrorValue, Int32)

ExcelFunction.ArgToInt(IList<FunctionArgument>, Int32, Boolean, ExcelErrorValue)

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

ExcelFunction.ArgToString(IList<FunctionArgument>, Int32)

ExcelFunction.ArgToDecimal(Object, ExcelErrorValue)

ExcelFunction.ArgToDecimal(Object, PrecisionAndRoundingStrategy, ExcelErrorValue)

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

ExcelFunction.ArgToDecimal(IList<FunctionArgument>, Int32, Double, ExcelErrorValue)

ExcelFunction.GetDecimalSingleArgument(FunctionArgument)

ExcelFunction.ArgToRangeInfo(IList<FunctionArgument>, Int32)

ExcelFunction.Divide(Double, Double)

ExcelFunction.IsNumericString(Object)

ExcelFunction.IsInteger(Object)

ExcelFunction.ArgToBool(IList<FunctionArgument>, Int32)

ExcelFunction.ArgToBool(IList<FunctionArgument>, Int32, Boolean)

ExcelFunction.ThrowArgumentExceptionIf(Func<Boolean>, String)

ExcelFunction.ThrowArgumentExceptionIf(Func<Boolean>, String, Object[])

ExcelFunction.ThrowExcelErrorValueException(eErrorType)

ExcelFunction.ThrowExcelErrorValueException(ExcelErrorValue)

ExcelFunction.ThrowExcelErrorValueExceptionIf(Func<Boolean>, eErrorType)

ExcelFunction.IsNumeric(Object)

ExcelFunction.IsBool(Object)

ExcelFunction.IsString(Object, Boolean)

ExcelFunction.AreEqual(Double, Double)

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

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

ExcelFunction.ArgsToDoubleEnumerable(FunctionArgument, ParsingContext, ExcelErrorValue)

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

ExcelFunction.CreateResult(Object, DataType)

ExcelFunction.CreateResult(Object, DataType, FormulaRangeAddress)

ExcelFunction.CreateDynamicArrayResult(Object, DataType)

ExcelFunction.CreateDynamicArrayResult(Object, DataType, FormulaRangeAddress)

ExcelFunction.CreateAddressResult(IRangeInfo, DataType)

ExcelFunction.CreateResult(eErrorType)

ExcelFunction.CheckForAndHandleExcelError(FunctionArgument, ExcelErrorValue)

ExcelFunction.CheckForAndHandleExcelError(ICellInfo, ExcelErrorValue)

ExcelFunction.GetResultByObject(Object)

ExcelFunction.IsVolatile

ExcelFunction.ReturnsReference

ExcelFunction.IsAllowedInCalculatedPivotTableField

ExcelFunction.ParametersInfo

ExcelFunction.NamespacePrefix

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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
System.Boolean

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
System.Boolean

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
System.Boolean

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
System.Collections.Generic.IEnumerable<FunctionArgument>	arguments
ParsingContext	context
ExcelErrorValue	error

Returns

Type	Description
System.Collections.Generic.IList<System.Double>

Overrides

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

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

Declaration

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

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<FunctionArgument>	arguments
ParsingContext	context
System.Boolean	ignoreErrors
System.Boolean	ignoreNonNumeric
ExcelErrorValue	error

Returns

Type	Description
System.Collections.Generic.IList<System.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
System.Boolean

ShouldIgnore(ICellInfo, ParsingContext)

Should Ignore

Declaration

protected bool ShouldIgnore(ICellInfo c, ParsingContext context)

Parameters

Type	Name	Description
ICellInfo	c
ParsingContext	context

Returns

Type	Description
System.Boolean