ClassSpreadDateGroupItem
Represents a hierarchical date criterion for value-based filtering.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public class SpreadDateGroupItemInheritance: objectSpreadDateGroupItem
Constructors
SpreadDateGroupItem(int)
Initializes a new instance of the SpreadDateGroupItem class with year granularity.
Declaration
public SpreadDateGroupItem(int year)Parameters
year
The year to match.
SpreadDateGroupItem(int, int)
Initializes a new instance of the SpreadDateGroupItem class with month granularity.
SpreadDateGroupItem(int, int, int)
Initializes a new instance of the SpreadDateGroupItem class with day granularity.
SpreadDateGroupItem(int, int, int, int, int, int, SpreadDateTimeGroupingType)
Initializes a new instance of the SpreadDateGroupItem class with all components.
Declaration
public SpreadDateGroupItem(int year, int month, int day, int hour, int minute, int second, SpreadDateTimeGroupingType dateTimeGroupingType)Parameters
year
The year (must be >= 1).
month
The month (1-12), or 0 when not used at the given granularity.
day
The day (1-31), or 0 when not used at the given granularity.
hour
The hour (0-23), or 0 when not used at the given granularity.
minute
The minute (0-59), or 0 when not used at the given granularity.
second
The second (0-59), or 0 when not used at the given granularity.
dateTimeGroupingType
The date/time grouping granularity.
Exceptions
Thrown when any component is outside its valid range for the specified granularity.
Properties
DateTimeGroupingType
Gets the date/time grouping granularity.
Declaration
public SpreadDateTimeGroupingType DateTimeGroupingType { get; }Property Value
Day
Gets the day (1-31), or 0 if not used.
Hour
Gets the hour (0-23), or 0 if not used.
Minute
Gets the minute (0-59), or 0 if not used.
Month
Gets the month (1-12), or 0 if not used.
Second
Gets the second (0-59), or 0 if not used.