Spread for ASP.NET 8.0 Product Documentation
CloneSetting Method (ExcelSparklineGroup)
Example 


Clones a new sparkline group that copies the setting of the current sparkline group.
Syntax
'Declaration
 
Public Function CloneSetting() As ISparklineGroup
'Usage
 
Dim instance As ExcelSparklineGroup
Dim value As ISparklineGroup
 
value = instance.CloneSetting()
public ISparklineGroup CloneSetting()
Example
This example creates sparklines.
FarPoint.Web.Spread.ExcelSparklineSetting eSetting = new FarPoint.Web.Spread.ExcelSparklineSetting();
eSetting.ShowMarkers = true;
eSetting.AxisColor = Color.Cyan;
eSetting.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Gaps;
eSetting.DisplayHidden = true;
eSetting.DisplayXAxis = true;
eSetting.FirstMarkerColor = Color.AliceBlue;
eSetting.Formula = "Sheet1!$A$4:$E$4";
eSetting.HighMarkerColor = Color.Honeydew;
eSetting.LastMarkerColor = Color.Lavender;
eSetting.LineWeight = 2;
eSetting.LowMarkerColor = Color.LawnGreen;
eSetting.ManualMax = 3;
eSetting.ManualMin = 1;
eSetting.MarkersColor = Color.Magenta;
eSetting.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Custom;
eSetting.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Individual;
eSetting.NegativeColor = Color.NavajoWhite;
eSetting.RightToLeft = true;
eSetting.SeriesColor = Color.SeaGreen;
eSetting.ShowFirst = true;
eSetting.ShowHigh = true;
eSetting.ShowLast = true;
eSetting.ShowLow = true;
eSetting.ShowNegative = true;

FarPoint.Web.Spread.ExcelSparklineGroup esg = new FarPoint.Web.Spread.ExcelSparklineGroup(eSetting, FarPoint.Web.Spread.SparklineType.Line);

FarPoint.Web.Spread.ExcelSparklineGroup esg1;
esg1 = (FarPoint.Web.Spread.ExcelSparklineGroup)esg.CloneSetting();

FarPoint.Web.Spread.ExcelSparklineSetting ess = (FarPoint.Web.Spread.ExcelSparklineSetting)esg.Setting;
FarPoint.Web.Spread.ExcelSparklineSetting ess1 = (FarPoint.Web.Spread.ExcelSparklineSetting)esg1.Setting;
Dim eSetting As New FarPoint.Web.Spread.ExcelSparklineSetting()
eSetting.ShowMarkers = True
eSetting.AxisColor = Color.Cyan
eSetting.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Gaps
eSetting.DisplayHidden = True
eSetting.DisplayXAxis = True
eSetting.FirstMarkerColor = Color.AliceBlue
eSetting.Formula = "Sheet1!$A$4:$E$4"
eSetting.HighMarkerColor = Color.Honeydew
eSetting.LastMarkerColor = Color.Lavender
eSetting.LineWeight = 2
eSetting.LowMarkerColor = Color.LawnGreen
eSetting.ManualMax = 3
eSetting.ManualMin = 1
eSetting.MarkersColor = Color.Magenta
eSetting.MaxAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.[Custom]
eSetting.MinAxisType = FarPoint.Web.Spread.SparklineAxisMinMax.Individual
eSetting.NegativeColor = Color.NavajoWhite
eSetting.RightToLeft = True
eSetting.SeriesColor = Color.SeaGreen
eSetting.ShowFirst = True
eSetting.ShowHigh = True
eSetting.ShowLast = True
eSetting.ShowLow = True
eSetting.ShowNegative = True

Dim esg As New FarPoint.Web.Spread.ExcelSparklineGroup(eSetting, FarPoint.Web.Spread.SparklineType.Line)

Dim esg1 As FarPoint.Web.Spread.ExcelSparklineGroup
esg1 = DirectCast(esg.CloneSetting(), FarPoint.Web.Spread.ExcelSparklineGroup)

Dim ess As FarPoint.Web.Spread.ExcelSparklineSetting = DirectCast(esg.Setting, FarPoint.Web.Spread.ExcelSparklineSetting)
Dim ess1 As FarPoint.Web.Spread.ExcelSparklineSetting = DirectCast(esg1.Setting, FarPoint.Web.Spread.ExcelSparklineSetting)
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members

 

 


Copyright © GrapeCity, inc. All rights reserved.