Filter dropdown doesn't display the whole value set

Filter dropdown doesn't display the whole value set

Posted by: chandrasekar_keerthana on 18 September 2019, 11:01 am EST

• 

  chandrasekar_keerthana

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 September 2019, 11:01 am EST - Updated 3 October 2022, 7:17 pm EST

  Hi Team,
  
  We noticed that the default filter dropdown present in the column headers of the flexsheet displays only limited values when too many records(>1000) are loaded in the flexsheet. Upon searching for a specific value, it is present in the dropdown but when we scroll and try to find it, it’s not listed.

  Attached screenshot for reference. It can be noticed that the positive values are not present in the list(values being in ascending order and scroll bar is at the very end).

  Please let me know if there’s a limit for the number of records that would be displayed at a time. If yes, can it be configured?

  Thanks.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 19 September 2019, 4:26 am EST

  Hi Chandrashekhar,
  
  By default, the FlexSheet Filter shows the 250 values which can be changed as per need by setting the maxValues to desired number as following code snippet:

   let sheetFilter = this.sheet.filter;
      sheetFilter.getColumnFilter(0).valueFilter.maxValues=500;
  

  Please refer to the following demo sample for reference:
  
  https://stackblitz.com/edit/angular-9yhnum?file=src/app/app.component.ts

  Regards,
  
  Manish Gupta