Spread for ASP.NET 11 Product Documentation
TimePeriod Enumeration
Example Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : TimePeriod Enumeration
Represents a time period which is used in a date conditional formatting rule. These are dynamic time periods, which change based on the date when the conditional formatting rule is refreshed or applied.
Syntax
'Declaration
 
Public Enum TimePeriod 
   Inherits System.Enum
'Usage
 
Dim instance As TimePeriod
public enum TimePeriod : System.Enum 
Members
MemberDescription
Last7DaysIndicates a date in the last seven days.
LastMonthIndicates a date that occurred in the last calendar month.
LastWeekIndicates a date that occurred last week.
NextMonthIndicates a date that occurs in the next calendar month.
NextWeekIndicates a date that occurs next week.
ThisMonthIndicates a date that occurs in this calendar month.
ThisWeekIndicates a date that occurs this week.
TodayIndicates today's date.
TomorrowIndicates tomorrow's date.
YesterdayIndicates yesterday's date.
Example
This example sets the TimePeriod enumeration.
protected void Page_Load(object sender, System.EventArgs e)
                       {
                           FpSpread1.Sheets[0].Cells[1, 1].Value = DateTime.Now;
                       }

protected void Button1_Click(object sender, EventArgs e)
        {
            //Date Occurs CF
            FarPoint.Web.Spread.TimePeriodConditionalFormattingRule time = new FarPoint.Web.Spread.TimePeriodConditionalFormattingRule(FarPoint.Web.Spread.TimePeriod.Last7Days);
            time.TimePeriod = FarPoint.Web.Spread.TimePeriod.Last7Days;
            time.ForeColor = Color.Magenta;
            FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, time);
        }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(1, 1).Value = Date.Now
        End Sub

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
            'Date Occurs CF
            Dim time As New FarPoint.Web.Spread.TimePeriodConditionalFormattingRule(FarPoint.Web.Spread.TimePeriod.Last7Days)
            time.TimePeriod = FarPoint.Web.Spread.TimePeriod.Last7Days
            time.ForeColor = Drawing.Color.DarkMagenta
            FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, time)
        End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.TimePeriod

See Also

Reference

FarPoint.Web.Spread Namespace