[C#/WINFORM/SPREAD] 스파클라인 수평/수직 축 설정하기

■ 스파클라인 수평/수직 축을 설정하는 방법을 보여준다.

▶ 예제 코드 (C#)


FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting = new FarPoint.Win.Spread.ExcelSparklineSetting();

excelSparklineSetting.DisplayXAxis = true;
excelSparklineSetting.DateAxis     = true;
excelSparklineSetting.Formula      = "Sheet1!$A$1:$C$1";

fpSpread1.Sheets[0].Cells[0, 0].Text = "1/2/2011";
fpSpread1.Sheets[0].Cells[0, 1].Text = "1/3/2011";
fpSpread1.Sheets[0].Cells[0, 2].Text = "1/5/2011";

fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 11;
fpSpread1.Sheets[0].Cells[1, 2].Value = 4;

fpSpread1.Sheets[0].AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Win.Spread.SparklineType.Column, excelSparklineSetting);

FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting = new FarPoint.Win.Spread.ExcelSparklineSetting();

excelSparklineSetting.DisplayXAxis = true;

excelSparklineSetting.DateAxis = true;

excelSparklineSetting.Formula = "Sheet1!$A$1:$C$1";

fpSpread1.Sheets[0].Cells[0, 0].Text = "1/2/2011";

fpSpread1.Sheets[0].Cells[0, 1].Text = "1/3/2011";

fpSpread1.Sheets[0].Cells[0, 2].Text = "1/5/2011";

fpSpread1.Sheets[0].Cells[1, 0].Value = 2;

fpSpread1.Sheets[0].Cells[1, 1].Value = 11;

fpSpread1.Sheets[0].Cells[1, 2].Value = 4;

fpSpread1.Sheets[0].AddSparkline("Sheet1!$A$2:$C$2", "Sheet1!$D$2:$D$2", FarPoint.Win.Spread.SparklineType.Column, excelSparklineSetting);

※ 실제 테스트 실행 결과를 확인할 수 없었다.