Class ArrayBehaviourConfig

This class should be used to configure how arrays/ranges are treated as parameters to functions that can return a dynamic array.

Inheritance

System.Object

ArrayBehaviourConfig

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 class ArrayBehaviourConfig

Properties

ArrayArgInterval

Indicates that every x-th argument can be an array.

Declaration

public int ArrayArgInterval { get; set; }

Property Value

Type	Description
System.Int32

IgnoreNumberOfArgsFromStart

Use this property in combination with ArrayArgInterval. A typical scenario would be that the first 3 arguments should be ignore and then every 3rd argument might be in array. In this scenario this property should be set to 3.

Declaration

public int IgnoreNumberOfArgsFromStart { get; set; }

Property Value

Type	Description
System.Int32

Methods

CanBeArrayArg(Int32)

Returns true if the 0-based argIx occurs in the SetArrayParameterIndexes(Int32[]) list or if the index matches the configuration of IgnoreNumberOfArgsFromStart and ArrayArgInterval.

Declaration

public bool CanBeArrayArg(int argIx)

Parameters

Type	Name	Description
System.Int32	argIx	argument index (0-based)

Returns

Type	Description
System.Boolean

SetArrayParameterIndexes(Int32[])

This method sets indexes of arguments that can be an array.

Declaration

public void SetArrayParameterIndexes(params int[] indexes)

Parameters

Type	Name	Description
System.Int32[]	indexes	A list of integers that specifies the 0-based index of arguments that can be an array.