Class HiddenValuesHandlingFunction¶

Namespace: OfficeOpenXml.FormulaParsing.Excel.Functions
Assembly: EPPlus.dll

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

public abstract class HiddenValuesHandlingFunction : ExcelFunction

Inheritance¶

object ← ExcelFunction ← HiddenValuesHandlingFunction

Inherited Members¶

ExcelFunction.AreEqual(double, double)
ExcelFunction.ArgsToDoubleEnumerable(FunctionArgument, ParsingContext, Action<DoubleEnumerableParseOptions>, out ExcelErrorValue)
ExcelFunction.ArgsToDoubleEnumerable(FunctionArgument, ParsingContext, out ExcelErrorValue)
ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, Action<DoubleEnumerableParseOptions>, out ExcelErrorValue)
ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext, out ExcelErrorValue)
ExcelFunction.ArgsToObjectEnumerable(bool, bool, bool, IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.ArgToAddress(IList<FunctionArgument>, int)
ExcelFunction.ArgToBool(IList<FunctionArgument>, int, bool)
ExcelFunction.ArgToBool(IList<FunctionArgument>, int)
ExcelFunction.ArgToDecimal(IList<FunctionArgument>, int, double, out ExcelErrorValue)
ExcelFunction.ArgToDecimal(IList<FunctionArgument>, int, out ExcelErrorValue, PrecisionAndRoundingStrategy)
ExcelFunction.ArgToDecimal(object, out ExcelErrorValue)
ExcelFunction.ArgToDecimal(object, PrecisionAndRoundingStrategy, out ExcelErrorValue)
ExcelFunction.ArgToInt(IList<FunctionArgument>, int, bool, out ExcelErrorValue)
ExcelFunction.ArgToInt(IList<FunctionArgument>, int, out ExcelErrorValue, int)
ExcelFunction.ArgToInt(IList<FunctionArgument>, int, RoundingMethod)
ExcelFunction.ArgToRangeInfo(IList<FunctionArgument>, int)
ExcelFunction.ArgToString(IList<FunctionArgument>, int)
ExcelFunction.ArgumentMinLength
ExcelFunction.ArrayBehaviour
ExcelFunction.CheckForAndHandleExcelError(FunctionArgument, out ExcelErrorValue)
ExcelFunction.CheckForAndHandleExcelError(ICellInfo, out ExcelErrorValue)
ExcelFunction.ConfigureArrayBehaviour(ArrayBehaviourConfig)
ExcelFunction.CreateAddressResult(IRangeInfo, DataType)
ExcelFunction.CreateDynamicArrayResult(object, DataType, CompileResultType)
ExcelFunction.CreateDynamicArrayResult(object, DataType, FormulaRangeAddress, CompileResultType)
ExcelFunction.CreateDynamicArrayResult(object, DataType, FormulaRangeAddress)
ExcelFunction.CreateDynamicArrayResult(object, DataType)
ExcelFunction.CreateResult(eErrorType)
ExcelFunction.CreateResult(object, DataType, FormulaRangeAddress)
ExcelFunction.CreateResult(object, DataType)
ExcelFunction.Divide(double, double)
ExcelFunction.Execute(IList<FunctionArgument>, ParsingContext)
ExcelFunction.ExecutesLambda
ExcelFunction.GetDecimalSingleArgument(FunctionArgument)
ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)
ExcelFunction.GetNewParameterAddress(IList<CompileResult>, int, ParsingContext, ref Queue<FormulaRangeAddress>)
ExcelFunction.GetResultByObject(object)
ExcelFunction.HandlesVariables
ExcelFunction.IsAllowedAsLambdaWithMultipleArguments
ExcelFunction.IsAllowedInCalculatedPivotTableField
ExcelFunction.IsBool(object)
ExcelFunction.IsErrorHandlingFunction
ExcelFunction.IsInteger(object)
ExcelFunction.IsNumeric(object)
ExcelFunction.IsNumericNotBool(object)
ExcelFunction.IsNumericString(object)
ExcelFunction.IsString(object, bool)
ExcelFunction.IsVolatile
ExcelFunction.Name
ExcelFunction.NamespacePrefix
ExcelFunction.NumberOfSignificantFigures
ExcelFunction.ParametersInfo
ExcelFunction.ReturnsReference
ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string, params object[])
ExcelFunction.ThrowArgumentExceptionIf(Func<bool>, string)
ExcelFunction.ThrowExcelErrorValueException(eErrorType)
ExcelFunction.ThrowExcelErrorValueException(ExcelErrorValue)
ExcelFunction.ThrowExcelErrorValueExceptionIf(Func<bool>, eErrorType)
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

HiddenValuesHandlingFunction()¶

Hidden values handling function

public HiddenValuesHandlingFunction()

Properties¶

IgnoreErrors¶

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

public bool IgnoreErrors { get; set; }

Property Value¶

bool

IgnoreHiddenValues¶

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

public bool IgnoreHiddenValues { get; set; }

Property Value¶

bool

IgnoreNestedSubtotalsAndAggregates¶

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

public bool IgnoreNestedSubtotalsAndAggregates { get; set; }

Property Value¶

bool

Methods¶

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

Args to double enumerable

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

Parameters¶

arguments IEnumerable<FunctionArgument>

context ParsingContext

error ExcelErrorValue

Returns¶

IList<double>

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

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

Parameters¶

arguments IEnumerable<FunctionArgument>

context ParsingContext

ignoreErrors bool

ignoreNonNumeric bool

error ExcelErrorValue

Returns¶

IList<double>

Exceptions¶

ExcelErrorValueException

ShouldIgnore(ICellInfo, ParsingContext)¶

Should Ignore

protected bool ShouldIgnore(ICellInfo c, ParsingContext context)

Parameters¶

c ICellInfo

context ParsingContext

Returns¶

bool

ShouldIgnore(FunctionArgument, ParsingContext)¶

Should ignore with argument

protected bool ShouldIgnore(FunctionArgument arg, ParsingContext context)

Parameters¶

arg FunctionArgument

context ParsingContext

Returns¶

bool