In early version of the UltraGrid , the filtering criteria was based on Quantitative ( Equals , GreaterThan , LessThan ) and Non-Quantitative ( StartWith , EndWith , Contains ) comparisons.
This approach introduced an unexpected behavior when a numeric field or a field with formatted mask was filtered using Non-Quantitative comparison. Numeric fields were filtered by value, and they would return an incorrect result in a scenario such as the following:
For example: If a numeric column contained 1.20, and was filtered with “ EndWith .20 ”, it would be filtered by value and return 1.2 instead of 1.20. The trailing zero would be discounted for numeric comparison, and so the comparison would not meet the expectation.
Workaround
The FilterComparisonStyle property now contains a new value called DisplayTextOnly for Non-Quantitative comparison, while the existing values are also available to revert the behavior if a value comparison is required.
As part of the 14.2 release we implemented the INotifyPropertyChanged and INotifyCollectionChanged interfaces in several Excel classes including Workbook , Worksheet , the settings classes and WorksheetCollection on all platforms.
This was done as part of the notification and undo infrastructure needed for WPF platform, however, it may affect WinForms platform temporarily, and will be removed in the October 2014 service release as an optimization.