Class ChartSerieDataFormatImpl

ChartSerieDataFormatImpl class.

Inheritance
System.Object
CommonObject
ChartSerieDataFormatImpl
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.XlsIO.Implementation.Charts
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class ChartSerieDataFormatImpl : CommonObject, IParentApplication, IDisposable, IChartSerieDataFormat, IChartFillBorder, IFillColor

Constructors

ChartSerieDataFormatImpl(IApplication, Object)

Creates series and set its Application and Parent properties to specified values.

Declaration
public ChartSerieDataFormatImpl(IApplication application, object parent)
Parameters
Type Name Description
IApplication application

Application object for the chart.
System.Object parent

Parent object for the chart.

Fields

DEF_LINE_START_TYPE

Represents start line type.

Declaration
public const string DEF_LINE_START_TYPE = "Line"
Field Value
Type Description
System.String

DEF_MARKER_START_COLOR

Represents start color.

Declaration
public const int DEF_MARKER_START_COLOR = 24
Field Value
Type Description
System.Int32

DEF_SCATTER_START_TYPE

Represents start scatter type.

Declaration
public const string DEF_SCATTER_START_TYPE = "Scatter"
Field Value
Type Description
System.String

DEF_SUPPORT_DATAFORMAT_PROPERTIES

Represents types of chart that support data format properties.

Declaration
public static ExcelChartType[] DEF_SUPPORT_DATAFORMAT_PROPERTIES
Field Value
Type Description
ExcelChartType[]

Properties

AreaProperties

Returns object, that represents area properties. Read-only.

Declaration
public IChartInterior AreaProperties { get; }
Property Value
Type Description
IChartInterior

AttachedLabel

Returns attached label record. Read-only.

Declaration
[CLSCompliant(false)]
public ChartAttachedLabelRecord AttachedLabel { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartAttachedLabelRecord

AttachedLabelLayout

Return attached label layout record. Read-only

Declaration
[CLSCompliant(false)]
public ChartAttachedLabelLayoutRecord AttachedLabelLayout { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartAttachedLabelLayoutRecord

BackGroundColorObject

Represents background color.

Declaration
public ColorObject BackGroundColorObject { get; }
Property Value
Type Description
ColorObject

BarShapeBase

Represents the base data format.

Declaration
public ExcelBaseFormat BarShapeBase { get; set; }
Property Value
Type Description
ExcelBaseFormat

BarShapeTop

Represents the top data format.

Declaration
public ExcelTopFormat BarShapeTop { get; set; }
Property Value
Type Description
ExcelTopFormat

CommonSerieOptions

Gets common Series options. Read-only.

Declaration
public IChartFormat CommonSerieOptions { get; }
Property Value
Type Description
IChartFormat

ContainsLineProperties

If line not null - returns true; otherwise - false. Read-only.

Declaration
public bool ContainsLineProperties { get; }
Property Value
Type Description
System.Boolean

DataFormat

Returns data format main record.

Declaration
[CLSCompliant(false)]
public ChartDataFormatRecord DataFormat { get; set; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartDataFormatRecord

Fill

Represents fill options. Read-only.

Declaration
public IFill Fill { get; }
Property Value
Type Description
IFill

ForeGroundColorObject

Represents foreground color.

Declaration
public ColorObject ForeGroundColorObject { get; }
Property Value
Type Description
ColorObject

Has3dProperties

This property Indicates whether the Shadow object has been created(which includes the 3D properties)

Declaration
public bool Has3dProperties { get; }
Property Value
Type Description
System.Boolean

HasInterior

Gets/sets value indicating whether interior object was created.

Declaration
public bool HasInterior { get; }
Property Value
Type Description
System.Boolean

HasLineProperties

Gets/sets value indicating whether line properties are created.

Declaration
public bool HasLineProperties { get; }
Property Value
Type Description
System.Boolean

HasShadowProperties

Gets a value indicating whether this instance has shadow properties.

Declaration
public bool HasShadowProperties { get; }
Property Value
Type Description
System.Boolean

true if this instance has shadow properties; otherwise, false.

Interior

Returns object, that represents area properties. Read-only.

Declaration
public IChartInterior Interior { get; }
Property Value
Type Description
IChartInterior

Is3DBubbles

True to draw bubbles with 3D effects.

Declaration
public bool Is3DBubbles { get; set; }
Property Value
Type Description
System.Boolean

IsArShadow

True if this series has a shadow.

Declaration
public bool IsArShadow { get; set; }
Property Value
Type Description
System.Boolean

IsAutoMarker

Automatic color.

Declaration
public bool IsAutoMarker { get; set; }
Property Value
Type Description
System.Boolean

IsAutomaticFormat

Indicates, if automatic format is used for area.

Declaration
public bool IsAutomaticFormat { get; set; }
Property Value
Type Description
System.Boolean

IsBorderSupported

Indicates whether border object is supported. Read-only.

Declaration
public bool IsBorderSupported { get; }
Property Value
Type Description
System.Boolean

IsFormatted

Indicate if data format is formatted.

Declaration
public bool IsFormatted { get; }
Property Value
Type Description
System.Boolean

IsInteriorSupported

Indicates whether interior object is supported. Read-only.

Declaration
public bool IsInteriorSupported { get; }
Property Value
Type Description
System.Boolean

IsLine

If true - format has line; otherwise false. Read-only.

Declaration
public bool IsLine { get; }
Property Value
Type Description
System.Boolean

IsMarker

If true - format has marker; otherwise false. Read-only.

Declaration
public bool IsMarker { get; }
Property Value
Type Description
System.Boolean

IsMarkerSupported

Indicates whether marker is supported by this chart/series.

Declaration
public bool IsMarkerSupported { get; }
Property Value
Type Description
System.Boolean

IsNotShowBrd

True = "foreground = none".

Declaration
public bool IsNotShowBrd { get; set; }
Property Value
Type Description
System.Boolean

IsNotShowInt

True = "background = none".

Declaration
public bool IsNotShowInt { get; set; }
Property Value
Type Description
System.Boolean

IsSmoothed

If true - format has smoothed line; otherwise false. Read-only.

Declaration
public bool IsSmoothed { get; }
Property Value
Type Description
System.Boolean

IsSmoothedLine

True if the line series has a smoothed line.

Declaration
public bool IsSmoothedLine { get; set; }
Property Value
Type Description
System.Boolean

IsSupportFill

Gets value indicating whether chart supports transparency.

Declaration
public bool IsSupportFill { get; }
Property Value
Type Description
System.Boolean

LineProperties

Returns object, that represents line properties. Read-only.

Declaration
public IChartBorder LineProperties { get; }
Property Value
Type Description
IChartBorder

MarkerBackColorObject

Gets object that holds marker background color.

Declaration
public ColorObject MarkerBackColorObject { get; }
Property Value
Type Description
ColorObject

MarkerBackgroundColor

Foreground color: RGB value (high byte = 0).

Declaration
public Color MarkerBackgroundColor { get; set; }
Property Value
Type Description
System.Drawing.Color

MarkerBackgroundColorIndex

Index to color of marker fill.

Declaration
public ExcelKnownColors MarkerBackgroundColorIndex { get; set; }
Property Value
Type Description
ExcelKnownColors

MarkerForeColorObject

Gets object that holds marker foreground color.

Declaration
public ColorObject MarkerForeColorObject { get; }
Property Value
Type Description
ColorObject

MarkerForegroundColor

Background color: RGB value (high byte = 0).

Declaration
public Color MarkerForegroundColor { get; set; }
Property Value
Type Description
System.Drawing.Color

MarkerForegroundColorIndex

Index to color of marker border.

Declaration
public ExcelKnownColors MarkerForegroundColorIndex { get; set; }
Property Value
Type Description
ExcelKnownColors

MarkerFormat

Returns marker format main record. Read-only.

Declaration
[CLSCompliant(false)]
public ChartMarkerFormatRecord MarkerFormat { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartMarkerFormatRecord

MarkerFormatOrNull

If marker is not null returns marker format main record otherwise null. Read-only.

Declaration
[CLSCompliant(false)]
public ChartMarkerFormatRecord MarkerFormatOrNull { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartMarkerFormatRecord

MarkerLineStream

Gets or sets the marker line stream.

Declaration
public Stream MarkerLineStream { get; set; }
Property Value
Type Description
System.IO.Stream

MarkerSize

Size of markers.

Declaration
public int MarkerSize { get; set; }
Property Value
Type Description
System.Int32

MarkerStyle

Type of marker.

Declaration
public ExcelChartMarkerType MarkerStyle { get; set; }
Property Value
Type Description
ExcelChartMarkerType

MarkerTransparency

Gets or sets the transparency of the line marker.

Declaration
public double MarkerTransparency { get; set; }
Property Value
Type Description
System.Double

The transparency.

ParentChart

Represents parent chart. Read-only.

Declaration
public ChartImpl ParentChart { get; }
Property Value
Type Description
ChartImpl

ParentSerie

Returns parent Series. Read-only.

Declaration
public ChartSerieImpl ParentSerie { get; }
Property Value
Type Description
ChartSerieImpl

Pattern

Represents pattern.

Declaration
public ExcelPattern Pattern { get; set; }
Property Value
Type Description
ExcelPattern

Percent

Distance of pie slice from center of pie.

Declaration
public int Percent { get; set; }
Property Value
Type Description
System.Int32

PieFormat

Returns pie format record. Read-only.

Declaration
[CLSCompliant(false)]
public ChartPieFormatRecord PieFormat { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartPieFormatRecord

PieFormatOrNull

Returns pie format or null. Read-only.

Declaration
[CLSCompliant(false)]
public ChartPieFormatRecord PieFormatOrNull { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartPieFormatRecord

QuartileCalculationType

Gets / Sets whether the Quartile calculation is Exclusive or Inclusive

Declaration
public ExcelQuartileCalculation QuartileCalculationType { get; set; }
Property Value
Type Description
ExcelQuartileCalculation
Remarks

Applies only to Box and Whisker Charts

Serie3DDataFormat

Returns 3dData format main record. Read-only.

Declaration
[CLSCompliant(false)]
public Chart3DDataFormatRecord Serie3DDataFormat { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.Chart3DDataFormatRecord

Serie3DdDataFormatOrNull

If 3dData not Null returns 3DData format main record; otherwise - returns null. Read-only.

Declaration
[CLSCompliant(false)]
public Chart3DDataFormatRecord Serie3DdDataFormatOrNull { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.Chart3DDataFormatRecord

SerieFormat

Returns Series format main record. Read-only.

Declaration
[CLSCompliant(false)]
public ChartSerFmtRecord SerieFormat { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartSerFmtRecord

SerieFormatOrNull

if SerieFormat not Null returns Series format main record; otherwise - returns null. Read-only.

Declaration
[CLSCompliant(false)]
public ChartSerFmtRecord SerieFormatOrNull { get; }
Property Value
Type Description
Syncfusion.XlsIO.Parser.Biff_Records.Charts.ChartSerFmtRecord

SeriesNumber

Gets or sets Series number.

Declaration
public int SeriesNumber { get; set; }
Property Value
Type Description
System.Int32

Shadow

Gets the shadow.

Declaration
public IShadow Shadow { get; }
Property Value
Type Description
IShadow

ShowActiveValue

Gets or sets value indicating whether to show label active value.

Declaration
public bool ShowActiveValue { get; set; }
Property Value
Type Description
System.Boolean

ShowBubble

Show bubble sizes.

Declaration
public bool ShowBubble { get; set; }
Property Value
Type Description
System.Boolean

ShowCategoryLabel

Show category label.

Declaration
public bool ShowCategoryLabel { get; set; }
Property Value
Type Description
System.Boolean

ShowConnectorLines

Gets or sets a boolean value indicating whether to display Connector Lines between data points

Declaration
public bool ShowConnectorLines { get; set; }
Property Value
Type Description
System.Boolean
Remarks

Applies only to Waterfall Charts

ShowInnerPoints

Gets or sets a boolean value indicating whether to display Inner Points in Box and Whisker chart

Declaration
public bool ShowInnerPoints { get; set; }
Property Value
Type Description
System.Boolean

ShowMeanLine

Gets or sets a boolean value indicating whether to display Mean Line in Box and Whisker chart

Declaration
public bool ShowMeanLine { get; set; }
Property Value
Type Description
System.Boolean

ShowMeanMarkers

Gets or sets a boolean value indicating whether to display Mean Marker in Box and Whisker chart

Declaration
public bool ShowMeanMarkers { get; set; }
Property Value
Type Description
System.Boolean

ShowOutlierPoints

Gets or sets a boolean value indicating whether to display Outlier Points in Box and Whisker chart

Declaration
public bool ShowOutlierPoints { get; set; }
Property Value
Type Description
System.Boolean

ShowPieCategoryLabel

Show category label and value as a percentage (pie charts only).

Declaration
public bool ShowPieCategoryLabel { get; set; }
Property Value
Type Description
System.Boolean

ShowPieInPercents

Show value as a percent of the total. This bit applies only to pie charts.

Declaration
public bool ShowPieInPercents { get; set; }
Property Value
Type Description
System.Boolean

SmoothLine

Show smoothed line.

Declaration
public bool SmoothLine { get; set; }
Property Value
Type Description
System.Boolean

ThreeD

Gets the chart3 D options.

Declaration
public IThreeDFormat ThreeD { get; }
Property Value
Type Description
IThreeDFormat

The chart3 D options.

TreeMapLabelOption

Gets / Sets the Display label position in Tree map chart

Declaration
public ExcelTreeMapLabelOption TreeMapLabelOption { get; set; }
Property Value
Type Description
ExcelTreeMapLabelOption
Remarks

By Default the Label is overlapped

Visible

Represents visibility.

Declaration
public bool Visible { get; set; }
Property Value
Type Description
System.Boolean

Methods

ChangeLineDataFormat(ExcelChartType)

Changes data format to create line chart.

Declaration
public void ChangeLineDataFormat(ExcelChartType type)
Parameters
Type Name Description
ExcelChartType type

Type to change.

ChangeRadarDataFormat(ExcelChartType)

Changes data format to create radar chart.

Declaration
public void ChangeRadarDataFormat(ExcelChartType type)
Parameters
Type Name Description
ExcelChartType type

Type to change.

ChangeScatterDataFormat(ExcelChartType)

Changes data format to create scatter chart.

Declaration
public void ChangeScatterDataFormat(ExcelChartType type)
Parameters
Type Name Description
ExcelChartType type

Type to change.

ClearOnPropertyChange()

Clears sub data formats on property change.

Declaration
public void ClearOnPropertyChange()

Clone(Object)

Clone current instance.

Declaration
public ChartSerieDataFormatImpl Clone(object parent)
Parameters
Type Name Description
System.Object parent

Parent object.
Returns
Type Description
ChartSerieDataFormatImpl

Return cloned object.

OnDispose()

Declaration
protected override void OnDispose()
Overrides

SetDefaultValues()

Sets default values.

Declaration
public void SetDefaultValues()

UpdateColor(ChartSerieImpl, ChartDataPointImpl)

Updates color for line, markers and series.

Declaration
public static int UpdateColor(ChartSerieImpl serie, ChartDataPointImpl dataPoint)
Parameters
Type Name Description
ChartSerieImpl serie

Represents series to update color.
ChartDataPointImpl dataPoint

Represents data point to update color.
Returns
Type Description
System.Int32

Returns updated color index.

UpdateDataFormatInDataPoint()

Updates data format in data points.

Declaration
public void UpdateDataFormatInDataPoint()

UpdateLineColor()

Updates line color for line, radar, skater Series data format.

Declaration
public int UpdateLineColor()
Returns
Type Description
System.Int32

Returns updated color index or -1.

UpdateSerieFormat()

Updates series formats for chartformat object.

Declaration
public void UpdateSerieFormat()

UpdateSerieIndex()

Updates Series index.

Declaration
public void UpdateSerieIndex()

Implements

System.IDisposable