Class CF
This class contains constants used for conditional formatting parsing/serialization in Excel 2007 SpreadsheetML format.
Inheritance
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.UWP.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 |
---|
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 |
---|
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 |
---|
System.String |
BorderAttributeName
Name of the xml attribute that represents the border of data bar
Declaration
public const string BorderAttributeName = "border"
Field Value
Type |
---|
System.String |
BorderColorTagName
Name of the xml tag that defines the border color.
Declaration
public const string BorderColorTagName = "borderColor"
Field Value
Type |
---|
System.String |
ColorScaleTag
Describes a color scale conditional formatting rule.
Declaration
public const string ColorScaleTag = "colorScale"
Field Value
Type |
---|
System.String |
ConditionalFormattingsTagName
Name of the xml tag that defines conditional formattings
Declaration
public const string ConditionalFormattingsTagName = "conditionalFormattings"
Field Value
Type |
---|
System.String |
ConditionalFormattingTagName
Name of the xml tag that represents conditional formatting.
Declaration
public const string ConditionalFormattingTagName = "conditionalFormatting"
Field Value
Type |
---|
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 |
---|
System.String |
DataBarTag
Describes a data bar conditional formatting rule.
Declaration
public const string DataBarTag = "dataBar"
Field Value
Type |
---|
System.String |
DefaultDataBarMaxLength
Default value for maximum length of the data bar.
Declaration
public const int DefaultDataBarMaxLength = 100
Field Value
Type |
---|
System.Int32 |
DefaultDataBarMinLength
Default value for minimum length of the data bar.
Declaration
public const int DefaultDataBarMinLength = 0
Field Value
Type |
---|
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 |
---|
System.String |
DirectionAttributeName
Name of the xml attribute that represents the direction of data bar
Declaration
public const string DirectionAttributeName = "direction"
Field Value
Type |
---|
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 |
---|
System.String |
Extenstion
Name of the extention element
Declaration
public const string Extenstion = "ext"
Field Value
Type |
---|
System.String |
ExtentionList
Name of the extention list element
Declaration
public const string ExtentionList = "extLst"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
GreaterAttribute
Greater attribute
Declaration
public const string GreaterAttribute = "gte"
Field Value
Type |
---|
System.String |
IconSetAttribute
The icon set to display.
Declaration
public const string IconSetAttribute = "iconSet"
Field Value
Type |
---|
System.String |
IconSetTag
Describes an icon set conditional formatting rule.
Declaration
public const string IconSetTag = "iconSet"
Field Value
Type |
---|
System.String |
IconSetTypeNames
Names used in xml as IconSet type (order is important).
Declaration
public static string[] IconSetTypeNames
Field Value
Type |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
System.String |
NegativeBorderColorTagName
Name of the xml tag that defines the negative border color.
Declaration
public const string NegativeBorderColorTagName = "negativeBorderColor"
Field Value
Type |
---|
System.String |
NegativeFillColorTagName
Name of the xml tag that defines the negative fill color.
Declaration
public const string NegativeFillColorTagName = "negativeFillColor"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
OperatorBeginsWith
Name of the xml tag that represents begin with condition.
Declaration
public const string OperatorBeginsWith = "beginsWith"
Field Value
Type |
---|
System.String |
OperatorBetween
Name of the xml tag that represents between condition.
Declaration
public const string OperatorBetween = "between"
Field Value
Type |
---|
System.String |
OperatorContains
Name of the xml tag that represents contains text condition.
Declaration
public const string OperatorContains = "containsText"
Field Value
Type |
---|
System.String |
OperatorDoesNotContain
Name of the xml tag that represents not contains condition.
Declaration
public const string OperatorDoesNotContain = "notContains"
Field Value
Type |
---|
System.String |
OperatorEndsWith
Name of the xml tag that represents ends with condition.
Declaration
public const string OperatorEndsWith = "endsWith"
Field Value
Type |
---|
System.String |
OperatorEqual
Name of the xml tag that represents equal condition.
Declaration
public const string OperatorEqual = "equal"
Field Value
Type |
---|
System.String |
OperatorGreaterThan
Name of the xml tag that represents greater than condition.
Declaration
public const string OperatorGreaterThan = "greaterThan"
Field Value
Type |
---|
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 |
---|
System.String |
OperatorLessThan
Name of the xml tag that represents less than condition.
Declaration
public const string OperatorLessThan = "lessThan"
Field Value
Type |
---|
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 |
---|
System.String |
OperatorNotBetween
Name of the xml tag that represents not between condition.
Declaration
public const string OperatorNotBetween = "notBetween"
Field Value
Type |
---|
System.String |
OperatorNotEqual
Name of the xml tag that represents not equal condition.
Declaration
public const string OperatorNotEqual = "notEqual"
Field Value
Type |
---|
System.String |
PercentAttribute
Indicates whether the thresholds indicate percentile values, instead of number values.
Declaration
public const string PercentAttribute = "percent"
Field Value
Type |
---|
System.String |
Pivot
Represents conditional formatting rule that contains pivot table.
Declaration
public const string Pivot = "pivot"
Field Value
Type |
---|
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 |
---|
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 |
---|
System.String |
RuleTagName
Name of the xml tag that represents conditional formatting rule.
Declaration
public const string RuleTagName = "cfRule"
Field Value
Type |
---|
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 |
---|
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 |
---|
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 |
---|
System.String |
TimePeriodAttributeName
Name of the xml attribute that represents time period type attribute name.
Declaration
public const string TimePeriodAttributeName = "timePeriod"
Field Value
Type |
---|
System.String |
TimePeriodLastMonth
Last month period type
Declaration
public const string TimePeriodLastMonth = "lastMonth"
Field Value
Type |
---|
System.String |
TimePeriodLastsevenDays
Last seven days time period type
Declaration
public const string TimePeriodLastsevenDays = "last7Days"
Field Value
Type |
---|
System.String |
TimePeriodLastWeek
Last week time period type
Declaration
public const string TimePeriodLastWeek = "lastWeek"
Field Value
Type |
---|
System.String |
TimePeriodNextMonth
Next month time period type
Declaration
public const string TimePeriodNextMonth = "nextMonth"
Field Value
Type |
---|
System.String |
TimePeriodNextWeek
Next week time period type
Declaration
public const string TimePeriodNextWeek = "nextWeek"
Field Value
Type |
---|
System.String |
TimePeriodThisMonth
This month period type
Declaration
public const string TimePeriodThisMonth = "thisMonth"
Field Value
Type |
---|
System.String |
TimePeriodThisWeek
This week time period type
Declaration
public const string TimePeriodThisWeek = "thisWeek"
Field Value
Type |
---|
System.String |
TimePeriodToday
Today's time period type
Declaration
public const string TimePeriodToday = "today"
Field Value
Type |
---|
System.String |
TimePeriodTomorrow
Tomorrow's time period type
Declaration
public const string TimePeriodTomorrow = "tomorrow"
Field Value
Type |
---|
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 |
---|
System.String |
TimePeriodYesterday
Yesterday's time period type
Declaration
public const string TimePeriodYesterday = "yesterday"
Field Value
Type |
---|
System.String |
TypeAttributeName
Name of the xml attribute that represents type of conditional formatting rule.
Declaration
public const string TypeAttributeName = "type"
Field Value
Type |
---|
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 |
---|
System.String |
TypeColorScale
Represents conditional formatting rule that contains color scale.
Declaration
public const string TypeColorScale = "colorScale"
Field Value
Type |
---|
System.String |
TypeContainsBlank
Represents conditional formatting rule highlights cells that are completely blank
Declaration
public const string TypeContainsBlank = "containsBlanks"
Field Value
Type |
---|
System.String |
TypeContainsError
Name of the xml tag that represent contains error conitional formatting.
Declaration
public const string TypeContainsError = "containsErrors"
Field Value
Type |
---|
System.String |
TypeDataBar
Represents conditional formatting rule that contains databar.
Declaration
public const string TypeDataBar = "dataBar"
Field Value
Type |
---|
System.String |
TypeExpression
Represents conditional formatting rule that contains a formula to evaluate.
Declaration
public const string TypeExpression = "expression"
Field Value
Type |
---|
System.String |
TypeIconSet
Represents conditional formatting rule that contains iconset.
Declaration
public const string TypeIconSet = "iconSet"
Field Value
Type |
---|
System.String |
TypeNotContainsBlank
Represents conditional formatting rule highlights cells that are not blank
Declaration
public const string TypeNotContainsBlank = "notContainsBlanks"
Field Value
Type |
---|
System.String |
TypeNotContainsError
Name of the xml tag that represent not Contains Error conitional formatting.
Declaration
public const string TypeNotContainsError = "notContainsErrors"
Field Value
Type |
---|
System.String |
ValueObjectTag
Describes the values of the interpolation points in a gradient scale.
Declaration
public const string ValueObjectTag = "cfvo"
Field Value
Type |
---|
System.String |
ValueTypes
Possible value types for ConditionValue.
Declaration
public static string[] ValueTypes
Field Value
Type |
---|
System.String[] |