Back to Devexpress

ArrayFormulaCollection Members

officefileapi-devexpress-dot-spreadsheet-dot-arrayformulacollection-dot-underscore-members.md

latest3.7 KB
Original Source

ArrayFormulaCollection Members

A collection of ArrayFormula objects.

Properties

NameDescription
CountGets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronizedGets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
SyncRootGets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

NameDescription
Add(CellRange, String)Creates a new array formula and adds it to the collection.
Clear()Clears all array formulas.
Contains(ArrayFormula)Determines whether the collection contains the specified formula.
CopyTo(Array, Int32)Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator()Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(ArrayFormula)Returns the zero-based index of the specified element in the collection.
Remove(ArrayFormula)Clears the ranges containing the specified array formula.
Remove(CellRange)Clears the array formula in the specified range.
RemoveAt(Int32)Removes the element at the specified index of the ArrayFormulaCollection instance.

See Also

ArrayFormulaCollection Interface

DevExpress.Spreadsheet Namespace