ConditionalFormatStore Class

Store for conditional formatting rules per ranges.

Inheritance

Object

Documents.Spreadsheet.ConditionalFormatStore

Namespace: Radzen.Documents.Spreadsheet

Assembly: Radzen.Blazor.dll

Syntax

public class ConditionalFormatStore

Constructors

ConditionalFormatStoreLink to this section

Store for conditional formatting rules per ranges.

Declaration
public ConditionalFormatStore()

Properties

RangesLink to this section

Gets all ranges that have conditional formatting rules.

Declaration
public IEnumerable<Documents.Spreadsheet.RangeRef> Ranges { get; }
Property Value
Type Description
IEnumerable<Documents.Spreadsheet.RangeRef>Gets all ranges that have conditional formatting rules.

Methods

AddLink to this section

Adds conditional formatting rules for a specific range.

Declaration
public void Add(Documents.Spreadsheet.RangeRef range, Documents.Spreadsheet.ConditionalFormatBase[] rules)
Parameters
Type Name Description
Documents.Spreadsheet.RangeRef range
Documents.Spreadsheet.ConditionalFormatBase[] rules

AddLink to this section

Adds conditional formatting rules for a specific range.

Declaration
public void Add(Documents.Spreadsheet.RangeRef range, Documents.Spreadsheet.ConditionalFormatBase rule)
Parameters

CalculateLink to this section

Calculates the merged conditional overlay format for a cell from all matching rules.

Declaration
public Documents.Spreadsheet.Format Calculate(Documents.Spreadsheet.Cell cell)
Parameters
Type Name Description
Documents.Spreadsheet.Cell cell
Returns

GetRulesLink to this section

Gets all rules for a specific range.

Declaration
public IReadOnlyList<Documents.Spreadsheet.ConditionalFormatBase> GetRules(Documents.Spreadsheet.RangeRef range)
Parameters
Type Name Description
Documents.Spreadsheet.RangeRef range
Returns
Type Description
IReadOnlyList<Documents.Spreadsheet.ConditionalFormatBase>

RemoveLink to this section

Removes a conditional formatting rule from a specific range.

Declaration
public bool Remove(Documents.Spreadsheet.RangeRef range, Documents.Spreadsheet.ConditionalFormatBase rule)
Parameters
Returns
Type Description
bool
An error has occurred. This app may no longer respond until reloaded. Reload 🗙