Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Property DataFormula As String | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SpreadChart Dim value As String instance.DataFormula = value value = instance.DataFormula | |
| C# | |
|---|---|
public virtual string DataFormula {get; set;} | |
Property Value
The data 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 DataFormula property.
| C# | Copy Code |
|---|---|
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.DataFormula = "Sheet1!$B$2:$D$7"; | |
| Visual Basic | Copy Code |
|---|---|
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.DataFormula = "Sheet1!$B$2:$D$7" | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6