New to Telerik Document ProcessingStart a free 30-day trial

Defines formatting properties that overlay base cell formatting when conditional formatting rules are met, allowing selective property changes without replacing all formatting.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#
public class DifferentialFormatting

Inheritance: objectDifferentialFormatting

Constructors

Initializes a new DifferentialFormatting that can overlay formatting properties on cells when conditional formatting rules apply.

C#
public DifferentialFormatting()

Methods

Compares this differential formatting with another object and returns true if all formatting properties match.

C#
public override bool Equals(object obj)
Parameters:objobject

The object to compare with the current object.

Returns:

bool

True if the specified object is equal to the current object; otherwise, false.

Overrides: object.Equals(object)

Computes a hash code based on all defined formatting properties for use in collections.

C#
public override int GetHashCode()
Returns:

int

A hash code for the current object.

Overrides: object.GetHashCode()

Properties

Gets or sets the bottom border style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder BottomBorder { get; set; }

Gets or sets the number format to apply when the conditional formatting rule is satisfied.

C#
public CellValueFormat CellValueFormat { get; set; }

Gets or sets the diagonal down border (top-left to bottom-right) style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder DiagonalDownBorder { get; set; }

Gets or sets the diagonal up border (bottom-left to top-right) style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder DiagonalUpBorder { get; set; }

Gets or sets the background fill (pattern or gradient) to apply when the conditional formatting rule is satisfied.

C#
public IFill Fill { get; set; }

Gets or sets the font family to apply when the conditional formatting rule is satisfied.

C#
public ThemableFontFamily FontFamily { get; set; }

Gets or sets the font size to apply when the conditional formatting rule is satisfied.

C#
public double FontSize { get; set; }

Gets or sets the text color to apply when the conditional formatting rule is satisfied.

C#
public ThemableColor ForeColor { get; set; }

Gets or sets whether to apply bold text formatting when the conditional formatting rule is satisfied.

C#
public bool IsBold { get; set; }

Gets or sets whether to apply italic text formatting when the conditional formatting rule is satisfied.

C#
public bool IsItalic { get; set; }

Gets or sets whether to apply strikethrough text decoration when the conditional formatting rule is satisfied.

C#
public bool IsStrikethrough { get; set; }

Gets or sets the left border style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder LeftBorder { get; set; }

Gets or sets the right border style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder RightBorder { get; set; }

Gets or sets the top border style and color to apply when the conditional formatting rule is satisfied.

C#
public CellBorder TopBorder { get; set; }

Gets or sets the underline style to apply when the conditional formatting rule is satisfied.

C#
public UnderlineType Underline { get; set; }

Gets or sets the vertical text alignment (none, superscript, or subscript) to apply when the conditional formatting rule is satisfied.

C#
public VerticalTextAlignment VerticalTextAlignment { get; set; }