When applying the Top/Bottom Rules -> Bottom 10 Items… or Bottom 10%… the formatting is not applied correctly because there are nulls in the column. Is there a way to exclude nulls from the conditional formatting similar to how the summary is handled (SummariesIgnoreNullValues property)?
Conditional Formatting doesn't take into account null values when the Top/Bottom rule is applied
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
- v15.2.4Download Official Update
- v15.1.8Download Official Update
Hello,
I have tried to replicate this behavior in a sample project, but did not succeed. Attached is a project that illustrates my attempts to reproduce your scenario and the issue you are experiencing.
Please modify this project so that it illustrates the problematic behavior and send it to us or provide us with yours.
Thanks,
Andrey
I have updated your sample a bit so it matches my case a little closer. I am not sure if I set it up quite right though since the conditional formatting menu in the context menu doesn't seem correct for numeric values.
In the application I am working on we have dynamic columns setup (which are added in code with the UnboundType to match the actual data. In the current scenario that type is Decimal).
I am not sure where the ShowEditor() question came from.
Hi Doug,
I have checked the project and noticed that format conditions are not applied to the second column at all. The issue occurs because this column's filed name matches the real property name (Age2). As a result, the column thinks that its data type is an object (because Age2 is an object). I have modified the project so that the second column has the formatting applied, however null values are not ignored. Just to ensure that we are on the same page, would you please confirm this is the same issue you are experiencing in your real project?
Thanks,
Alexander
Yes, this is the issue I am seeing. Since our grids normally have over 100 rows and sparse data sets, it is common for a column to have more than 10 rows with null values. As a result this made it look like the bottom rules were not working at all.
Hi Doug,
It looks like our developers have found a way to fix this issue. I will pass this ticket to them for further research. We will let you know once we make any progress.