Spread for ASP.NET 9.0 Product Documentation
StandardDeviation Property (AverageConditionalFormattingRule)
Example 


Gets or sets the standard deviation.
Syntax
'Declaration
 
Public Property StandardDeviation As Integer
'Usage
 
Dim instance As AverageConditionalFormattingRule
Dim value As Integer
 
instance.StandardDeviation = value
 
value = instance.StandardDeviation
public int StandardDeviation {get; set;}

Property Value

The standard deviation.
Example
This example sets the StandardDeviation property.
protected void Page_Load(object sender, System.EventArgs e)
                       {
                           FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
                           FpSpread1.Sheets[0].Cells[1, 0].Value = 2;
                           FpSpread1.Sheets[0].Cells[1, 1].Value = 10;
                           FpSpread1.Sheets[0].Cells[0, 2].Value = 1;    
                       }

protected void Button1_Click(object sender, EventArgs e)
        {
            //Average CF
            FarPoint.Web.Spread.AverageConditionalFormattingRule average = new FarPoint.Web.Spread.AverageConditionalFormattingRule(true, true);
            average.IsAbove = true;
            average.IsIncludeEquals = true;
            average.StandardDeviation = 5;
            average.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
            average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;
            FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average);
        }
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(0, 0).Value = 3
            FpSpread1.Sheets(0).Cells(1, 0).Value = 2
            FpSpread1.Sheets(0).Cells(1, 1).Value = 10
            FpSpread1.Sheets(0).Cells(0, 2).Value = 1
        End Sub

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
            'Average CF
            Dim average As New FarPoint.Web.Spread.AverageConditionalFormattingRule(True, True)
            average.IsAbove = True
            average.IsIncludeEquals = True
            average.StandardDeviation = 5
            average.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
            average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold
            FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average)
        End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

AverageConditionalFormattingRule Class
AverageConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.