TConditionalFormatDefStandard Class

Defines a format to apply for cells when a rule evaluates to true.

Syntax

Unit: FlexCel.Core

TConditionalFormatDefStandard = class(TConditionalFormatDef);

Fields

Name	Description
ApplyFont	Specifies which properties of TUIFont will be applied in the final format.
Font	The definition of the font. Only those properties true in ApplyFont will be used.
ApplyFill	Specifies which properties of Fill will be applied in the final format.
Fill	Fill properties that will be applied. Only those in ApplyFill will be used.
ApplyBorders	Defines which borders will be applied to the final format.
Borders	Defines the borders. Only those borders where ApplyBorders is true will be used.

Constructors

Name	Description
Create	Creates an empty instance, where no format applies.

Methods

Name	Description
CheckIsValid	Checks if the format definition is valid. This check will be applied automatically when you try to add a conditional format to a sheet, so there is no need to call this method directly. But you can use it to know if a conditional format will be rejected when you try to add it.
Clone	Returns a deep copy of the object.
Equals	Returns true if this object is equal to obj.
GetHashCode	Returns the hashcode for this object.

Properties

Name	Description
NumericFormat	Numeric format for the cell, when ApplyNumericFormat is true.
ApplyNumericFormat	When true the format specified in NumericFormat will be applied, else it will be ignored.
HasFontBlock	Returns true if any font formatting is applied
HasBorderBlock	Returns true if any border formatting is applied.
HasFillBlock	Returns true if any pattern formatting is applied.
HasNumericFormat​Block	Returns true if the numeric format is applied.
HasFormat	Returns true if any format is applied.