CloneSetting Method (ExcelSparklineGroup)

Clones a new sparkline group that copies the setting of the current sparkline group.

Syntax

Visual Basic
C#

'Declaration
 
Public Function CloneSetting() As ISparklineGroup

'Usage
 
Dim instance As ExcelSparklineGroup
Dim value As ISparklineGroup
 
value = instance.CloneSetting()

public ISparklineGroup CloneSetting()

Example

This example clones the settings.

FarPoint.Win.Spread.ExcelSparklineSetting eSetting = new FarPoint.Win.Spread.ExcelSparklineSetting();
eSetting.ShowMarkers = true;
eSetting.AxisColor = Color.Cyan;
eSetting.DateAxis = true;
eSetting.DisplayEmptyCellsAs = FarPoint.Win.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.Win.Spread.SparklineAxisMinMax.Custom;
eSetting.MinAxisType = FarPoint.Win.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.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(eSetting, FarPoint.Win.Spread.SparklineType.Line);

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

FarPoint.Win.Spread.ExcelSparklineSetting ess = (FarPoint.Win.Spread.ExcelSparklineSetting)esg.Setting;
FarPoint.Win.Spread.ExcelSparklineSetting ess1 = (FarPoint.Win.Spread.ExcelSparklineSetting)esg1.Setting;

Visual Basic

Dim eSetting As New FarPoint.Win.Spread.ExcelSparklineSetting()
eSetting.ShowMarkers = True
eSetting.AxisColor = Color.Cyan
eSetting.DateAxis = True
eSetting.DisplayEmptyCellsAs = FarPoint.Win.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.Win.Spread.SparklineAxisMinMax.[Custom]
eSetting.MinAxisType = FarPoint.Win.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.Win.Spread.ExcelSparklineGroup(eSetting, FarPoint.Win.Spread.SparklineType.Line)

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

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

ExcelSparklineGroup Class
ExcelSparklineGroup Members