Gets or sets the type of filter bar context menu.
Syntax
Example
This example sets the ContextMenuType property.
C# | Copy Code |
---|
FarPoint.Win.Spread.CellType.FilterBarCellType fbcell = new FarPoint.Win.Spread.CellType.FilterBarCellType();
fbcell.AutoFormat = true;
fbcell.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
fpSpread1.Sheets[0].FilterBar.Cells[0].CellType = fbcell;
fpSpread1.Sheets[0].FilterBar.Cells[0].BackColor = Color.Aqua;
fpSpread1.Sheets[0].FilterBar.Cells[0].ForeColor = Color.Black;
fpSpread1.Sheets[0].Cells[0, 0].Value = DateTime.Now; |
VB.NET | Copy Code |
---|
Dim fbcell As New FarPoint.Win.Spread.CellType.FilterBarCellType()
fbcell.AutoFormat = True
fbcell.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime
fpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
fpSpread1.Sheets(0).FilterBar.Cells(0).CellType = fbcell
fpSpread1.Sheets(0).FilterBar.Cells(0).BackColor = Color.Aqua
fpSpread1.Sheets(0).FilterBar.Cells(0).ForeColor = Color.Black
fpSpread1.Sheets(0).Cells(0, 0).Value = DateTime.Now |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also