Hello Mike, hello Hristo,

thank you for yor replies.

Meanwhile I wrote following code which will work for me and provide the same filter style as excel does.

using System;
using System.Linq;
using Infragistics.Win;
using Infragistics.Win.SupportDialogs.FilterUIProvider;
using Infragistics.Win.UltraWinGrid;

namespace IG.Shared.ExtensionMethods.InfragisticControls
{
	public static class UltraGridExtension
	{
		#region Methods (4)

		// Public Static Methods (2) 

		/// <summary>
		/// Applies the excel filter.
		/// </summary>
		/// <param name="source">The source.</param>
		/// <param name="filterProvider">The filter provider.</param>
		public static void ApplyExcelFilter(this UltraGrid source, UltraGridFilterUIProvider filterProvider)
		{
			source.DisplayLayout.Override.FilterUIProvider = filterProvider;
			source.BeforeRowFilterDropDown += ultraGridBeforeRowFilterDropDown;
			source.AfterRowFilterChanged += ultraGridAfterRowFilterChanged;
		}

		/// <summary>
		/// Removes the excel filter.
		/// </summary>
		/// <param name="source">The source.</param>
		public static void RemoveExcelFilter(this UltraGrid source)
		{
			source.DisplayLayout.Override.FilterUIProvider = null;
			source.BeforeRowFilterDropDown -= ultraGridBeforeRowFilterDropDown;
			source.AfterRowFilterChanged -= ultraGridAfterRowFilterChanged;
		}
		// Private Static Methods (2) 

		/// <summary>
		/// Claims the list ultra grid after row filter changed.
		/// </summary>
		/// <param name="sender">The sender.</param>
		/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.AfterRowFilterChangedEventArgs"/> instance containing the event data.</param>
		private static void ultraGridAfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
		{
			// sets id for filter colunm
			var grid = sender as UltraGrid;
			if (grid == null) { return; }

			// get id
			var filterId = grid.Rows.ColumnFilters.Cast<ColumnFilter>().Max(f => Int32.Parse(f.Tag == null ? "0" : f.Tag.ToString()));
			var currentColumn = grid.Rows.ColumnFilters[e.Column.Key];

			// clear
			if (String.IsNullOrEmpty(currentColumn.ToString())) { currentColumn.Tag = null; }

			// set new if needed
			if (!String.IsNullOrEmpty(currentColumn.ToString()) && currentColumn.Tag == null) { currentColumn.Tag = filterId + 1; }
		}

		/// <summary>
		/// Claims the list ultra grid before row filter drop down.
		/// </summary>
		/// <param name="sender">The sender.</param>
		/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.BeforeRowFilterDropDownEventArgs"/> instance containing the event data.</param>
		private static void ultraGridBeforeRowFilterDropDown(object sender, BeforeRowFilterDropDownEventArgs e)
		{	// implements excel 2007 style filtering

			var grid = sender as UltraGrid;
			if (grid == null) { return; }

			// as in excel still keep all options for the last added filtercondition
			var filterId = grid.Rows.ColumnFilters.Cast<ColumnFilter>().Max(f => Int32.Parse(f.Tag == null ? "0" : f.Tag.ToString()));
			var filterConditions = null as FilterCondition[];
			if ((grid.Rows.ColumnFilters[e.Column.Key].Tag != null && grid.Rows.ColumnFilters[e.Column.Key].Tag.ToString() == filterId.ToString()))
			{
				filterConditions = new FilterCondition[grid.Rows.ColumnFilters[e.Column.Key].FilterConditions.Count];
				grid.Rows.ColumnFilters[e.Column.Key].FilterConditions.CopyTo(filterConditions, 0);
				grid.Rows.ColumnFilters[e.Column.Key].ClearFilterConditions();
			}

			// get default values to keep them and remove only databound not in grid
			var query = from i in e.ValueList.ValueListItems.All.OfType<ValueListItem>()
						where !(from r in grid.Rows
								where !r.IsFilteredOut
								select r).Any(r => r.Cells[e.Column].Text == i.DisplayText) // default values e.g. (All), (Blanks), ...
							  && !(from iSub in e.ValueList.ValueListItems.All.OfType<ValueListItem>()
								   where !(from r in grid.Rows
										   select r.Cells[e.Column].Text).Contains(iSub.DisplayText) // databound values
								   select iSub.DisplayText).Contains(i.DisplayText)
						select i;

			// now remove items
			foreach (var listItem in query.Distinct())
			{
				e.ValueList.ValueListItems.Remove(listItem);
			}

			// put filter back
			if (filterConditions != null && filterConditions.Length > 0)
			{
				foreach (var filterCondition in filterConditions)
				{
					grid.Rows.ColumnFilters[e.Column.Key].FilterConditions.Add(filterCondition);
				}
			}
		}

		#endregion Methods
	}
}

As Excel it keeps "all" possible values for the last added filter condition -> see attached screenshot.

Hello ,

I am glad to hear that your issue is solved.

Please let me know if you need any further assistance.

Hi team

Im trying to use/understand the code, Im using it on VB ,net but having issues on the part of the query.

can some one help me on the matter:
Thanks