'Declaration Public Overridable Property DataFormula As String
'Usage Dim instance As SpreadChart Dim value As String instance.DataFormula = value value = instance.DataFormula
public virtual string DataFormula {get; set;}
'Declaration Public Overridable Property DataFormula As String
'Usage Dim instance As SpreadChart Dim value As String instance.DataFormula = value value = instance.DataFormula
public virtual string DataFormula {get; set;}
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; FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$B$2:$D$7", typeof(FarPoint.Win.Chart.BarSeries)); chart.DataFormula = "Sheet1!$B$2:$D$7"; chart.Location = new Point(100, 100); chart.Size = new Size(200, 200); fpSpread1.Sheets[0].Charts.Add(chart);
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 Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart("Sheet1!$B$2:$D$7", GetType(FarPoint.Win.Chart.BarSeries)) chart.DataFormula = "Sheet1!$B$2:$D$7" chart.Location = New Point(100, 100) chart.Size = New Size(200, 200) fpSpread1.Sheets(0).Charts.Add(chart)