XlsChartSerieDataFormat Class |
Represents the data format settings for a series in an Excel chart.
Inheritance Hierarchy
System
Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet.Charts XlsChartSerieDataFormat
Spire.Xls.Charts ChartSerieDataFormat
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet.Charts XlsChartSerieDataFormat
Spire.Xls.Charts ChartSerieDataFormat
Namespace: Spire.Xls.Core.Spreadsheet.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The XlsChartSerieDataFormat type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AreaProperties |
Returns object, that represents aera properties. Read only.
|
|
|
BackGroundColor |
Represents background color.
|
|
|
BackGroundColorObject |
Represents background color.
|
|
|
BackGroundKnownColor |
Represents background excel color.
|
|
|
BarTopType |
Represents the top data format.
|
|
|
BarType |
Represents the base data format.
|
|
|
Fill |
Represents XlsFill options. Read-only.
|
|
|
ForeGroundColor |
Represents foreground color.
|
|
|
ForeGroundColorObject |
Represents foreground color object.
|
|
|
ForeGroundKnownColor |
Represents foreground color.
|
|
|
Format3D |
Gets the chart3 D properties.
|
|
|
Has_dPtPieExplosion |
Indicates whether dataformat has PieExplosion.
|
|
|
HasBorder |
Indicates whether chart has border.
|
|
|
HasBorderLine |
Indicates whethers chart has border line.
|
|
|
HasFormat3D |
Gets a value indicating whether [has3d properties].
|
|
|
HasInterior |
This property indicates whether interior object was created. Read-only.
|
|
|
HasLineProperties |
This property indicates whether line formatting object was created. Read-only.
|
|
|
HasShadow |
Gets a value indicating whether this instance has shadow properties.
|
|
|
Interior |
Returns object, that represents area properties. Read-only.
|
|
|
Is3DBubbles |
True to draw bubbles with 3D effects.
|
|
|
IsAutoMarker |
Automatic color.
|
|
|
IsAutomaticFormat |
Indicates, if automatic format is used.
|
|
|
IsBorderSupported |
Indicates whether border object is supported. Read-only.
|
|
|
IsFormatted |
Indicate if data format is formatted.
|
|
|
IsInteriorSupported |
Indicates whether interior object is supported. Read-only.
|
|
|
IsMarker |
If true - format has marker; otherwise false. Read-only.
|
|
|
IsMarkerSupported |
Indicates whether marker is supported by this chart/series.
|
|
|
IsShadow |
Obsolete.
True if this series has a shadow.
|
|
|
IsShowBackground |
True = "background = none".
|
|
|
IsShowForeground |
True = "foreground = none".
|
|
|
IsSmoothed |
If true - format has smothed line; otherwise false. Read-only.
|
|
|
IsSmoothedLine |
True if the line series has a smoothed line.
|
|
|
IsSupportFill |
Indicats whether chart supports transparency.
|
|
|
LineProperties |
Returns object, that represents line properties. Read-only.
|
|
|
MarkerBackColorObject |
Gets object that holds marker background color.
|
|
|
MarkerBackgroundColor |
Foreground color: RGB value (high byte = 0).
|
|
|
MarkerBackgroundKnownColor |
Index to color of marker XlsFill.
|
|
|
MarkerBorderWidth |
Marker border weight(unit pt).
|
|
MarkerFill |
Get fill object of the marker.
Examples
The following code illustrates how to fill a marker . <para>var markerFill = chart.Series[0].Format.MarkerFill;</para><para>//fill by defined Texture</para><para>markerFill.Texture = GradientTextureType.GreenMarble;</para><para></para><para>//fill by defined Pattern</para><para>markerFill.Pattern = GradientPatternType.PatLargeCheckerBoard;</para><para>//Pattern need set fore/background color</para><para>markerFill.ForeColor = Color.Blue;</para><para>markerFill.BackColor = Color.Red;</para><para>//fill by a picture</para><para>markerFill.CustomPicture("type1.png")</para><para>//set transparency: value from 0.0 (Clear) through 1.0(Opaque)</para><para>markerFill.Transparency = 0.5;</para> |
|
|
MarkerForeColorObject |
Gets object that holds marker foreground color.
|
|
|
MarkerForegroundColor |
Background color: RGB value (high byte = 0).
|
|
|
MarkerForegroundKnownColor |
Index to color of marker border.
|
|
|
MarkerSize |
Size of line markers.
|
|
|
MarkerStyle |
Type of marker.
|
|
|
MarkerTransparencyValue |
Gets or sets the transparency of the line marker.
|
|
|
Options |
Gets common serie options. Read-only.
|
|
|
Parent |
Reference to Parent object. Read-only.
(Inherited from
XlsObject
.)
|
|
|
ParentSerie |
Returns parent serie. Read-only.
|
|
|
Pattern |
Represents pattern.
|
|
|
Percent |
Distance of pie slice from center of pie.
|
|
|
QuartileCalculationType |
Gets / Sets whether the Quartile calculation is Exclusive or Inclusive
|
|
ReferenceCount |
Get quantity of instance references.
(Inherited from
XlsObject
.)
|
|
|
SeriesNumber |
Obsolete.
Gets or sets serie number.
|
|
|
Shadow |
Gets the shadow properties.
|
|
|
ShowActiveValue |
Obsolete.
Indicates whether chart show active value.
|
|
|
ShowBubble |
Obsolete.
Show bubble sizes.
|
|
|
ShowCategoryLabel |
Obsolete.
Show category label.
|
|
|
ShowConnectorLines |
Gets or sets a boolean value indicating whether to display
Connector Lines between data points
|
|
|
ShowInnerPoints |
Gets or sets a boolean value indicating whether to display
Inner Points in Box and Whisker chart
|
|
|
ShowMeanLine |
Gets or sets a boolean value indicating whether to display
Mean Line in Box and Whisker chart
|
|
|
ShowMeanMarkers |
Gets or sets a boolean value indicating whether to display
Mean Marker in Box and Whisker chart
|
|
|
ShowOutlierPoints |
Gets or sets a boolean value indicating whether to display
Outlier Points in Box and Whisker chart
|
|
|
ShowPieCategoryLabel |
Obsolete.
Show category label and value as a percentage (pie charts only).
|
|
|
ShowPieInPercents |
Obsolete.
Show value as a percent of the total.(pie charts only).
|
|
|
SmoothLine |
Obsolete.
Show smoothed line.
|
|
|
TreeMapLabelOption |
Gets / Sets the Display label position in Tree map chart
|
|
|
Visible |
Represents visiblity.
|
Methods
| Name | Description | |
|---|---|---|
|
AddReference |
Increase the quantity of reference. User must use this method when
new wrapper on object is created or reference on object stored.
(Inherited from
XlsObject
.)
|
|
|
CheckDisposed |
Checks whether object was disposed and throws exception if it was.
(Inherited from
XlsObject
.)
|
|
Dispose |
Dispose object and free resources.
(Inherited from
XlsObject
.)
|
|
|
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
|
|
Finalize |
Destructor. Call dispose method of current object.
(Inherited from
XlsObject
.)
|
|
|
FindParent(Type) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
|
|
FindParent( Type ) |
Find parent of object.
(Inherited from
XlsObject
.)
|
|
|
FindParent(Type, Boolean) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
|
|
FindParents |
Finds parent objects.
(Inherited from
XlsObject
.)
|
|
|
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
|
|
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
|
|
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
|
|
OnDispose |
Method which can be overriden by users to take any specific actions when
object is disposed.
(Inherited from
XlsObject
.)
|
|
|
ReleaseReference |
Decrease quantity of Reference. User must call this method
when freeing resources.
(Inherited from
XlsObject
.)
|
|
|
SetParent |
Sets parent of the object.
(Inherited from
XlsObject
.)
|
|
|
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|
Fields
| Name | Description | |
|---|---|---|
|
m_bIsDisposed |
Flag which indicates if the object was disposed or not.
(Inherited from
XlsObject
.)
|
See Also
