XlValuesFilter.CalendarType Property
Gets or sets the calendar type for date groups used in filtering.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v18.2.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| XlCalendarType | An XlCalendarType enumeration member. |
Available values:
| Name | Description |
|---|---|
| None | The calendar type is not specified. |
| Gregorian | Specifies the localized version of the Gregorian calendar. |
| GregorianArabic | Specifies the Arabic version of the Gregorian calendar. |
| GregorianMiddleEastFrench | Specifies the Middle East French version of the Gregorian calendar. |
| GregorianUS | Specifies the U.S. English version of the Gregorian calendar. |
| GregorianTransliteratedEnglish | Specifies the transliterated English version of the Gregorian calendar. |
| GregorianTransliteratedFrench | Specifies the transliterated French version of the Gregorian calendar. |
| HebrewLunar | Specifies the Hebrew (Lunar) calendar. |
| ArabicLunar | Specifies the Hijri (Arabic Lunar) calendar. |
| JapaneseEmperorEra | Specifies the Japanese Emperor Era calendar. |
| KoreanTangunEra | Specifies the Korean Tangun Era calendar. |
| TaiwanEra | Specifies the Taiwan Era calendar. |
| Thai | Specifies the Thai calendar. |
Remarks
The CalendarType property is used to interpret filter values defined by the XlDateGroupItem instances. All dates in the filtered column are evaluated according to the specified calendar type, even when these dates are not using the same calendar system or date formatting.