DateTimeGroupingType Enumeration | Spread Windows Forms 13.0 Product Documentation

DateTimeGroupingType Enumeration

In This Topic

Specifies the part of the date time value used in a comparision.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum DateTimeGroupingType 
   Inherits System.Enum

'Usage
 
Dim instance As DateTimeGroupingType

public enum DateTimeGroupingType : System.Enum

Members

Member	Description
All	Specifies datetime values compared by all values
Date	Specifies datetime values compared by date (time is ignored)
Day	Specifies datetime values compared by day
Hour	Specifies datetime values compared by hour
Minute	Specifies datetime values compared by minute
Month	Specifies datetime values compared by month
Second	Specifies datetime values compared by second
Year	Specifies datetime values compared by year

Example

This example uses the DateTimeGroupingType enumeration.

FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2);
fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
fpSpread1.Sheets[0].Cells[2, 1].Text = "2/17/2016";
fpSpread1.Sheets[0].Cells[2, 2].Value = "Press";
fpSpread1.Sheets[0].Cells[3, 1].Text = "12/31/1990";
fpSpread1.Sheets[0].Cells[3, 2].Value = "Press";
fpSpread1.Sheets[0].Cells[4, 1].Text = "2017";
fpSpread1.Sheets[0].Cells[4, 2].Value = "test";
fpSpread1.TableStyleCollection.Add(tstyle);
FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1");

FarPoint.Win.Spread.FilterItemValue test = new FarPoint.Win.Spread.FilterItemValue(System.DateTime.Today, FarPoint.Win.Spread.DateTimeGroupingType.Year);
FarPoint.Win.Spread.FilterItemValue test1 = new FarPoint.Win.Spread.FilterItemValue(new System.DateTime(1990, 12, 31), FarPoint.Win.Spread.DateTimeGroupingType.Year);
FarPoint.Win.Spread.MultiValuesFilterItem multifilter = new FarPoint.Win.Spread.MultiValuesFilterItem(new FarPoint.Win.Spread.FilterItemValue[] { test, test1 });
//Use the customized filter by implementing IFilterItem and setting the filterItem to the table column.
table.Filter(0, multifilter);

Visual Basic

Dim tstyle As FarPoint.Win.Spread.TableStyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2)
fpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
fpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
fpSpread1.Sheets(0).Cells(2, 1).Text = "2/17/2016"
fpSpread1.Sheets(0).Cells(2, 2).Value = "Press"
fpSpread1.Sheets(0).Cells(3, 1).Text = "12/31/1990"
fpSpread1.Sheets(0).Cells(3, 2).Value = "Press"
fpSpread1.Sheets(0).Cells(4, 1).Text = "2017"
fpSpread1.Sheets(0).Cells(4, 2).Value = "test"
fpSpread1.TableStyleCollection.Add(tstyle)
Dim table As FarPoint.Win.Spread.TableView = fpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1")

Dim test As New FarPoint.Win.Spread.FilterItemValue(System.DateTime.Today, FarPoint.Win.Spread.DateTimeGroupingType.Year)
Dim test1 As New FarPoint.Win.Spread.FilterItemValue(New System.DateTime(1990, 12, 31), FarPoint.Win.Spread.DateTimeGroupingType.Year)
Dim multifilter As New FarPoint.Win.Spread.MultiValuesFilterItem(New FarPoint.Win.Spread.FilterItemValue() {test, test1})
'Use the customized filter by implementing IFilterItem And setting the filterItem to the table column.
table.Filter(0, multifilter)

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.DateTimeGroupingType

Reference

FarPoint.Win.Spread Namespace

Product Support Forum | Print this page