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

    <p>Hi,</p><p>I am facing an issue with filter icon.</p><p> <br>I have two rows for column header of my application. Here I am trying to explain the problem using my (poor) drawing capability  - <br> </p><p> ___________________________________________________</p><p>Primary header1         |   Primary header 2                             |<br>____________________________________________________</p><p>               flt_icon        |   subheader1   filt_icon |    subheader2 |<br>____________________________________________________<br> </p><p>Columns for Primary header1 and subheader1 are having row filtering feature. </p><p> <br>The problem comes when I try to merge the rows for primary header1 as follows -  </p><p> </p><p> ___________________________________________________</p><p>Primary header1         |   Primary header 2                             |<br>                                 _________________________________</p>                                 |   subheader1   filt_icon |    subheader2 |<br>
    ____________________________________________________<br>
    <p> </p><p>The filt_icon for Primary header1 disappears! Can you please let me know how can I deal with this problem?  </p><p>Can you please tell me how can I get filter icon for Primary header1?</p><p> </p><p>Regards,</p><p>Amit </p>
  • Replied 8 September 2017, 1:19 pm EST

    <p>Amit -</p><p>You can use the ColumnHeaderAutoFilterIndex property to achieve this.   <br></p>
  • Replied 8 September 2017, 1:19 pm EST

    <p>Hi Bob,</p><p> <br>This gives me partial solution. Because if I change the ColumnHeaderAutoFilterIndex property to 0 i get following,</p><p> <br>_____________________________________________________</p><p>Primary header1  filt_con       |   Primary header 2          filt_icon |<br>                                           ______________________________</p>                                           |   subheader1        |    subheader2 |<br>
    ____________________________________________________<br>
    <p> </p><p>I want to filter on subheader1 not for Primary header2.</p><p> </p><p>Is there anyway to set the ColumnHeaderAutoFilterIndex for individual columns? so that I can have freedom to filter on my primary or secondary headings? </p><p> <br>Regards,</p><p>Amit<br> </p><p> </p>
  • Replied 8 September 2017, 1:19 pm EST

    <p>Amit -</p><p>The property is set at the sheet level and applies to all columns. <br></p>
Need extra support?

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

Learn More

Forum Channels