Class HiddenValuesHandlingFunction

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

Inheritance
System.Object
ExcelFunction
HiddenValuesHandlingFunction
Inherited Members
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()

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)

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

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)

Declaration
protected bool ShouldIgnore(FunctionArgument arg, ParsingContext context)
Parameters
Type Name Description
FunctionArgument arg
ParsingContext context
Returns
Type Description
System.Boolean

ShouldIgnore(ICellInfo, ParsingContext)

Declaration
protected bool ShouldIgnore(ICellInfo c, ParsingContext context)
Parameters
Type Name Description
ICellInfo c
ParsingContext context
Returns
Type Description
System.Boolean