Spread.NET
Conditional Format

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 Spread for WinForms Breaking Changes.