첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
유용한 소스 코드가 있으면 icodebroker@naver.com으로 보내주시면 감사합니다.
블로그 자료는 자유롭게 사용하세요.

728x90
반응형

■ 스파클라인 마커와 포인트 설정하기

------------------------------------------------------------------------------------------------------------------------

 

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);

------------------------------------------------------------------------------------------------------------------------

728x90
반응형
Posted by 사용자 icodebroker

댓글을 달아 주세요