Class CF

This class contains constants used for conditional formatting parsing/serialization in Excel 2007 SpreadsheetML format.

Inheritance
System.Object
CF
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public sealed class CF : Object

Fields

AxisColorTagName

Name of the xml tag that defines the axis color.

Declaration
public const string AxisColorTagName = "axisColor"
Field Value
Type Description
System.String

AxisPositionAttributeName

Name of the xml attribute that represents the axis position of data bar

Declaration
public const string AxisPositionAttributeName = "axisPosition"
Field Value
Type Description
System.String

BeginsWith

Name of the xml tag that represent Begins With Spefific Text conitional formatting.

Declaration
public const string BeginsWith = "beginsWith"
Field Value
Type Description
System.String

BorderAttributeName

Name of the xml attribute that represents the border of data bar

Declaration
public const string BorderAttributeName = "border"
Field Value
Type Description
System.String

BorderColorTagName

Name of the xml tag that defines the border color.

Declaration
public const string BorderColorTagName = "borderColor"
Field Value
Type Description
System.String

ColorScaleTag

Describes a color scale conditional formatting rule.

Declaration
public const string ColorScaleTag = "colorScale"
Field Value
Type Description
System.String

ConditionalFormattingsTagName

Name of the xml tag that defines conditional formattings

Declaration
public const string ConditionalFormattingsTagName = "conditionalFormattings"
Field Value
Type Description
System.String

ConditionalFormattingTagName

Name of the xml tag that represents conditional formatting.

Declaration
public const string ConditionalFormattingTagName = "conditionalFormatting"
Field Value
Type Description
System.String

ContainsText

Name of the xml tag that represent Contains Text Spefific Text conitional formatting.

Declaration
public const string ContainsText = "containsText"
Field Value
Type Description
System.String

DataBarTag

Describes a data bar conditional formatting rule.

Declaration
public const string DataBarTag = "dataBar"
Field Value
Type Description
System.String

DefaultDataBarMaxLength

Default value for maximum length of the data bar.

Declaration
public const int DefaultDataBarMaxLength = 100
Field Value
Type Description
System.Int32

DefaultDataBarMinLength

Default value for minimum length of the data bar.

Declaration
public const int DefaultDataBarMinLength = 0
Field Value
Type Description
System.Int32

DifferentialFormattingIdAttributeName

Name of the xml attribute that represents an index to a dxf element in the Styles Part indicating which cell formatting to apply when the conditional formatting rule criteria is met.

Declaration
public const string DifferentialFormattingIdAttributeName = "dxfId"
Field Value
Type Description
System.String

DirectionAttributeName

Name of the xml attribute that represents the direction of data bar

Declaration
public const string DirectionAttributeName = "direction"
Field Value
Type Description
System.String

EndsWith

Name of the xml tag that represent Ends With Spefific Text conitional formatting.

Declaration
public const string EndsWith = "endsWith"
Field Value
Type Description
System.String

Extenstion

Name of the extention element

Declaration
public const string Extenstion = "ext"
Field Value
Type Description
System.String

ExtentionList

Name of the extention list element

Declaration
public const string ExtentionList = "extLst"
Field Value
Type Description
System.String

FormulaTagName

Name of the xml tag name that represents a formula whose calculated value specifies the criteria for the conditional formatting rule.

Declaration
public const string FormulaTagName = "formula"
Field Value
Type Description
System.String

GradientAttributeName

Name of the xml attribute that represents the gradient fill of data bar

Declaration
public const string GradientAttributeName = "gradient"
Field Value
Type Description
System.String

GreaterAttribute

Greater attribute

Declaration
public const string GreaterAttribute = "gte"
Field Value
Type Description
System.String

IconSetAttribute

The icon set to display.

Declaration
public const string IconSetAttribute = "iconSet"
Field Value
Type Description
System.String

IconSetTag

Describes an icon set conditional formatting rule.

Declaration
public const string IconSetTag = "iconSet"
Field Value
Type Description
System.String

IconSetTypeNames

Names used in xml as IconSet type (order is important).

Declaration
public static string[] IconSetTypeNames
Field Value
Type Description
System.String[]

MaxLengthTag

The maximum length of the data bar, as a percentage of the cell width.

Declaration
public const string MaxLengthTag = "maxLength"
Field Value
Type Description
System.String

MinLengthTag

The minimum length of the data bar, as a percentage of the cell width.

Declaration
public const string MinLengthTag = "minLength"
Field Value
Type Description
System.String

NegativeBarBorderColorSameAsPositiveAttributeName

Name of the xml attribute that represents the negative bar border color of data bar

Declaration
public const string NegativeBarBorderColorSameAsPositiveAttributeName = "negativeBarBorderColorSameAsPositive"
Field Value
Type Description
System.String

NegativeBarColorSameAsPositiveAttributeName

Name of the xml attribute that represents the negative bar color of data bar

Declaration
public const string NegativeBarColorSameAsPositiveAttributeName = "negativeBarColorSameAsPositive"
Field Value
Type Description
System.String

NegativeBorderColorTagName

Name of the xml tag that defines the negative border color.

Declaration
public const string NegativeBorderColorTagName = "negativeBorderColor"
Field Value
Type Description
System.String

NegativeFillColorTagName

Name of the xml tag that defines the negative fill color.

Declaration
public const string NegativeFillColorTagName = "negativeFillColor"
Field Value
Type Description
System.String

NotContainsText

Name of the xml tag that represent NotContains Text Spefific Text conitional formatting.

Declaration
public const string NotContainsText = "notContainsText"
Field Value
Type Description
System.String

OperatorAttributeName

Name of the xml attribute that represents the operator in a "cell value is" conditional formatting rule.

Declaration
public const string OperatorAttributeName = "operator"
Field Value
Type Description
System.String

OperatorBeginsWith

Name of the xml tag that represents begin with condition.

Declaration
public const string OperatorBeginsWith = "beginsWith"
Field Value
Type Description
System.String

OperatorBetween

Name of the xml tag that represents between condition.

Declaration
public const string OperatorBetween = "between"
Field Value
Type Description
System.String

OperatorContains

Name of the xml tag that represents contains text condition.

Declaration
public const string OperatorContains = "containsText"
Field Value
Type Description
System.String

OperatorDoesNotContain

Name of the xml tag that represents not contains condition.

Declaration
public const string OperatorDoesNotContain = "notContains"
Field Value
Type Description
System.String

OperatorEndsWith

Name of the xml tag that represents ends with condition.

Declaration
public const string OperatorEndsWith = "endsWith"
Field Value
Type Description
System.String

OperatorEqual

Name of the xml tag that represents equal condition.

Declaration
public const string OperatorEqual = "equal"
Field Value
Type Description
System.String

OperatorGreaterThan

Name of the xml tag that represents greater than condition.

Declaration
public const string OperatorGreaterThan = "greaterThan"
Field Value
Type Description
System.String

OperatorGreaterThanOrEqual

Name of the xml tag that represents greater than or equal to condition.

Declaration
public const string OperatorGreaterThanOrEqual = "greaterThanOrEqual"
Field Value
Type Description
System.String

OperatorLessThan

Name of the xml tag that represents less than condition.

Declaration
public const string OperatorLessThan = "lessThan"
Field Value
Type Description
System.String

OperatorLessThanOrEqual

Name of the xml tag that represents less than or equal to condition.

Declaration
public const string OperatorLessThanOrEqual = "lessThanOrEqual"
Field Value
Type Description
System.String

OperatorNotBetween

Name of the xml tag that represents not between condition.

Declaration
public const string OperatorNotBetween = "notBetween"
Field Value
Type Description
System.String

OperatorNotEqual

Name of the xml tag that represents not equal condition.

Declaration
public const string OperatorNotEqual = "notEqual"
Field Value
Type Description
System.String

PercentAttribute

Indicates whether the thresholds indicate percentile values, instead of number values.

Declaration
public const string PercentAttribute = "percent"
Field Value
Type Description
System.String

Pivot

Represents conditional formatting rule that contains pivot table.

Declaration
public const string Pivot = "pivot"
Field Value
Type Description
System.String

PriorityAttributeName

Name of the xml attribute that represents the priority of this conditional formatting rule.

Declaration
public const string PriorityAttributeName = "priority"
Field Value
Type Description
System.String

ReverseAttribute

If '1', reverses the default order of the icons in this icon set.

Declaration
public const string ReverseAttribute = "reverse"
Field Value
Type Description
System.String

RuleTagName

Name of the xml tag that represents conditional formatting rule.

Declaration
public const string RuleTagName = "cfRule"
Field Value
Type Description
System.String

ShowValueAttribute

Indicates whether to show the values of the cells on which this data bar is applied.

Declaration
public const string ShowValueAttribute = "showValue"
Field Value
Type Description
System.String

StopIfTrueAttributeName

Name of the xml tag To stop evaluating conditional formatting rules for a cell.

Declaration
public const string StopIfTrueAttributeName = "stopIfTrue"
Field Value
Type Description
System.String

TextAttributeName

Name of the xml tag that represent text attribute of Spefific Text conitional formatting.

Declaration
public const string TextAttributeName = "text"
Field Value
Type Description
System.String

TimePeriodAttributeName

Name of the xml attribute that represents time period type attribute name.

Declaration
public const string TimePeriodAttributeName = "timePeriod"
Field Value
Type Description
System.String

TimePeriodLastMonth

Last month period type

Declaration
public const string TimePeriodLastMonth = "lastMonth"
Field Value
Type Description
System.String

TimePeriodLastsevenDays

Last seven days time period type

Declaration
public const string TimePeriodLastsevenDays = "last7Days"
Field Value
Type Description
System.String

TimePeriodLastWeek

Last week time period type

Declaration
public const string TimePeriodLastWeek = "lastWeek"
Field Value
Type Description
System.String

TimePeriodNextMonth

Next month time period type

Declaration
public const string TimePeriodNextMonth = "nextMonth"
Field Value
Type Description
System.String

TimePeriodNextWeek

Next week time period type

Declaration
public const string TimePeriodNextWeek = "nextWeek"
Field Value
Type Description
System.String

TimePeriodThisMonth

This month period type

Declaration
public const string TimePeriodThisMonth = "thisMonth"
Field Value
Type Description
System.String

TimePeriodThisWeek

This week time period type

Declaration
public const string TimePeriodThisWeek = "thisWeek"
Field Value
Type Description
System.String

TimePeriodToday

Today's time period type

Declaration
public const string TimePeriodToday = "today"
Field Value
Type Description
System.String

TimePeriodTomorrow

Tomorrow's time period type

Declaration
public const string TimePeriodTomorrow = "tomorrow"
Field Value
Type Description
System.String

TimePeriodTypeName

Name of the xml attribute that represents time period type conditional formatting rule.

Declaration
public const string TimePeriodTypeName = "timePeriod"
Field Value
Type Description
System.String

TimePeriodYesterday

Yesterday's time period type

Declaration
public const string TimePeriodYesterday = "yesterday"
Field Value
Type Description
System.String

TypeAttributeName

Name of the xml attribute that represents type of conditional formatting rule.

Declaration
public const string TypeAttributeName = "type"
Field Value
Type Description
System.String

TypeCellIs

Represents conditional formatting rule that compares a cell value to a formula calculated result, using an operator.

Declaration
public const string TypeCellIs = "cellIs"
Field Value
Type Description
System.String

TypeColorScale

Represents conditional formatting rule that contains color scale.

Declaration
public const string TypeColorScale = "colorScale"
Field Value
Type Description
System.String

TypeContainsBlank

Represents conditional formatting rule highlights cells that are completely blank

Declaration
public const string TypeContainsBlank = "containsBlanks"
Field Value
Type Description
System.String

TypeContainsError

Name of the xml tag that represent contains error conitional formatting.

Declaration
public const string TypeContainsError = "containsErrors"
Field Value
Type Description
System.String

TypeDataBar

Represents conditional formatting rule that contains databar.

Declaration
public const string TypeDataBar = "dataBar"
Field Value
Type Description
System.String

TypeExpression

Represents conditional formatting rule that contains a formula to evaluate.

Declaration
public const string TypeExpression = "expression"
Field Value
Type Description
System.String

TypeIconSet

Represents conditional formatting rule that contains iconset.

Declaration
public const string TypeIconSet = "iconSet"
Field Value
Type Description
System.String

TypeNotContainsBlank

Represents conditional formatting rule highlights cells that are not blank

Declaration
public const string TypeNotContainsBlank = "notContainsBlanks"
Field Value
Type Description
System.String

TypeNotContainsError

Name of the xml tag that represent not Contains Error conitional formatting.

Declaration
public const string TypeNotContainsError = "notContainsErrors"
Field Value
Type Description
System.String

ValueObjectTag

Describes the values of the interpolation points in a gradient scale.

Declaration
public const string ValueObjectTag = "cfvo"
Field Value
Type Description
System.String

ValueTypes

Possible value types for ConditionValue.

Declaration
public static string[] ValueTypes
Field Value
Type Description
System.String[]