XlDynamicFilter.MaxValue Property

Gets or sets a maximum value for the dynamic filter.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

public XlVariantValue MaxValue { get; set; }

VB.NET

Public Property MaxValue As XlVariantValue

Property Value

Type	Description
XlVariantValue	An XlVariantValue object.

Remarks

The MaxValue value is used by the following types of dynamic filter:

• XlDynamicFilterType.Today, XlDynamicFilterType.Yesterday, XlDynamicFilterType.Tomorrow;
• XlDynamicFilterType.NextWeek, XlDynamicFilterType.ThisWeek, XlDynamicFilterType.LastWeek;
• XlDynamicFilterType.NextMonth, XlDynamicFilterType.ThisMonth, XlDynamicFilterType.LastMonth;
• XlDynamicFilterType.NextQuarter, XlDynamicFilterType.ThisQuarter, XlDynamicFilterType.LastQuarter;
• XlDynamicFilterType.NextYear, XlDynamicFilterType.ThisYear, XlDynamicFilterType.LastYear, and XlDynamicFilterType.YearToDate.

These criteria are based on a value range. The lower value is defined by the XlDynamicFilter.Value property, and the higher value is expressed using MaxValue.

Note that you don’t need to specify these values manually in your code as they are set automatically to the appropriate values based on the current date and time.