Spread for ASP.NET 8.0 Product Documentation
TimePeriodConditionalFormattingRule Constructor(TimePeriod)
Example 


The period.
Initializes a new instance of the TimePeriodConditionalFormattingRule class.
Syntax
'Declaration
 
Public Function New( _
   ByVal period As TimePeriod _
)
'Usage
 
Dim period As TimePeriod
 
Dim instance As New TimePeriodConditionalFormattingRule(period)
public TimePeriodConditionalFormattingRule( 
   TimePeriod period
)

Parameters

period
The period.
Example
This example creates a time rule.
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

TimePeriodConditionalFormattingRule Class
TimePeriodConditionalFormattingRule Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.