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.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.ArgToString(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToDecimal(Object)
ExcelFunction.ArgToDecimal(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.ArgToRangeInfo(IEnumerable<FunctionArgument>, Int32)
ExcelFunction.Divide(Double, Double)
ExcelFunction.IsNumericString(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, IEnumerable<FunctionArgument>, ParsingContext)
ExcelFunction.ArgsToDoubleEnumerableZeroPadded(Boolean, ExcelDataProvider.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(ExcelDataProvider.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

Properties

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)

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

ShouldIgnore(FunctionArgument)

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

ShouldIgnore(ExcelDataProvider.ICellInfo, ParsingContext)

Declaration
protected bool ShouldIgnore(ExcelDataProvider.ICellInfo c, ParsingContext context)
Parameters
Type Name Description
ExcelDataProvider.ICellInfo c
ParsingContext context
Returns
Type Description
System.Boolean
Back to top Generated by DocFX