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

Object

ArrayBehaviourConfig

Inherited Members

Object.Equals(Object)

Object.Equals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ReferenceEquals(Object, Object)

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
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
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
Int32	argIx	argument index (0-based)

Returns

Type	Description
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
Int32[]	indexes	A list of integers that specifies the 0-based index of arguments that can be an array.