menu

Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class CF - Xamarin.Android API Reference | Syncfusion

    Show / Hide Table of Contents

    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
    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[]
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved