Top10Rule Class
Conditional format rule that applies when the cell value is in the top (or bottom) N distinct values of its range.
Inheritance
Namespace: Radzen.Documents.Spreadsheet
Assembly: Radzen.Blazor.dll
Syntax
public class Top10Rule : Documents.Spreadsheet.ConditionalFormatBaseRemarks
Selection follows Excel semantics: it ranks the DISTINCT numeric values within the range and matches any cell whose value is at or beyond the resulting threshold (so ties at the threshold are all included). Because the rule needs the full range to compute the threshold, evaluation is performed by ; calling directly returns .
Constructors
Top10Rulelink
Conditional format rule that applies when the cell value is in the top (or bottom) N distinct values of its range.
Declaration
public Top10Rule()Properties
Bottomlink
Gets or sets whether to use bottom N instead of top N.
Declaration
public bool Bottom { get; set; }Property Value
| Type | Description |
|---|---|
| bool | Gets or sets whether to use bottom N instead of top N. |
Countlink
Gets or sets how many top values to highlight.
Declaration
public int Count { get; set; }Property Value
| Type | Description |
|---|---|
| int | Gets or sets how many top values to highlight. |
Formatlink
Gets or sets the format to apply when the rule matches.
Declaration
public Documents.Spreadsheet.Format Format { get; set; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.Format | Gets or sets the format to apply when the rule matches. |
Methods
GetFormatlink
Declaration
public override Documents.Spreadsheet.Format GetFormat(Documents.Spreadsheet.Cell cell)Parameters
| Type | Name | Description |
|---|---|---|
| Documents.Spreadsheet.Cell | cell |
Returns
| Type | Description |
|---|---|
| Documents.Spreadsheet.Format |