作成日: 2017/05/01 最終更新日: 2017/05/01
文書種別
使用方法
詳細
下記のような方法で、自動的に表示されるフィルタリング条件の文字列(「(All)」、「(Blanks)」、「(NonBlanks)」)を自由に変更することができます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.RowCount = 5
' テストデータの設定
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "apple"
FpSpread1.ActiveSheetView.Cells(1, 0).Value = "orange"
FpSpread1.ActiveSheetView.Cells(2, 0).Value = "pear"
' 1列目に非表示フィルタを設定
Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(0)
Dim hf As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
hf.AddColumn(fcd)
FpSpread1.ActiveSheetView.RowFilter = hf
'フィルタリング文字列を変更
FpSpread1.ActiveSheetView.RowFilter.AllString = "すべて"
FpSpread1.ActiveSheetView.RowFilter.BlanksString = "空白セル"
FpSpread1.ActiveSheetView.RowFilter.NonBlanksString = "空白以外のセル"
End Sub
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.RowCount = 5
' テストデータの設定
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "apple"
FpSpread1.ActiveSheetView.Cells(1, 0).Value = "orange"
FpSpread1.ActiveSheetView.Cells(2, 0).Value = "pear"
' 1列目に非表示フィルタを設定
Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(0)
Dim hf As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
hf.AddColumn(fcd)
FpSpread1.ActiveSheetView.RowFilter = hf
'フィルタリング文字列を変更
FpSpread1.ActiveSheetView.RowFilter.AllString = "すべて"
FpSpread1.ActiveSheetView.RowFilter.BlanksString = "空白セル"
FpSpread1.ActiveSheetView.RowFilter.NonBlanksString = "空白以外のセル"
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.RowCount = 5;
// テストデータの設定
FpSpread1.ActiveSheetView.Cells[0, 0].Value = "apple";
FpSpread1.ActiveSheetView.Cells[1, 0].Value = "orange";
FpSpread1.ActiveSheetView.Cells[2, 0].Value = "pear";
// 1列目に非表示フィルタを設定
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(0);
FarPoint.Web.Spread.HideRowFilter hf = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
hf.AddColumn(fcd);
FpSpread1.ActiveSheetView.RowFilter = hf;
//フィルタリング文字列を変更
FpSpread1.ActiveSheetView.RowFilter.AllString = "すべて";
FpSpread1.ActiveSheetView.RowFilter.BlanksString = "空白セル";
FpSpread1.ActiveSheetView.RowFilter.NonBlanksString = "空白以外のセル";
}
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.RowCount = 5;
// テストデータの設定
FpSpread1.ActiveSheetView.Cells[0, 0].Value = "apple";
FpSpread1.ActiveSheetView.Cells[1, 0].Value = "orange";
FpSpread1.ActiveSheetView.Cells[2, 0].Value = "pear";
// 1列目に非表示フィルタを設定
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(0);
FarPoint.Web.Spread.HideRowFilter hf = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
hf.AddColumn(fcd);
FpSpread1.ActiveSheetView.RowFilter = hf;
//フィルタリング文字列を変更
FpSpread1.ActiveSheetView.RowFilter.AllString = "すべて";
FpSpread1.ActiveSheetView.RowFilter.BlanksString = "空白セル";
FpSpread1.ActiveSheetView.RowFilter.NonBlanksString = "空白以外のセル";
}
旧文書番号
40332