Show / Hide Table of Contents

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(IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.BeforeInvoke(ParsingContext)
ExcelFunction.IsLookupFuction
ExcelFunction.IsErrorHandlingFunction
ExcelFunction.GetFirstValue(IEnumerable<FunctionArgument>)
ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, Int32, eErrorType)
ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToAddress(IEnumerable<FunctionArgument>, Int32, ParsingContext)
ExcelFunction.ArgToInt(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToInt(IEnumerable<FunctionArgument>, Int32, Boolean)
ExcelFunction.ArgToInt(IEnumerable<FunctionArgument>, Int32, RoundingMethod)
ExcelFunction.ArgToString(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToDecimal(Object)
ExcelFunction.ArgToDecimal(Object, PrecisionAndRoundingStrategy)
ExcelFunction.ArgToDecimal(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToDecimal(IEnumerable<FunctionArgument>, Int32, PrecisionAndRoundingStrategy)
ExcelFunction.ArgToRangeInfo(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.Divide(Double, Double)
ExcelFunction.IsNumericString(Object)
ExcelFunction.IsInteger(Object)
ExcelFunction.ArgToBool(IEnumerable<FunctionArgument>, Int32)
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(Boolean, Boolean, IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.ArgsToDoubleEnumerable(Boolean, Boolean, IEnumerable<FunctionArgument>, ParsingContext, Boolean)
ExcelFunction.ArgsToDoubleEnumerable(Boolean, IEnumerable<FunctionArgument>, ParsingContext, Boolean)
ExcelFunction.ArgsToDoubleEnumerable(Boolean, IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.ArgsToDoubleEnumerableZeroPadded(Boolean, IRangeInfo, ParsingContext)
ExcelFunction.ArgsToObjectEnumerable(Boolean, IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.CreateResult(Object, DataType)
ExcelFunction.CreateResult(eErrorType)
ExcelFunction.CalculateCollection(IEnumerable<FunctionArgument>, Double, Func<FunctionArgument, Double, Double>)
ExcelFunction.CheckForAndHandleExcelError(FunctionArgument)
ExcelFunction.CheckForAndHandleExcelError(ICellInfo)
ExcelFunction.GetResultByObject(Object)
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

Methods

ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext)

Declaration
protected override IEnumerable<ExcelDoubleCellValue> ArgsToDoubleEnumerable(IEnumerable<FunctionArgument> arguments, ParsingContext context)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<FunctionArgument> arguments
ParsingContext context
Returns
Type Description
System.Collections.Generic.IEnumerable<ExcelDoubleCellValue>
Overrides
ExcelFunction.ArgsToDoubleEnumerable(IEnumerable<FunctionArgument>, ParsingContext)

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

Declaration
protected IEnumerable<ExcelDoubleCellValue> ArgsToDoubleEnumerable(IEnumerable<FunctionArgument> arguments, ParsingContext context, bool ignoreErrors, bool ignoreNonNumeric)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<FunctionArgument> arguments
ParsingContext context
System.Boolean ignoreErrors
System.Boolean ignoreNonNumeric
Returns
Type Description
System.Collections.Generic.IEnumerable<ExcelDoubleCellValue>

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
In This Article
Back to top Generated by DocFX