■ 스파클라인 마커와 포인트를 설정하는 방법을 보여준다.
▶ 예제 코드 (C#)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
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.AxisColor = Color.SaddleBrown; excelSparklineSetting.ShowFirst = true; excelSparklineSetting.ShowHigh = true; excelSparklineSetting.ShowLow = true; excelSparklineSetting.ShowLast = true; excelSparklineSetting.FirstMarkerColor = Color.Blue; excelSparklineSetting.HighMarkerColor = Color.DarkGreen; excelSparklineSetting.MarkersColor = Color.Aquamarine; excelSparklineSetting.LowMarkerColor = Color.Red; excelSparklineSetting.LastMarkerColor = Color.Orange; excelSparklineSetting.ShowMarkers = true; 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.Line, excelSparklineSetting); |