FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > ExcelSparkline クラス : Formula プロパティ |
'Declaration Public Property Formula As String
'使用法 Dim instance As ExcelSparkline Dim value As String instance.Formula = value value = instance.Formula
public string Formula {get; set;}
fpSpread1.Sheets[0].SetClip(0, 0, 1, 5, "1\t2\t3\t4\t5"); FarPoint.Win.Spread.ExcelSparkline es = new FarPoint.Win.Spread.ExcelSparkline(); es.Column = 5; es.Row = 0; es.Formula = "Sheet1!$A$1:$E$1"; FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column); esg.Add(es); fpSpread1.Sheets[0].SparklineContainer.Add(esg);
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.Win.Spread.ExcelSparkline() es.Column = 5 es.Row = 0 es.Formula = "Sheet1!$A$1:$E$1" Dim esg As New FarPoint.Win.Spread.ExcelSparklineGroup(New FarPoint.Win.Spread.ExcelSparklineSetting(), FarPoint.Win.Spread.SparklineType.Column) esg.Add(es) FpSpread1.Sheets(0).SparklineContainer.Add(esg)