RangeExtensions.Max(CellRange, Boolean, Boolean) Method
Returns the maximum numerical value in the current cell range.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.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 | Cell |
A cell range for which the maximum value is calculated. |
ignore |
Boolean | true to exclude hidden rows from calculation; otherwise, false. |
ignore |
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 |
---|---|
Range |
Returns the average of numerical values in a cell range. |
Range |
Returns the number of cells that contain data. |
Range |
Returns the number of cells that contain numerical data. |
Range |
Returns the sum of numerical values in a cell range. |
Range |
Returns the maximum numerical value in a cell range. |
Range |
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);