FarPoint.Win.Spread.CellType.FilterBarCellType ct = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct.ShowDropDownMenuStrip = true;
ct.ShowEditor = true;
ct.ShowLabel = true;
ct.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
System.Globalization.DateTimeFormatInfo dtformat = new System.Globalization.DateTimeFormatInfo();
dtformat.ShortDatePattern = "yy/MM/dd";
dtformat.ShortTimePattern = "";
dtformat.LongTimePattern = "";
ct.DateTimeFormatInfo = dtformat;
ct.AutoFormat = true;
FarPoint.Win.Spread.CellType.FilterBarCellType ct1 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct1.ShowEditor = true;
ct1.ShowLabel = true;
ct1.FormatString = "dd";
ct1.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
ct1.AutoFormat = true;
FarPoint.Win.Spread.CellType.FilterBarCellType ct2 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct2.ShowEditor = true;
ct2.ShowLabel = true;
System.Globalization.NumberFormatInfo num = new System.Globalization.NumberFormatInfo();
num.CurrencySymbol = "$";
num.CurrencyDecimalDigits = 3;
ct2.NumberFormatInfo = num;
ct2.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.Number;
ct2.AutoFormat = true;
fpSpread1.ActiveSheet.FilterBar.Cells[0].CellType = ct;
fpSpread1.ActiveSheet.FilterBar.Cells[0].BackColor = Color.Red;
fpSpread1.ActiveSheet.FilterBar.Cells[1].CellType = ct1;
fpSpread1.ActiveSheet.FilterBar.Cells[1].BackColor = Color.Aqua;
fpSpread1.ActiveSheet.FilterBar.Cells[2].CellType = ct2;
fpSpread1.ActiveSheet.FilterBar.Cells[2].BackColor = Color.Yellow;
fpSpread1.ActiveSheet.ColumnHeader.Columns[0].Label = "DateTime";
fpSpread1.ActiveSheet.ColumnHeader.Columns[1].Label = "FormatString";
fpSpread1.ActiveSheet.ColumnHeader.Columns[2].Label = "Number";
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
fpSpread1.ActiveSheet.Cells[0, 1].CellType = new FarPoint.Win.Spread.CellType.DateTimeCellType();