Posted 4 February 2019, 7:40 pm EST
Using Spread 11 for WinForms I have run into a odd issue. When using my program with smaller spreadsheets (<500 rows for sure, but it looks like <900 is working as well), the filter seems to be working for the most part. When it meets a condition it removes the unwanted rows, and things seem to be working well.
However, when I load more rows (e.g. 6500), it stops working properly. It finds the appropriate filtered matches within the first 461 rows, moves the positive matches to the top, puts the “filtered out” rows just under (so they don’t actually get removed from the screen), and then all other rows stay under the “filtered out” rows as if they were not touched. I did a test where I searched for rows that I can see the data for, however the value is in the second half of the rows, and it finds zero results (everything stays unchanged).
My assumption is that the filtering is not listening to my models RowCount properly (I’m assuming that because the default row count is 500 IIRC, close to 461). I had a similar issue, however I fixed it by moving my DataSource above the DataModel during setup and that fixed it. My other thought is it could be an “optimization” feature of Spread that I am not aware of, where too big of sheets only have the first few hundred rows filtered for, or something like that.
Any ideas of what could be causing this?
