Interface IFontFormatting

High level representation for Font Formatting component of Conditional Formatting Settings.

Namespace: IronXL.Formatting
Assembly: IronXL.dll
Syntax
public interface IFontFormatting

Changing the font of cells that match a conditional rule in C# runs through IFontFormatting. It defines how text looks when a conditional formatting rule fires, bold, color, size, and decoration, so a rule can make flagged values jump out by their type and not only by their background. It is the font side of conditional formatting, separate from the always-on font of IStyle.

A developer obtains it from ConditionalFormattingRule.FontFormatting, a get-only property on a rule built through a worksheet's conditional formatting surface. The settings here apply only when the rule's condition is met, so they are configured on the rule before it is added to a region.

IsBold and IsItalic set the weight and slant, FontColor takes an RGB string, and FontHeight sets the point size as an integer. UnderlineType takes a FontUnderlineType for the underline style, and EscapementType takes a FontScript for superscript or subscript. Set only the members a rule needs; the rest leave the matched cell's existing font unchanged.

using IronXL;
using IronXL.Formatting;

WorkSheet sheet = WorkBook.Load("report.xlsx").DefaultWorkSheet;
ConditionalFormattingRule rule = sheet.ConditionalFormatting
    .CreateConditionalFormattingRule(ComparisonOperator.LessThan, "0");
rule.FontFormatting.IsBold = true;
rule.FontFormatting.FontColor = "#C00000";

The conditional formatting how-to walks through building rules, and the conditional formatting example shows a worked rule.

Properties

EscapementType

Get or set the type of super or subscript for the font

Declaration
FontScript EscapementType { get; set; }
Property Value
Type Description
FontScript

The type of the escapement.

FontColor

Gets or sets the color of the font.

Declaration
string FontColor { get; set; }
Property Value
Type Description
System.String

The color of the font.

FontHeight

Get or set the height of the font in px.

Declaration
int FontHeight { get; set; }
Property Value
Type Description
System.Int32

The font height in px.

IsBold

Gets or sets a value indicating whether this font is bold.

Declaration
bool IsBold { get; set; }
Property Value
Type Description
System.Boolean

true if this font is bold; otherwise, false.

IsItalic

Gets a value indicating whether this font is italic.

Declaration
bool IsItalic { get; set; }
Property Value
Type Description
System.Boolean

true if this font is italic; otherwise, false.

UnderlineType

Get or set the type of underlining for the font.

Declaration
FontUnderlineType UnderlineType { get; set; }
Property Value
Type Description
FontUnderlineType

The type of the underline.