Spread.NET ReadMe Documentation
In This Topic
    Conditional Format
    In This Topic

    Following are the breaking changes for Conditional Format.

    PrePaintResult Execute
    (int row, int column, object value)

    PrePaintResult Execute
    (object value)

    The "Execute" method has been marked as obsolete in Spread for WinForms 11.
    CellRange             CellRange (row, column, 0, 0) (row /column! = -1) will not be accepted while creating new ConditionalFormatting rule. Now an exception will be thrown while creating new ConditionalFormatting with this CellRange.
    Formula support Spread for WinForms 10 did not allow setting ConditionalFormattingValue with a RelativeFormula. 
    Spread for WinForms 11 allows setting RelativeFormula (like Excel). The RelativeFormula gets converted to AbsoluteFormula on being set.

    class
    ConditionalFormattingModel

    Event ConditionalFormattingChanged

    In Spread for WinForms 10, the ConditionalFormattingChanged event was fired only for the ConditionalFormatting.
    In Spread for WinForms 11, the event notifies about all ConditionalFormatting's that are changed.

    ConditionalFormattingIconValue

    In Spread for WinForms 11, the value of last condition of ConditionalFormattingIconValue is converted to default value.


    ConditionalFormattingColorValue, DatabarConditionalFormattingRule

    Spread for WinForms 11 does not let ConditionalFormattingColorValue and DatabarConditionalFormattingRule to store style, value, and type for ColorScale/DataBar ConditionalFormatting in order to reduce the redundant data.



    View Indexes

    In Spread for WinForms 10, on creating new view indexes, for example by moving the data from one cell range to other, the conditional formatting still applied to the original cell range.
    In Spread for WinForms 11, this behavior has changed. Now, conditional formatting sticks with data and not cell range, resulting in conditional formatting to appear at the new indexes where the cell range has been moved or mapped.

    Restriction Formula

    RangeResult

    In Spread for WinForms 10, RangeResult formula was not supported.
    In Spread for WinForms 11, this formula is supported and it follows the behavior of Excel API.

    RelativeFormula

    In Spread for WinForms 10, RelativeFormula formula was not supported.
    In Spread for WinForms 11, this formula is supported and it follows the behavior of Excel API.

    UnionOperator

    In Spread for WinForms 10, UnionOperator formula was supported.
    In Spread for WinForms 11, this formula logic is not supported.

    SourceOperator with CustomName

    In Spread for WinForms 10, SourceOperator with CustomName formula was supported.
    In Spread for WinForms 11, this formula logic is not supported, ensuring increased similarity to Excel.

    ConditionalFormattingValue

    CustomName

    In Spread for WinForms 10, CustomName formula was not supported.
    In Spread for WinForms 11, this formula is supported.

    RangeResult

    In Spread for WinForms 10, RangeResult formula was not supported.
    In Spread for WinForms 11, this formula is supported.

    RelativeFormula

    In Spread for WinForms 10, RelativeFormula formula was not supported.
    In Spread for WinForms 11, this formula is supported.

    Import/Export Excel

    In Spread for WinForms 10, conditional formatting was effected only on row/column once the Spread was imported/exported to Excel.
    In Spread for WinForms 11, conditional formatting is effected on the entire range while importing/exporting.

    Enum ConditionalFormattingIcon

    ConditionalFormattingIcon enum is obsolete in Spread for WinForms 11. Use ConditionalFormattingIconSetIndex class instead.
    Enum CFFormulaType CFFormulaType enum is obsolete in Spread for WinForms 11.

    Class ConditionalFormattingModel

    IRangeSupport APIs
    (like Add, Move, Swap, Copy)

    All the listed class members are obsolete in Spread for WinForms 11.

    AdjustSplittingConditionalFormattings()
    Event Changed

    Class ConditionalFormatting
    Event ConditionalFormattingSplit

    All the listed class members are obsolete in Spread for WinForms 11.

    Event Changed
    DoubleValues
    ValuesCount
    Class IconSetConditionalFormattingRule Property Reversed Reversed property is obsolete in Spread for WinForms 11. Use Reverse() instead.
    Class ColorScaleConditionalFormattingRule Property MidValues MidValues property is obsolete in Spread for WinForms 11.

    SuppressCustomName

    DatabarConditionalFormattingRule
    (bool suppressCustomName)

    All the listed constructors are obsolete in Spread for WinForms 11.

    TextConditionalFormattingRule
    (bool suppressCustomName)

    BetweenValuesConditionalFormattingRule
    (bool suppressCustomName)
    UnaryComparisonConditionalFormattingRule
    (bool suppressCustomName)
    TwoColorScaleConditionalFormattingRule
    (bool suppressCustomName)
    ThreeColorScaleConditionalFormattingRule
    (bool suppressCustomName)
    IconSetConditionalFormattingRule
    (bool suppressCustomName)
    FormulaConditionalFormattingRule
    (bool suppressCustomName)


    ObjectExpressionProvider

    List<RangeElement<ExpressionConsumer
    FormulationInfo>>GetAdjustingFormulaInfo(IExpressionConsumer obj)

    All the listed APIs are obsolete in Spread for WinForms 11.

    FormulaContextType GetFormulaContextType(IExpressionConsumer obj, int index)
    void UpdateFormulasWhenModelChanged(ISheetDataModel newModel, ISheetDataModel oldModel)



    IExpressionConsumer

    void NotifyChanged
    (int index, FormulaChangedType changeType)

    All the listed class members are obsolete in Spread for WinForms 11.

    FormulaRestrictedCondition GetRestrictions(int index)
    void NotifyNotSatisfied
    (int index, FormulaRestrictedCondition notSatisfiedConditions)

    Back to Breaking Changes for Version 11.40.20177.0.