Spread Windows Forms 9.0 Product Documentation
TimePeriod Enumeration
Example Example 


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 creates a conditional rule.
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[1, 1].Value = DateTime.Now;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //Date Occurs CF
            FarPoint.Win.Spread.TimePeriodConditionalFormattingRule time = new FarPoint.Win.Spread.TimePeriodConditionalFormattingRule(FarPoint.Win.Spread.TimePeriod.Last7Days);
            time.TimePeriod = FarPoint.Win.Spread.TimePeriod.Last7Days;
            time.ForeColor = Color.Magenta;
            fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, time);
        }
Private Sub Form1_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

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

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.