Where does IFontFormatting live in the IronXL API?

IFontFormatting is an interface in the IronXL.Formatting namespace, shipped in IronXL.dll. It is returned by the FontFormatting property of ConditionalFormattingRule and defines the font a conditional rule applies.

What returns IFontFormatting in IronXL?

ConditionalFormattingRule.FontFormatting returns an IFontFormatting. IronXL exposes it through that get-only property on a rule rather than letting you construct one, so the font is configured on the rule before it is added to a sheet.

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.