Hi Mahesh,
We have
loaded an excel file into the spreadsheet that contains about > 3K records.
When applied filter and checked up to 1001 rows (check box selection) are
visible in the filter pop-up displayed. Other records are fetched when entering
those values on the search filter area.
This is due
to the cause that when rendering the spreadsheet component, we render the rows
and columns by virtualization method i.e., only limited number of rows and
columns rendered to the DOM. More rows and columns are rendered upon scrolling
within the sheet.
When loading
the file with data more than the rendered range, the data will be maintained in
the Workbook model and will get updated to the respective cells defined. On
your case the filter pop-up displays the values up to the rendered range and
other than those are being maintained at model and are fetched when tried to
search. This was the behavior at our end.
If we
misunderstood your reported requirement kindly share the below requested
details.
- Please, provide a detailed information on your
requirement and what you meant by filter bar.?
- If possible, share screenshot (or) video demo for your requirement.
That would be helpful for us for better understanding.
Get back to
us for further clarifications.
