FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > TimePeriodConditionalFormattingRule クラス > TimePeriodConditionalFormattingRule コンストラクタ : TimePeriodConditionalFormattingRule コンストラクタ(TimePeriod) |
'Declaration Public Function New( _ ByVal period As TimePeriod _ )
'使用法 Dim period As TimePeriod Dim instance As New TimePeriodConditionalFormattingRule(period)
public TimePeriodConditionalFormattingRule( TimePeriod period )
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