Auto Filter Hangs the application

Posted by: kiruthi on 8 September 2017, 1:19 pm EST

  • Posted 8 September 2017, 1:19 pm EST

    I'm using Farpoint Spread for Windows v4.0. I have binded a datatable with the spread and enabled Autofilter option for all the columns. Datatable has only 4 records. But still If I try to filter the records, CPU utilization hits 100% and it just freezes the application. Can anyone help me with this?


     


    fpSpread1.Sheets[0].DataSource = dt;


    fpSpread1.Sheets[0].Columns[0, 7].AllowAutoFilter = true;

  • Replied 8 September 2017, 1:19 pm EST

    kiruthi -

    I tested this with dataset that has 50 rows and 20 columns and the filter happens immediately without any issues.  Make sure you have the latest maintenance release.  If you do can you post a small project that reproduces this for us to debug?

  • Replied 8 September 2017, 1:19 pm EST

    Thanks for your quick response.


    I'm using win Spread version 4.0.2000.2005 & runtime version v2.0.50727. Can you let me know how I can check if this is the latest version? I have attached the sample application that is causing the same issue. I tried to run this in a couple of other workstations and got the same issue. In this project, I'm loading the grid on the button click. If I try to filter the column, it just freezes. Try to filter by SELL_PRICE column


     


    2008/07/FarPoint-2.zip
  • Replied 8 September 2017, 1:19 pm EST

    kiruthi -

    This is, in fact, an issue with the version you are using.  You need to get version 4.0.2003.2005 off our website.  I tested your project and saw the issue and then changed the references to the latest version and it works correctly.

  • Replied 8 September 2017, 1:19 pm EST

    Thanks a lot Bob. The new version fixed the issue.
Need extra support?

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

Learn More

Forum Channels