FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : FilterActiveDisabled Field |
'Declaration Public Const FilterActiveDisabled As Integer
'Usage Dim value As Integer value = SpreadView.FilterActiveDisabled
public const int FilterActiveDisabled
FarPoint.Win.Spread.SpreadView workbook = fpSpread1.GetRootworkbook(); workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterActive, Image.FromFile("D:\filter-act-enable.bmp")); workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterActiveDisabled, Image.FromFile("D:\filter-act-disable.bmp")); workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterInactive, Image.FromFile("D:\filter-inact-ena.bmp")); workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterInactiveDisabled, Image.FromFile("D:\filter-inact-dis.bmp")); Random r = new Random(); int i, j = 0; for (i = 0; i <= 3; i++) for (j = 0; j<= 3; j++) { fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString()); } fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true; Image indicator; indicator = workbook.GetImage(4); pictureBox1.Image = indicator;
Dim workbook As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootworkbook() workbook.SetImage(workbook.FilterActive, Image.FromFile("D:\filter-act-enable.bmp")) workbook.SetImage(workbook.FilterActiveDisabled, Image.FromFile("D:\filter-act-disable.bmp")) workbook.SetImage(workbook.FilterInactive, Image.FromFile("D:\filter-inact-ena.bmp")) workbook.SetImage(workbook.FilterInactiveDisabled, Image.FromFile("D:\filter-inact-dis.bmp")) Dim r As New Random Dim i, j As Integer For i = 0 To 3 For j = 0 To 3 FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString()) Next j Next i FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True Dim indicator As Image indicator = workbook.GetImage(4) PictureBox1.Image = indicator
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8