作成日: 2018/12/26 最終更新日: 2018/12/26
文書種別
技術情報
詳細
色フィルタで既定値を選択する際、v10.0J以前は既定の色そのものを表示しておりましたが、v11.0J以降は「自動」という表示に変更されております。
10.0J以前のように色そのものを表示したい場合、以下のように列のForeColorを事前に設定ください。
◎サンプルコード(VB)
◎サンプルコード(C#)
10.0J以前のように色そのものを表示したい場合、以下のように列のForeColorを事前に設定ください。
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
FpSpread1.ActiveSheet.Cells(0, 0).Text = "A"
FpSpread1.ActiveSheet.Cells(1, 0).Text = "B"
FpSpread1.ActiveSheet.Cells(2, 0).Text = "C"
FpSpread1.ActiveSheet.Columns(0).ForeColor = Color.Black
FpSpread1.ActiveSheet.Cells(0, 0).ForeColor = Color.Red
End Sub
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
FpSpread1.ActiveSheet.Cells(0, 0).Text = "A"
FpSpread1.ActiveSheet.Cells(1, 0).Text = "B"
FpSpread1.ActiveSheet.Cells(2, 0).Text = "C"
FpSpread1.ActiveSheet.Columns(0).ForeColor = Color.Black
FpSpread1.ActiveSheet.Cells(0, 0).ForeColor = Color.Red
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Cells[0, 0].Text = "A";
fpSpread1.ActiveSheet.Cells[1, 0].Text = "B";
fpSpread1.ActiveSheet.Cells[2, 0].Text = "C";
fpSpread1.ActiveSheet.Columns[0].ForeColor = Color.Black;
fpSpread1.ActiveSheet.Cells[0, 0].ForeColor = Color.Red;
}
{
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Cells[0, 0].Text = "A";
fpSpread1.ActiveSheet.Cells[1, 0].Text = "B";
fpSpread1.ActiveSheet.Cells[2, 0].Text = "C";
fpSpread1.ActiveSheet.Columns[0].ForeColor = Color.Black;
fpSpread1.ActiveSheet.Cells[0, 0].ForeColor = Color.Red;
}
旧文書番号
83494