Dynamic Array Functions
The Spreadsheet for WPF supports dynamic array functions that return arrays of values that spill into adjacent cells. These functions enable you to perform calculations on multiple values and return results in a range of cells without needing to enter the formula in each cell.
The following table lists supported dynamic array functions:
| Name | Description | Syntax |
|---|---|---|
| SORT | Sorts the contents of a range or array. | =SORT(array, [sort_index], [sort_order], [by_col]) |
| FILTER | Filters a range or array based on criteria you define. | =FILTER(array, include, [if_empty]) |
| UNIQUE | Returns a list of unique values in a range or array. | =UNIQUE(array, [by_col], [exactly_once]) |
The SpreadsheetCapabilitiesOptions.DynamicArrayFormulas property indicates whether the dynamic array formulas are enabled.