In the Handsontable React version, I initially created 104 parent rows, each with nested child rows, resulting in a total of 189 rows. However, when applying a filter to any column, the filtering logic only considers data within the range of the initial 104 parent rows and their nested children. The remaining rows beyond this range are excluded from the filter evaluation.
To further validate this behavior, I tested a scenario with 150 parent rows and their respective nested children, resulting in a total row count of 200. Even in this case, the filter only processed data within the scope of the initial 150 parent rows, ignoring the additional rows.
This limitation in the built-in Handsontable filter functionality is a critical issue we’re currently facing. Unfortunately, we couldn’t find a solution or relevant documentation addressing this behavior. A resolution is urgently needed.