New to Telerik UI for WinFormsStart a free 30-day trial

Represents a hierarchical date criterion for value-based filtering.

Definition

Namespace:Telerik.Documents.SpreadsheetStreaming

Assembly:Telerik.Documents.SpreadsheetStreaming.dll

Syntax:

C#
public class SpreadDateGroupItem

Inheritance: objectSpreadDateGroupItem

Constructors

Initializes a new instance of the SpreadDateGroupItem class with all components.

C#
public SpreadDateGroupItem(int year, int month, int day, int hour, int minute, int second, SpreadDateTimeGroupingType dateTimeGroupingType)
Parameters:yearint

The year (must be >= 1).

monthint

The month (1-12), or 0 when not used at the given granularity.

dayint

The day (1-31), or 0 when not used at the given granularity.

hourint

The hour (0-23), or 0 when not used at the given granularity.

minuteint

The minute (0-59), or 0 when not used at the given granularity.

secondint

The second (0-59), or 0 when not used at the given granularity.

dateTimeGroupingTypeSpreadDateTimeGroupingType

The date/time grouping granularity.

Exceptions:

ArgumentOutOfRangeException

Thrown when any component is outside its valid range for the specified granularity.

Initializes a new instance of the SpreadDateGroupItem class with day granularity.

C#
public SpreadDateGroupItem(int year, int month, int day)
Parameters:yearint

The year.

monthint

The month (1-12).

dayint

The day (1-31).

Initializes a new instance of the SpreadDateGroupItem class with month granularity.

C#
public SpreadDateGroupItem(int year, int month)
Parameters:yearint

The year.

monthint

The month (1-12).

Initializes a new instance of the SpreadDateGroupItem class with year granularity.

C#
public SpreadDateGroupItem(int year)
Parameters:yearint

The year to match.

Properties

Gets the date/time grouping granularity.

C#
public SpreadDateTimeGroupingType DateTimeGroupingType { get; }

Gets the day (1-31), or 0 if not used.

C#
public int Day { get; }

Gets the hour (0-23), or 0 if not used.

C#
public int Hour { get; }

Gets the minute (0-59), or 0 if not used.

C#
public int Minute { get; }

Gets the month (1-12), or 0 if not used.

C#
public int Month { get; }

Gets the second (0-59), or 0 if not used.

C#
public int Second { get; }

Gets the year.

C#
public int Year { get; }