Formula Property (SpreadChart)

Gets or sets the formula of chart. This action will re-build the chart's series.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property Formula As String

'Usage
 
Dim instance As SpreadChart
Dim value As String
 
instance.Formula = value
 
value = instance.Formula

public virtual string Formula {get; set;}

Property Value

The formula.

Remarks

This property is not designed for persisting so you should save and re-use the value and access infrequently.

Example

This example sets the Formula property.

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.Win.Chart.BarSeries),400,400,0,0,FarPoint.Win.Chart.ChartViewType.View2D, true);
FarPoint.Win.Spread.Chart.SpreadChart chart = fpSpread1.Sheets[0].Charts[0];
chart.Formula = " Sheet1!$A$1:$D$7";

Visual Basic

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.Win.Chart.BarSeries), 400, 400, 0, 0, FarPoint.Win.Chart.ChartViewType.View2D, True)
Dim chart As FarPoint.Win.Spread.Chart.SpreadChart
chart = fpSpread1.Sheets(0).Charts(0)
chart.Formula = " Sheet1!$A$1:$D$7"

Reference

SpreadChart Class
SpreadChart Members