A format condition used to apply formatting to date-time values concerning a specific date and/or date interval relative to today.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v19.2.Core.dll
public class FormatConditionDateOccurring :
FormatConditionStyleBasePublic Class FormatConditionDateOccurring
Inherits FormatConditionStyleBaseTo create a format condition to apply formatting to the required date-time values, do the following.
Assign the resulting FormatConditionDateOccurring object to the DashboardItemFormatRule.Condition property.
The Date Occurring format condition (FormatConditionDateOccurring) allows you to apply formatting to date-time values of a specific date and/or date interval relative to today.
This example demonstrates how to apply conditional formatting to Grid cells whose values fall into one of the predefined intervals.
The complete sample project How to Apply Date Occurring Conditional Formatting to Grid Cells is available in the DevExpress Examples repository.
using DevExpress.DashboardCommon;
using DevExpress.XtraEditors;
namespace Grid_DateOccurring {
public partial class Form1 : DevExpress.XtraEditors.XtraForm {
public Form1() {
InitializeComponent();
dashboardViewer1.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.LoadAsIs;
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
dashboardViewer1.Dashboard = dashboard;
GridDashboardItem grid = (GridDashboardItem)dashboard.Items["gridDashboardItem1"];
GridDimensionColumn date = (GridDimensionColumn)grid.Columns[0];
GridItemFormatRule dateOccurringRule = new GridItemFormatRule(date);
FormatConditionDateOccurring dateOccurringCondition = new FormatConditionDateOccurring();
dateOccurringCondition.DateType = FilterDateType.MonthAgo1 | FilterDateType.MonthAgo2;
dateOccurringCondition.StyleSettings =
new AppearanceSettings(FormatConditionAppearanceType.PaleOrange);
dateOccurringRule.Condition = dateOccurringCondition;
dateOccurringRule.ApplyToRow = true;
grid.FormatRules.Add(dateOccurringRule);
}
}
}
Imports DevExpress.DashboardCommon
Imports DevExpress.XtraEditors
Namespace Grid_DateOccurring
Partial Public Class Form1
Inherits DevExpress.XtraEditors.XtraForm
Public Sub New()
InitializeComponent()
dashboardViewer1.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.LoadAsIs
Dim dashboard As New Dashboard()
dashboard.LoadFromXml("..\..\Data\Dashboard.xml")
dashboardViewer1.Dashboard = dashboard
Dim grid As GridDashboardItem = CType(dashboard.Items("gridDashboardItem1"), GridDashboardItem)
Dim [date] As GridDimensionColumn = CType(grid.Columns(0), GridDimensionColumn)
Dim dateOccurringRule As New GridItemFormatRule([date])
Dim dateOccurringCondition As New FormatConditionDateOccurring()
dateOccurringCondition.DateType = FilterDateType.MonthAgo1 Or FilterDateType.MonthAgo2
dateOccurringCondition.StyleSettings = New AppearanceSettings(FormatConditionAppearanceType.PaleOrange)
dateOccurringRule.Condition = dateOccuringCondition
dateOccurringRule.ApplyToRow = True
grid.FormatRules.Add(dateOccurringRule)
End Sub
End Class
End Namespace