Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Chart Namespace / SpreadChart Class / CategoryFormula Property
Example


In This Topic
    CategoryFormula Property
    In This Topic
    Gets or sets the category formula. This action will re-build the chart's series.
    Syntax
    'Declaration
     
    Public Overridable Property CategoryFormula As String
    'Usage
     
    Dim instance As SpreadChart
    Dim value As String
     
    instance.CategoryFormula = value
     
    value = instance.CategoryFormula
    public virtual string CategoryFormula {get; set;}

    Property Value

    The category formula.
    Remarks
    This property is not designed for persisting so you should save and re-use the value and access infrequently.
    Example
    This example uses the CategoryFormula property.
    FpSpread1.Sheets[0].RowCount = 10;
    FpSpread1.Sheets[0].ColumnCount = 10;
    FpSpread1.Sheets[0].Cells[0, 1].Value = "c1";
    FpSpread1.Sheets[0].Cells[0, 2].Value = "c2";
    FpSpread1.Sheets[0].Cells[0, 3].Value = "c3";
    FpSpread1.Sheets[0].Cells[1, 0].Value = "s1";
    FpSpread1.Sheets[0].Cells[2, 0].Value = "s2";
    FpSpread1.Sheets[0].Cells[3, 0].Value = "s3";
    FpSpread1.Sheets[0].Cells[4, 0].Value = "s4";
    FpSpread1.Sheets[0].Cells[5, 0].Value = "s5";
    FpSpread1.Sheets[0].Cells[6, 0].Value = "s6";
    
    FpSpread1.Sheets[0].Cells[1, 1].Value = 1;
    FpSpread1.Sheets[0].Cells[2, 1].Value = 2;
    FpSpread1.Sheets[0].Cells[3, 1].Value = 3;
    FpSpread1.Sheets[0].Cells[4, 1].Value = 4;
    FpSpread1.Sheets[0].Cells[5, 1].Value = 5;
    FpSpread1.Sheets[0].Cells[6, 1].Value = 6;
    
    FpSpread1.Sheets[0].Cells[1, 2].Value = 7;
    FpSpread1.Sheets[0].Cells[2, 2].Value = 8;
    FpSpread1.Sheets[0].Cells[3, 2].Value = 9;
    FpSpread1.Sheets[0].Cells[4, 2].Value = 10;
    FpSpread1.Sheets[0].Cells[5, 2].Value = 11;
    FpSpread1.Sheets[0].Cells[6, 2].Value = 12;
    
    FpSpread1.Sheets[0].Cells[1, 3].Value = 13;
    FpSpread1.Sheets[0].Cells[2, 3].Value = 14;
    FpSpread1.Sheets[0].Cells[3, 3].Value = 15;
    FpSpread1.Sheets[0].Cells[4, 3].Value = 16;
    FpSpread1.Sheets[0].Cells[5, 3].Value = 17;
    FpSpread1.Sheets[0].Cells[6, 3].Value = 18;
    
    FpSpread1.Sheets[0].AddChart(0, 0, typeof(FarPoint.Web.Chart.BarSeries), 300, 300, 0, 0, FarPoint.Web.Chart.ChartViewType.View2D, true);
    FarPoint.Web.Spread.Chart.SpreadChart chart = FpSpread1.Sheets[0].Charts[0];
    chart.CategoryFormula = "Sheet1!$A$2:$A$7";
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 10
    FpSpread1.Sheets(0).Cells(0, 1).Value = "c1"
    FpSpread1.Sheets(0).Cells(0, 2).Value = "c2"
    FpSpread1.Sheets(0).Cells(0, 3).Value = "c3"
    FpSpread1.Sheets(0).Cells(1, 0).Value = "s1"
    FpSpread1.Sheets(0).Cells(2, 0).Value = "s2"
    FpSpread1.Sheets(0).Cells(3, 0).Value = "s3"
    FpSpread1.Sheets(0).Cells(4, 0).Value = "s4"
    FpSpread1.Sheets(0).Cells(5, 0).Value = "s5"
    FpSpread1.Sheets(0).Cells(6, 0).Value = "s6"
    
    FpSpread1.Sheets(0).Cells(1, 1).Value = 1
    FpSpread1.Sheets(0).Cells(2, 1).Value = 2
    FpSpread1.Sheets(0).Cells(3, 1).Value = 3
    FpSpread1.Sheets(0).Cells(4, 1).Value = 4
    FpSpread1.Sheets(0).Cells(5, 1).Value = 5
    FpSpread1.Sheets(0).Cells(6, 1).Value = 6
    
    FpSpread1.Sheets(0).Cells(1, 2).Value = 7
    FpSpread1.Sheets(0).Cells(2, 2).Value = 8
    FpSpread1.Sheets(0).Cells(3, 2).Value = 9
    FpSpread1.Sheets(0).Cells(4, 2).Value = 10
    FpSpread1.Sheets(0).Cells(5, 2).Value = 11
    FpSpread1.Sheets(0).Cells(6, 2).Value = 12
    
    FpSpread1.Sheets(0).Cells(1, 3).Value = 13
    FpSpread1.Sheets(0).Cells(2, 3).Value = 14
    FpSpread1.Sheets(0).Cells(3, 3).Value = 15
    FpSpread1.Sheets(0).Cells(4, 3).Value = 16
    FpSpread1.Sheets(0).Cells(5, 3).Value = 17
    FpSpread1.Sheets(0).Cells(6, 3).Value = 18
    
    FpSpread1.Sheets(0).AddChart(0, 0, GetType(FarPoint.Web.Chart.BarSeries), 300, 300, 0, 0, FarPoint.Web.Chart.ChartViewType.View2D, True)
    Dim chart As FarPoint.Web.Spread.Chart.SpreadChart
    chart = FpSpread1.Sheets(0).Charts(0)
    chart.CategoryFormula = "Sheet1!$A$2:$A$7"
    See Also