Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ExcelSparkline Class / Formula Property
Example


In This Topic
    Formula Property (ExcelSparkline)
    In This Topic
    Gets or sets the formula.
    Syntax
    'Declaration
     
    Public Property Formula As String
    'Usage
     
    Dim instance As ExcelSparkline
    Dim value As String
     
    instance.Formula = value
     
    value = instance.Formula
    public string Formula {get; set;}

    Property Value

    The formula.
    Example
    This example creates sparklines.
    fpSpread1.Sheets[0].RowCount = 10;
    fpSpread1.Sheets[0].ColumnCount = 10;
    fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5");
    FarPoint.Web.Spread.ExcelSparkline es = new FarPoint.Web.Spread.ExcelSparkline();
    es.Column = 5;
    es.Row = 0;
    es.Formula = "Sheet1!$A$1:$E$1";
    FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup(new FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column);
    esg.Add(es);
    fpSpread1.Sheets[0].SparklineContainer.Add(esg);
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    FpSpread1.Sheets(0).SetClip(0, 0, 1, 5, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "4" + Chr(9) + "5")
    Dim es As New FarPoint.Web.Spread.ExcelSparkline()
    es.Column = 5
    es.Row = 0
    es.Formula = "Sheet1!$A$1:$E$1"
    Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(New FarPoint.Web.Spread.ExcelSparklineSetting(), FarPoint.Web.Spread.SparklineType.Column)
    esg.Add(es)
    FpSpread1.Sheets(0).SparklineContainer.Add(esg)
    See Also