Problem with Customized filter icon

Posted by: amit-p on 8 September 2017, 1:19 pm EST

  • Posted 8 September 2017, 1:19 pm EST

    Hi,

    I am facing an issue with filter icon.

     
    I have two rows for column header of my application. Here I am trying to explain the problem using my (poor) drawing capability  - 

     ___________________________________________________

    Primary header1         |   Primary header 2                             |
    ____________________________________________________

                   flt_icon        |   subheader1   filt_icon |    subheader2 |
    ____________________________________________________
     

    Columns for Primary header1 and subheader1 are having row filtering feature.

     
    The problem comes when I try to merge the rows for primary header1 as follows -  

     

     ___________________________________________________

    Primary header1         |   Primary header 2                             |
                                     _________________________________

                                     |   subheader1   filt_icon |    subheader2 |

    ____________________________________________________

     

    The filt_icon for Primary header1 disappears! Can you please let me know how can I deal with this problem? 

    Can you please tell me how can I get filter icon for Primary header1?

     

    Regards,

    Amit 

  • Replied 8 September 2017, 1:19 pm EST

    Amit -

    You can use the ColumnHeaderAutoFilterIndex property to achieve this.  

  • Replied 8 September 2017, 1:19 pm EST

    Hi Bob,

     
    This gives me partial solution. Because if I change the ColumnHeaderAutoFilterIndex property to 0 i get following,

     
    _____________________________________________________

    Primary header1  filt_con       |   Primary header 2          filt_icon |
                                               ______________________________

                                               |   subheader1        |    subheader2 |

    ____________________________________________________

     

    I want to filter on subheader1 not for Primary header2.

     

    Is there anyway to set the ColumnHeaderAutoFilterIndex for individual columns? so that I can have freedom to filter on my primary or secondary headings?

     
    Regards,

    Amit
     

     

  • Replied 8 September 2017, 1:19 pm EST

    Amit -

    The property is set at the sheet level and applies to all columns.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels