BN089-BS开发框架MVC4版/source20131023/Zephyr.Net/Zephyr.Utils/Document/Excel/EPPlus/ConditionalFormatting/CF Implementation.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

#region TODO
//TODO: Add the "DataBar" extended options
//TODO: Add tests for all the rules
//TODO: Add the IconSet options
//TODO: Add all the "extList" options
#endregion

#region §18.3.1.18 conditionalFormatting (Conditional Formatting)
//Childs:
//cfRule          (Conditional Formatting Rule) §18.3.1.10
//extLst          (Future Feature Data Storage Area) §18.2.10

//Attributes:
//pivot
//sqref           ST_Sqref simple type (§18.18.76)
#endregion

#region §18.3.1.10 cfRule (Conditional Formatting Rule)
//Childs:
//colorScale      (Color Scale) §18.3.1.16
//dataBar         (Data Bar) §18.3.1.28
//extLst          (Future Feature Data Storage Area) §18.2.10
//formula         (Formula) §18.3.1.43
//iconSet         (Icon Set) §18.3.1.49

//Attributes:
//-----------
//priority        (Priority) The priority of this conditional formatting rule. This value is used to determine which
//                format should be evaluated and rendered. Lower numeric values are higher priority than
//                higher numeric values, where 1 is the highest priority.
//stopIfTrue      (Stop If True) If this flag is 1, no rules with lower priority shall be applied over this rule, when this rule
//                evaluates to true.
//type            (Type) Type of conditional formatting rule. ST_CfType §18.18.12.
//aboveAverage    Indicates whether the rule is an "above average" rule. 1 indicates 'above average'.
//                This attribute is ignored if type is not equal to aboveAverage.
//equalAverage    (Equal Average)
//                Flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the
//                average itself, or exclusive of that value. 1 indicates to include the average value in the
//                criteria. This attribute is ignored if type is not equal to aboveAverage.
//bottom          (Bottom N) Indicates whether a "top/bottom n" rule is a "bottom n" rule. 1 indicates 'bottom'.
//                This attribute is ignored if type is not equal to top10.
//dxfId           (Differential Formatting Id)
//                This is an index to a dxf element in the Styles Part indicating which cell formatting to
//                apply when the conditional formatting rule criteria is met. ST_DxfId simple type (§18.18.25).
//operator        (Operator) The operator in a "cell value is" conditional formatting rule. This attribute is ignored if
//                type is not equal to cellIs. The possible values ST_ConditionalFormattingOperator simple type (§18.18.15).
//percent         (Top 10 Percent)
//                Indicates whether a "top/bottom n" rule is a "top/bottom n percent" rule. This attribute
//                is ignored if type is not equal to top10.
//rank            (Rank) The value of "n" in a "top/bottom n" conditional formatting rule. This attribute is ignored
//                if type is not equal to top10.
//stdDev          (StdDev) The number of standard deviations to include above or below the average in the
//                conditional formatting rule. This attribute is ignored if type is not equal to aboveAverage.
//                If a value is present for stdDev and the rule type = aboveAverage, then this rule is automatically an
//                "above or below N standard deviations" rule.
//text            (Text) The text value in a "text contains" conditional formatting rule. This attribute is ignored if
//                type is not equal to containsText.
//timePeriod      (Time Period) The applicable time period in a "date occurring…" conditional formatting rule. This
//                attribute is ignored if type is not equal to timePeriod. ST_TimePeriod §18.18.82.
#endregion