Customize Sheet FilterBar

Customize Sheet FilterBar

Posted by: develop on 23 September 2024, 7:54 am EST

• 

  develop

  • Post Options:
  • Link
    Copy

  Posted 23 September 2024, 7:54 am EST - Updated 23 September 2024, 7:59 am EST

  I want to customize the filter bar in a sheet.

  1. How can I hide the filter symbol and disable the context menu?
  2. How can I set the “Contains” filter directly in source-code?
     
     
• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 24 September 2024, 11:30 pm EST

  Hi,

  1. You can hide the filter icon of the filter bar by defining the renderer for the FilterBarCellType as follows:

  FilterBarCellType filterBarCellType = new FilterBarCellType();
  filterBarCellType.ShowDropDownMenuStrip = false;
  filterBarCellType.SubEditor = null;
  fpSpread1.DefaultSkin.FilterBarDefaultStyle.Renderer = filterBarCellType;

  2. Could you please provide more details about your use case? Specifically, why is the filter bar essential in your scenario? Understanding your exact requirements will help us suggest a better approach that may be more suitable for your needs.

  Thanks & Regards,
  
  Aastha