FilterMenuType 列挙体

フィルタバーのフィルタメニューのタイプ。

構文

Visual Basic
C#

'Declaration
 
Public Enum FilterMenuType 
   Inherits System.Enum

public enum FilterMenuType : System.Enum

メンバ

メンバ	説明
Auto	列のデータを分析することによってメニュータイプが自動的に決定されます。
Date	日時フィルタメニュー。
Enhanced	拡張フィルタメニュー。
Number	数値フィルタメニュー。
Text	テキストフィルタメニュー。

例

次のサンプルコードは、FilterMenuType列挙体を使用します。

C#
Visual Basic

FarPoint.Web.Spread.FilterBarCellType ct = new FarPoint.Web.Spread.FilterBarCellType();
ct.MenuType = FarPoint.Web.Spread.FilterMenuType.Date;            
System.Globalization.DateTimeFormatInfo dtformat = new System.Globalization.DateTimeFormatInfo();
dtformat.ShortDatePattern = "yy/MM/dd";
dtformat.ShortTimePattern = "";
dtformat.LongTimePattern = "";
ct.DateTimeFormat = dtformat;
ct.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto;

FarPoint.Web.Spread.FilterBarCellType ct1 = new FarPoint.Web.Spread.FilterBarCellType();
ct1.FormatString = "dd";
ct1.MenuType = FarPoint.Web.Spread.FilterMenuType.Date;
           
FarPoint.Web.Spread.FilterBarCellType ct2 = new FarPoint.Web.Spread.FilterBarCellType();   
ct2.MenuType = FarPoint.Web.Spread.FilterMenuType.Number;

FpSpread1.ActiveSheetView.FilterBar.Cells[0].CellType = ct;
FpSpread1.ActiveSheetView.FilterBar.Cells[0].BackColor = System.Drawing.Color.Red;
FpSpread1.ActiveSheetView.FilterBar.Cells[1].CellType = ct1;
FpSpread1.ActiveSheetView.FilterBar.Cells[1].BackColor = System.Drawing.Color.Aqua;
FpSpread1.ActiveSheetView.FilterBar.Cells[2].CellType = ct2;
FpSpread1.ActiveSheetView.FilterBar.Cells[2].BackColor = System.Drawing.Color.Yellow;
           
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = new FarPoint.Web.Spread.DateTimeCellType();
FpSpread1.ActiveSheetView.Cells[0, 1].CellType = new FarPoint.Web.Spread.DateTimeCellType();
FpSpread1.ActiveSheetView.Cells[0, 2].CellType = new FarPoint.Web.Spread.CurrencyCellType();
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
FpSpread1.ActiveSheetView.Cells[0, 1].Value = DateTime.Today;
FpSpread1.ActiveSheetView.Cells[0, 2].Value = 33.34;

Dim ct As New FarPoint.Web.Spread.FilterBarCellType()
ct.MenuType = FarPoint.Web.Spread.FilterMenuType.Date
Dim dtformat As New System.Globalization.DateTimeFormatInfo()
dtformat.ShortDatePattern = "yy/MM/dd"
dtformat.ShortTimePattern = ""
dtformat.LongTimePattern = ""
ct.DateTimeFormat = dtformat
ct.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto

Dim ct1 As New FarPoint.Web.Spread.FilterBarCellType()
ct1.FormatString = "dd"
ct1.MenuType = FarPoint.Web.Spread.FilterMenuType.Date

Dim ct2 As New FarPoint.Web.Spread.FilterBarCellType()
ct2.MenuType = FarPoint.Web.Spread.FilterMenuType.Number

FpSpread1.ActiveSheetView.FilterBar.Cells(0).CellType = ct
FpSpread1.ActiveSheetView.FilterBar.Cells(0).BackColor = System.Drawing.Color.Red
FpSpread1.ActiveSheetView.FilterBar.Cells(1).CellType = ct1
FpSpread1.ActiveSheetView.FilterBar.Cells(1).BackColor = System.Drawing.Color.Aqua
FpSpread1.ActiveSheetView.FilterBar.Cells(2).CellType = ct2
FpSpread1.ActiveSheetView.FilterBar.Cells(2).BackColor = System.Drawing.Color.Yellow
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = New FarPoint.Web.Spread.DateTimeCellType()
FpSpread1.ActiveSheetView.Cells(0, 1).CellType = New FarPoint.Web.Spread.DateTimeCellType()
FpSpread1.ActiveSheetView.Cells(0, 2).CellType = New FarPoint.Web.Spread.CurrencyCellType()
FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
FpSpread1.ActiveSheetView.Cells(0, 1).Value = DateTime.Today
FpSpread1.ActiveSheetView.Cells(0, 2).Value = 33.34

継承階層

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.FilterMenuType

参照

FarPoint.Web.Spread 名前空間