Following are the breaking changes for Conditional Format.
|
PrePaintResult Execute |
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 |
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. | |
|
|
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. | |
|
|
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 |
||
| BetweenValuesConditionalFormattingRule (bool suppressCustomName) |
||
| UnaryComparisonConditionalFormattingRule (bool suppressCustomName) |
||
| TwoColorScaleConditionalFormattingRule (bool suppressCustomName) |
||
| ThreeColorScaleConditionalFormattingRule (bool suppressCustomName) |
||
| IconSetConditionalFormattingRule (bool suppressCustomName) |
||
| FormulaConditionalFormattingRule (bool suppressCustomName) |
||
|
|
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.