■ 셀에 스파클라인을 추가하는 방법을 보여준다.
▶ 예제 코드 (C#)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
FarPoint.Win.Spread.SheetView sheetView = new FarPoint.Win.Spread.SheetView(); FarPoint.Win.Spread.Chart.SheetCellRange dataSheetCellRange = new FarPoint.Win.Spread.Chart.SheetCellRange(sheetView, 0, 0, 1, 5); FarPoint.Win.Spread.Chart.SheetCellRange locationSheetCellRange = new FarPoint.Win.Spread.Chart.SheetCellRange(sheetView, 5, 0, 1, 1); FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting = new FarPoint.Win.Spread.ExcelSparklineSetting(); excelSparklineSetting.ShowMarkers = true; excelSparklineSetting.ShowNegative = true; excelSparklineSetting.NegativeColor = Color.Red; excelSparklineSetting.SeriesColor = Color.Olive; fpSpread1.Sheets[0] = sheetView; sheetView.Cells[0, 0].Value = 2; sheetView.Cells[0, 1].Value = 5; sheetView.Cells[0, 2].Value = 4; sheetView.Cells[0, 3].Value = -1; sheetView.Cells[0, 4].Value = 3; fpSpread1.Sheets[0].AddSparkline(dataSheetCellRange, locationSheetCellRange, FarPoint.Win.Spread.SparklineType.Column, excelSparklineSetting); |