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.NumberOfSignificantFigures

ExcelFunction.Execute(IList<FunctionArgument>, ParsingContext)

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

ExcelFunction.ConfigureArrayBehaviour(ArrayBehaviourConfig)

ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)

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

ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int)

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, FormulaRangeAddress)

ExcelFunction.CreateAddressResult(IRangeInfo, DataType)

ExcelFunction.CreateResult(eErrorType)

ExcelFunction.CheckForAndHandleExcelError(FunctionArgument, out ExcelErrorValue)

ExcelFunction.CheckForAndHandleExcelError(ICellInfo, out ExcelErrorValue)

ExcelFunction.GetResultByObject(object)

ExcelFunction.ArgumentMinLength

ExcelFunction.IsErrorHandlingFunction

ExcelFunction.ArrayBehaviour

ExcelFunction.HandlesVariables

ExcelFunction.IsVolatile

ExcelFunction.ReturnsReference

ExcelFunction.IsAllowedInCalculatedPivotTableField

ExcelFunction.ParametersInfo

ExcelFunction.NamespacePrefix

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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(FunctionArgument, ParsingContext)

Should ignore with argument

protected bool ShouldIgnore(FunctionArgument arg, ParsingContext context)

Parameters

arg FunctionArgument

context ParsingContext

Returns

bool

ShouldIgnore(ICellInfo, ParsingContext)

Should Ignore

protected bool ShouldIgnore(ICellInfo c, ParsingContext context)

Parameters

c ICellInfo

context ParsingContext

Returns

bool