Filter ListGrid

Posted by: jvjvjv on 8 September 2017, 3:12 pm EST

  • Posted 8 September 2017, 3:12 pm EST

    Hi ,

    I m using spread6th version. Hidden rows are added into filter listgrid.. can we restrict hidden row data or customize the filter listgrid data?
  • Replied 8 September 2017, 3:12 pm EST

    Hello,

    The behaviour that you are currently observing is a design behaviour. The rows are simply hidden from the DataView, however the associated data still remains in the Data Model. The filter drop down list is populated from the data in the Data Model and hence it even shows the values in the hidden rows.

    There is not a direct way to remove the DefaultFilterItems from the drop down list. However, you can create a custom filter and apply the same on the column so as to avoid the dsiaply of the hidden rows value in the filter drop down list. Please refer to the following link that describes how you can create custom filter: http://helpcentral.componentone.com/NetHelp/SpreadNet7/WF/webframe.html#spwin-filter-custom.html

    Hope it helps.

    Thanks,
    Manpreet Kaur
  • Replied 8 September 2017, 3:12 pm EST

    There is an easier way to do this using UnfilteredRows:

    http://helpcentral.componentone.com/NetHelp/SpreadNet6/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.IRowFilter~UnfilteredRows.html

    You can specify specific rows to exclude from filtering, and those rows won't show in the drop-down:

    sheetView.RowFilter.UnfilteredRows = new Integer() {2, 4, 6}


    Regards,
    -Sean
Need extra support?

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

Learn More

Forum Channels