RangeExtensions.Max(CellRange, Boolean, Boolean) Method
Returns the maximum numerical value in the current cell range.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
public static double? Max(
this CellRange range,
bool ignoreHiddenRows,
bool ignoreHiddenColumns
)Parameters
| Name | Type | Description |
|---|---|---|
| range | CellRange | A cell range for which the maximum value is calculated. |
| ignoreHiddenRows | Boolean | true to exclude hidden rows from calculation; otherwise, false. |
| ignoreHiddenColumns | Boolean | true to exclude hidden columns from calculation; otherwise, false. |
Returns
| Type | Description |
|---|---|
| Nullable<Double> | The maximum cell value. Null (Nothing in Visual Basic), if the cell range doesn’t contain numeric values. |
Remarks
Use the following extension methods to summarize values in a cell range. You can call these methods in the same way as instance methods of the CellRange object.
| Method | Description |
|---|---|
| RangeExtensions.Average | Returns the average of numerical values in a cell range. |
| RangeExtensions.Count | Returns the number of cells that contain data. |
| RangeExtensions.NumericalCount | Returns the number of cells that contain numerical data. |
| RangeExtensions.Sum | Returns the sum of numerical values in a cell range. |
| RangeExtensions.Max | Returns the maximum numerical value in a cell range. |
| RangeExtensions.Min | Returns the minimum numerical value in a cell range. |
The following code example shows how to obtain the minimum and maximum values for selected cells in the Spreadsheet control.
double? max = spreadsheetControl.Selection.Max(true, true);
double? min = spreadsheetControl.Selection.Min(true, true);