Bug Report T290356
Visible to All Users

Conditional Formatting doesn't take into account null values when the Top/Bottom rule is applied

created 9 years ago

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)?

Show previous comments (2)
Alexander Russkov (DevExpress) 9 years ago

    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.

      DevExpress Support Team 9 years ago

        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.

        Answers approved by DevExpress Support

        created 9 years ago

        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.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.