Class ChartImpl
Represents a chart sheet in the workbook.
Implements
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.Charts
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class ChartImpl : WorksheetBaseImpl, IDisposable, IChart, ITabSheet, IParentApplication, ISerializableNamedObject, INamedObject, IParseable, ICloneParent
Constructors
ChartImpl(IApplication, Object)
Initializes a new instance of ChartImpl class.
Declaration
public ChartImpl(IApplication application, object parent)
Parameters
Type | Name | Description |
---|---|---|
IApplication | application | Application object for the chart. |
System.Object | parent | Parent object for the chart. |
ChartImpl(IApplication, Object, BiffReader, ExcelParseOptions, Boolean, Dictionary<Int32, Int32>, IDecryptor)
Initializes a new instance of ChartImpl class from biff reader and specified decryptor.
Declaration
public ChartImpl(IApplication application, object parent, BiffReader reader, ExcelParseOptions options, bool bSkipParsing, Dictionary<int, int> hashXFormatIndexes, IDecryptor decryptor)
Parameters
Type | Name | Description |
---|---|---|
IApplication | application | Application object for the chart. |
System.Object | parent | Parent object for the chart. |
BiffReader | reader | BiffReader to extract data from. |
ExcelParseOptions | options | Parse options. |
System.Boolean | bSkipParsing | Indicates whether to skip parsing. |
System.Collections.Generic.Dictionary<System.Int32, System.Int32> | hashXFormatIndexes | Dictionary with new extended format indexes for ignore styles mode. |
IDecryptor | decryptor | Object used to decrypt encrypted records. |
ChartImpl(IApplication, Object, IList, ref Int32, ExcelParseOptions)
Initializes a new instance of ChartImpl class from the array of BiffRecords.
Declaration
public ChartImpl(IApplication application, object parent, IList data, ref int iPos, ExcelParseOptions options)
Parameters
Type | Name | Description |
---|---|---|
IApplication | application | Application object for the chart. |
System.Object | parent | Parent object for the chart. |
System.Collections.IList | data | Array of BiffRecords with chart's data. |
System.Int32 | iPos | Position of the first chart's record. |
ExcelParseOptions | options | Parse options. |
Fields
CHARTS_100
Represent 100% charts.
Declaration
public static ExcelChartType[] CHARTS_100
Field Value
Type |
---|
ExcelChartType[] |
Remarks
Here each value in a series is shown as a portion of 100%.
CHARTS_BUBBLE
Represent bubble charts.
Declaration
public static ExcelChartType[] CHARTS_BUBBLE
Field Value
Type |
---|
ExcelChartType[] |
Remarks
These are variation of scatter charts in which the data points are replaced with bubbles.
CHARTS_CLUSTERED
Represent clustered charts.
Declaration
public static ExcelChartType[] CHARTS_CLUSTERED
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_EXPLODED
Represent exploded charts.
Declaration
public static ExcelChartType[] CHARTS_EXPLODED
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_LINE
Represent line charts.
Declaration
public static ExcelChartType[] CHARTS_LINE
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_PERSPECTIVE
Represent charts with perspective.
Declaration
public static ExcelChartType[] CHARTS_PERSPECTIVE
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_SCATTER
Represent scatter charts.
Declaration
public static ExcelChartType[] CHARTS_SCATTER
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_SMOOTHED_LINE
Represent charts with smoothed lines.
Declaration
public static ExcelChartType[] CHARTS_SMOOTHED_LINE
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_STOCK
Represent stock charts.
Declaration
public static ExcelChartType[] CHARTS_STOCK
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_VARYCOLOR
Represent charts that need different color for each value.
Declaration
public static ExcelChartType[] CHARTS_VARYCOLOR
Field Value
Type |
---|
ExcelChartType[] |
CHARTS_WITH_PLOT_AREA
Represent charts with plot area (by default).
Declaration
public static ExcelChartType[] CHARTS_WITH_PLOT_AREA
Field Value
Type |
---|
ExcelChartType[] |
CHARTS3D
Represent 3D charts.
Declaration
public static ExcelChartType[] CHARTS3D
Field Value
Type |
---|
ExcelChartType[] |
DEF_CHANGE_INTIMATE
Represent chart types that can change as intimate types.
Declaration
public static ExcelChartType[] DEF_CHANGE_INTIMATE
Field Value
Type |
---|
ExcelChartType[] |
DEF_CHANGE_SERIE
Represent types of charts that allow serie change.
Declaration
public static ExcelChartType[] DEF_CHANGE_SERIE
Field Value
Type |
---|
ExcelChartType[] |
DEF_CHART_PERCENTAGE
Represent charts with percentage data labels.
Declaration
public static ExcelChartType[] DEF_CHART_PERCENTAGE
Field Value
Type |
---|
ExcelChartType[] |
DEF_COMBINATION_CHART
Represent chart types that are combination of two different charts.
Declaration
public static ExcelChartType[] DEF_COMBINATION_CHART
Field Value
Type |
---|
ExcelChartType[] |
DEF_DONT_NEED_PLOT
Represent chart start types that does not need plot or walls.
Declaration
public static ExcelChartType[] DEF_DONT_NEED_PLOT
Field Value
Type |
---|
ExcelChartType[] |
DEF_FIRST_SERIE_NAME
Represent default name for the first series of the chart.
Declaration
public const string DEF_FIRST_SERIE_NAME = "Serie1"
Field Value
Type |
---|
System.String |
DEF_LEGEND_NEED_DATA_POINT
Represent start types of chart that support data point.
Declaration
public static string[] DEF_LEGEND_NEED_DATA_POINT
Field Value
Type |
---|
System.String[] |
DEF_NEED_SECONDARY_AXIS
Represent serie types that must be in secondary axis.
Declaration
public static ExcelChartType[] DEF_NEED_SECONDARY_AXIS
Field Value
Type |
---|
ExcelChartType[] |
DEF_NEED_VIEW_3D
Represent pivot chart types which need view tag to be rendered.
Declaration
public static ExcelChartType[] DEF_NEED_VIEW_3D
Field Value
Type |
---|
ExcelChartType[] |
DEF_NOT_3D
Represent types of charts that are not 3D.
Declaration
public static ExcelChartType[] DEF_NOT_3D
Field Value
Type |
---|
ExcelChartType[] |
DEF_NOT_SUPPORT_GRIDLINES
Represent serie types that does not support gridlines.
Declaration
public static ExcelChartType[] DEF_NOT_SUPPORT_GRIDLINES
Field Value
Type |
---|
ExcelChartType[] |
DEF_PRIORITY_START_TYPES
Represents array of start serie types sorted by drawing order.
Declaration
public static string[] DEF_PRIORITY_START_TYPES
Field Value
Type |
---|
System.String[] |
DEF_SI_BUBBLE
Si bubble index.
Declaration
public const int DEF_SI_BUBBLE = 3
Field Value
Type |
---|
System.Int32 |
DEF_SI_CATEGORY
Si category index.
Declaration
public const int DEF_SI_CATEGORY = 2
Field Value
Type |
---|
System.Int32 |
DEF_SI_VALUE
Si value index.
Declaration
public const int DEF_SI_VALUE = 1
Field Value
Type |
---|
System.Int32 |
DEF_SPECIAL_DATA_LABELS
Represent the charts with data labels stored in different ways.
Declaration
public static ExcelChartType[] DEF_SPECIAL_DATA_LABELS
Field Value
Type |
---|
ExcelChartType[] |
DEF_SUPPORT_DATA_TABLE
Represent the charts that support data table.
Declaration
public static string[] DEF_SUPPORT_DATA_TABLE
Field Value
Type |
---|
System.String[] |
DEF_SUPPORT_ERROR_BARS
Represent the charts that support error bars.
Declaration
public static string[] DEF_SUPPORT_ERROR_BARS
Field Value
Type |
---|
System.String[] |
DEF_SUPPORT_SERIES_AXIS
Represent the charts that support series axis.
Declaration
public static ExcelChartType[] DEF_SUPPORT_SERIES_AXIS
Field Value
Type |
---|
ExcelChartType[] |
DEF_SUPPORT_TREND_LINES
Represent the charts that support trendlines.
Declaration
public static ExcelChartType[] DEF_SUPPORT_TREND_LINES
Field Value
Type |
---|
ExcelChartType[] |
DEF_UNSUPPORT_PIVOT_CHART
Represent the charts that do not support pivot charts.
Declaration
public static ExcelChartType[] DEF_UNSUPPORT_PIVOT_CHART
Field Value
Type |
---|
ExcelChartType[] |
DEF_WALLS_OR_FLOOR_TYPES
Represent the charts that contain walls or floor.
Declaration
public static ExcelChartType[] DEF_WALLS_OR_FLOOR_TYPES
Field Value
Type |
---|
ExcelChartType[] |
DEFAULT_CHART_TYPE
Represents the default chart type.
Declaration
public const ExcelChartType DEFAULT_CHART_TYPE
Field Value
Type |
---|
ExcelChartType |
LEGEND_VERTICAL
Represent the legend types that are displayed vertically.
Declaration
public static ExcelLegendPosition[] LEGEND_VERTICAL
Field Value
Type |
---|
ExcelLegendPosition[] |
NO_CATEGORY_AXIS
Represent the charts that can be without category axis.
Declaration
public static ExcelChartType[] NO_CATEGORY_AXIS
Field Value
Type |
---|
ExcelChartType[] |
PREFIX_3D
Represents the prefix for 3D charts.
Declaration
public const string PREFIX_3D = "_3D"
Field Value
Type |
---|
System.String |
PREFIX_BAR
Represents the prefix for bar charts.
Declaration
public const string PREFIX_BAR = "_Bar"
Field Value
Type |
---|
System.String |
PREFIX_CLUSTERED
Represents the prefix for clustered charts.
Declaration
public const string PREFIX_CLUSTERED = "_Clustered"
Field Value
Type |
---|
System.String |
PREFIX_CONTOUR
Represents the prefix for contour charts.
Declaration
public const string PREFIX_CONTOUR = "_Contour"
Field Value
Type |
---|
System.String |
PREFIX_EXPLODED
Represents the prefix for exploded charts.
Declaration
public const string PREFIX_EXPLODED = "_Exploded"
Field Value
Type |
---|
System.String |
PREFIX_LINE
Represents the prefix for line charts.
Declaration
public const string PREFIX_LINE = "_Line"
Field Value
Type |
---|
System.String |
PREFIX_MARKERS
Represents the prefix for charts with markers.
Declaration
public const string PREFIX_MARKERS = "_Markers"
Field Value
Type |
---|
System.String |
PREFIX_NOCOLOR
Represents the prefix for charts with no color.
Declaration
public const string PREFIX_NOCOLOR = "_NoColor"
Field Value
Type |
---|
System.String |
PREFIX_SHOW_PERCENT
Represents the prefix for 100% charts.
Declaration
public const string PREFIX_SHOW_PERCENT = "_100"
Field Value
Type |
---|
System.String |
PREFIX_SMOOTHEDLINE
Represents the prefix for charts with smoothed lines.
Declaration
public const string PREFIX_SMOOTHEDLINE = "_SmoothedLine"
Field Value
Type |
---|
System.String |
PREFIX_STACKED
Represents the prefix for stacked charts.
Declaration
public const string PREFIX_STACKED = "_Stacked"
Field Value
Type |
---|
System.String |
STACKEDCHARTS
Represent the stacked charts.
Declaration
public static ExcelChartType[] STACKEDCHARTS
Field Value
Type |
---|
ExcelChartType[] |
START_AREA
Represents the defined start for area charts.
Declaration
public const string START_AREA = "Area"
Field Value
Type |
---|
System.String |
START_BAR
Represents the defined start for bar charts.
Declaration
public const string START_BAR = "Bar"
Field Value
Type |
---|
System.String |
START_BUBBLE
Represents the defined start for bubble charts.
Declaration
public const string START_BUBBLE = "Bubble"
Field Value
Type |
---|
System.String |
START_COLUMN
Represents the defined start for column charts.
Declaration
public const string START_COLUMN = "Column"
Field Value
Type |
---|
System.String |
START_CONE
Represents the defined start for cone charts.
Declaration
public const string START_CONE = "Cone"
Field Value
Type |
---|
System.String |
START_CYLINDER
Represents the defined start for cylinder charts.
Declaration
public const string START_CYLINDER = "Cylinder"
Field Value
Type |
---|
System.String |
START_DOUGHNUT
Represents the defined start for doughnut charts.
Declaration
public const string START_DOUGHNUT = "Doughnut"
Field Value
Type |
---|
System.String |
START_LINE
Represents the defined start for line charts.
Declaration
public const string START_LINE = "Line"
Field Value
Type |
---|
System.String |
START_PIE
Represents the defined start for pie charts.
Declaration
public const string START_PIE = "Pie"
Field Value
Type |
---|
System.String |
START_PYRAMID
Represents the defined start for pyramid charts.
Declaration
public const string START_PYRAMID = "Pyramid"
Field Value
Type |
---|
System.String |
START_RADAR
Represents the defined start for radar charts.
Declaration
public const string START_RADAR = "Radar"
Field Value
Type |
---|
System.String |
START_SCATTER
Represents the defined start for scatter charts.
Declaration
public const string START_SCATTER = "Scatter"
Field Value
Type |
---|
System.String |
START_SURFACE
Represents the defined start for surface charts.
Declaration
public const string START_SURFACE = "Surface"
Field Value
Type |
---|
System.String |
Properties
AutoScaling
True to automatically scale the chart. otherwise False. The RightAngleAxes property must be True.
Declaration
public bool AutoScaling { get; set; }
Property Value
Type |
---|
System.Boolean |
Remarks
Excel scales a 3-D chart so that it is closer in size to the equivalent 2-D chart when this property is enabled.
BackWall
Gets the back wall of the 3D chart. Read-only.
Declaration
public IChartWallOrFloor BackWall { get; set; }
Property Value
Type |
---|
IChartWallOrFloor |
CanChartBubbleLabel
True if chart has bubble data labels. False otherwise. Read-only.
Declaration
public bool CanChartBubbleLabel { get; }
Property Value
Type |
---|
System.Boolean |
CanChartHaveSeriesLines
True if chart has series lines. False otherwise. Read-only.
Declaration
public bool CanChartHaveSeriesLines { get; }
Property Value
Type |
---|
System.Boolean |
CanChartPercentageLabel
True if chart has percentage data labels. False otherwise. Read-only.
Declaration
public bool CanChartPercentageLabel { get; }
Property Value
Type |
---|
System.Boolean |
Categories
Gets a collection of categories of the chart. Read-only.
Declaration
public IChartCategories Categories { get; }
Property Value
Type |
---|
IChartCategories |
Remarks
Charts are plotted using X and Y axes. X axes typically have categorical scales. Categories can include string, numeric, and date values.
CategoryAxisTitle
Gets or sets the title of the category axis.
Declaration
public string CategoryAxisTitle { get; set; }
Property Value
Type |
---|
System.String |
CategoryFormula
Represents the category lable reference as range
Declaration
public string CategoryFormula { get; set; }
Property Value
Type |
---|
System.String |
CategoryLabelLevel
Gets or sets a value referring to the source level for the category labels.
Declaration
public ExcelCategoriesLabelLevel CategoryLabelLevel { get; set; }
Property Value
Type |
---|
ExcelCategoriesLabelLevel |
CategoryLabelValues
Represents the common category label values.
Declaration
public object[] CategoryLabelValues { get; set; }
Property Value
Type |
---|
System.Object[] |
ChartArea
Gets the chart area. Read-only.
Declaration
public IChartFrameFormat ChartArea { get; }
Property Value
Type |
---|
IChartFrameFormat |
ChartProperties
Gets the chart options. Read-only.
Declaration
public ChartShtpropsRecord ChartProperties { get; }
Property Value
Type |
---|
ChartShtpropsRecord |
ChartStartType
Gets the start serie type of chart. Read-only.
Declaration
public string ChartStartType { get; }
Property Value
Type |
---|
System.String |
ChartTitle
Gets or sets the title of the chart.
Declaration
public string ChartTitle { get; set; }
Property Value
Type |
---|
System.String |
ChartTitleArea
Gets the area for chart title. Read-only.
Declaration
public IChartTextArea ChartTitleArea { get; }
Property Value
Type |
---|
IChartTextArea |
ChartTitleFont
Gets the font used for title display. Read-only.
Declaration
public IFont ChartTitleFont { get; }
Property Value
Type |
---|
IFont |
ChartType
Gets or sets the ExcelChartType.
Declaration
public ExcelChartType ChartType { get; set; }
Property Value
Type |
---|
ExcelChartType |
DataRange
Gets or sets the data range for the chart series.
Declaration
public IRange DataRange { get; set; }
Property Value
Type |
---|
IRange |
DataTable
Gets the data table of the chart. Read-only.
Declaration
public IChartDataTable DataTable { get; }
Property Value
Type |
---|
IChartDataTable |
DefaultLinePattern
Gets the default line pattern for the chart. Read-only.
Declaration
public ExcelChartLinePattern DefaultLinePattern { get; }
Property Value
Type |
---|
ExcelChartLinePattern |
DefaultProtectionOptions
Gets default protection options for the worksheet.
Declaration
protected override ExcelSheetProtection DefaultProtectionOptions { get; }
Property Value
Type |
---|
ExcelSheetProtection |
Overrides
DefaultTextIndex
Gets the font index from the default font records. Read-only.
Declaration
public int DefaultTextIndex { get; }
Property Value
Type |
---|
System.Int32 |
DepthPercent
Gets or sets the depth of a 3D chart as a percentage of the chart width (20 - 2000 percent).
Declaration
public int DepthPercent { get; set; }
Property Value
Type |
---|
System.Int32 |
DestinationType
Gets or sets the resulting chart type after type change operation.
Declaration
public ExcelChartType DestinationType { get; set; }
Property Value
Type |
---|
ExcelChartType |
DisplayBlanksAs
Gets or sets a value indicating how the blank cells are plotted on chart.
Declaration
public ExcelChartPlotEmpty DisplayBlanksAs { get; set; }
Property Value
Type |
---|
ExcelChartPlotEmpty |
Elevation
Gets or sets the elevation of the 3-D chart view, in degrees (–90 to +90 degrees).
Declaration
public int Elevation { get; set; }
Property Value
Type |
---|
System.Int32 |
Remarks
The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.
Floor
Gets the floor of the 3D chart. Read-only.
Declaration
public IChartWallOrFloor Floor { get; set; }
Property Value
Type |
---|
IChartWallOrFloor |
Font
Gets the font used for axis text display. Read-only.
Declaration
public IFont Font { get; }
Property Value
Type |
---|
IFont |
FormatId
Gets or sets the format id of the chart.
Declaration
public int FormatId { get; set; }
Property Value
Type |
---|
System.Int32 |
GapDepth
Gets or sets the distance between data series in a 3D chart, as a percentage of marker width ( 0 - 500 ).
Declaration
public int GapDepth { get; set; }
Property Value
Type |
---|
System.Int32 |
HasChartArea
Gets or sets whether the chart has chart area.
Declaration
public bool HasChartArea { get; set; }
Property Value
Type |
---|
System.Boolean |
HasChartTitle
True if the chart has title. False otherwise. Read-only.
Declaration
public bool HasChartTitle { get; }
Property Value
Type |
---|
System.Boolean |
HasDataTable
True if the chart has data table. otherwise False.
Declaration
public bool HasDataTable { get; set; }
Property Value
Type |
---|
System.Boolean |
HasFloor
Gets a value indicating whether chart floor object is created. False otherwise.
Declaration
public bool HasFloor { get; }
Property Value
Type |
---|
System.Boolean |
HasLegend
True if the chart has a legend object. otherwise False.
Declaration
public bool HasLegend { get; set; }
Property Value
Type |
---|
System.Boolean |
HasPivotSource
True if the chart has pivot source. False otherwise.
Declaration
public bool HasPivotSource { get; }
Property Value
Type |
---|
System.Boolean |
HasPlotArea
Gets or sets a boolean value indicating whether the chart has plot area.
Declaration
public bool HasPlotArea { get; set; }
Property Value
Type |
---|
System.Boolean |
HasTitle
True if the chart has title. False otherwise.
Declaration
public bool HasTitle { get; set; }
Property Value
Type |
---|
System.Boolean |
HasWalls
True if the chart walls are present. False otherwise. Read-only.
Declaration
public bool HasWalls { get; }
Property Value
Type |
---|
System.Boolean |
Height
Gets or sets the height of the chart in points (1/72 inch).
Declaration
public double Height { get; set; }
Property Value
Type |
---|
System.Double |
HeightPercent
Gets or sets the height of a 3D chart as a percentage of the chart width (5 - 500 percent).
Declaration
public int HeightPercent { get; set; }
Property Value
Type |
---|
System.Int32 |
InnerChartArea
Gets the inner chart area. Read-only.
Declaration
public ChartFrameFormatImpl InnerChartArea { get; }
Property Value
Type |
---|
ChartFrameFormatImpl |
InnerPlotArea
Gets the inner plot area. Read-only.
Declaration
public ChartFrameFormatImpl InnerPlotArea { get; }
Property Value
Type |
---|
ChartFrameFormatImpl |
InnerWorkbook
Gets the parent workbook. Read-only.
Declaration
public WorkbookImpl InnerWorkbook { get; }
Property Value
Type |
---|
WorkbookImpl |
IsCategoryAxisAvail
True if chart has a category axis. False otherwise. Read-only.
Declaration
public bool IsCategoryAxisAvail { get; }
Property Value
Type |
---|
System.Boolean |
IsChart_100
True if chart is 100%. False otherwise. Read-only.
Declaration
public bool IsChart_100 { get; }
Property Value
Type |
---|
System.Boolean |
Remarks
The chart assumes that the values add up to 100%, so all the columns will occupy the entire area.
IsChart3D
True if chart is a 3D- chart. False otherwise. Read-only.
Declaration
public bool IsChart3D { get; }
Property Value
Type |
---|
System.Boolean |
IsChartBar
True if chart is a bar chart. False otherwise. Read-only.
Declaration
public bool IsChartBar { get; }
Property Value
Type |
---|
System.Boolean |
IsChartBubble
True if chart is a bubble chart. False otherwise. Read-only.
Declaration
public bool IsChartBubble { get; }
Property Value
Type |
---|
System.Boolean |
IsChartCone
True if chart is in a conical shape. False otherwise. Read-only.
Declaration
public bool IsChartCone { get; }
Property Value
Type |
---|
System.Boolean |
IsChartCylinder
True if chart is in a cylinder shape. False otherwise. Read-only.
Declaration
public bool IsChartCylinder { get; }
Property Value
Type |
---|
System.Boolean |
IsChartDoughnut
True if chart is a doughnut shaped chart. False otherwise. Read-only.
Declaration
public bool IsChartDoughnut { get; }
Property Value
Type |
---|
System.Boolean |
IsChartExploded
True if chart is in in exploded view. False otherwise. Read-only.
Declaration
public bool IsChartExploded { get; }
Property Value
Type |
---|
System.Boolean |
IsChartFloor
True if chart has floor. False otherwise. Read-only.
Declaration
public bool IsChartFloor { get; }
Property Value
Type |
---|
System.Boolean |
IsChartLine
True if chart is a line chart. False otherwise. Read-only.
Declaration
public bool IsChartLine { get; }
Property Value
Type |
---|
System.Boolean |
IsChartPie
True if chart is a pie chart. False otherwise. Read-only.
Declaration
public bool IsChartPie { get; }
Property Value
Type |
---|
System.Boolean |
IsChartPyramid
True if chart is in a pyramid shape. False otherwise. Read-only.
Declaration
public bool IsChartPyramid { get; }
Property Value
Type |
---|
System.Boolean |
IsChartRadar
True if chart is a radar chart. False otherwise. Read-only.
Declaration
public bool IsChartRadar { get; }
Property Value
Type |
---|
System.Boolean |
IsChartScatter
True if chart is a scatter chart. False otherwise. Read-only.
Declaration
public bool IsChartScatter { get; }
Property Value
Type |
---|
System.Boolean |
IsChartSmoothedLine
True if chart has smoothed lines. False otherwise. Read-only.
Declaration
public bool IsChartSmoothedLine { get; }
Property Value
Type |
---|
System.Boolean |
IsChartStock
True if this is a stock chart. False otherwise. Read-only.
Declaration
public bool IsChartStock { get; }
Property Value
Type |
---|
System.Boolean |
IsChartVaryColor
True if chart should have a different color for each series value. False otherwise. Read-only.
Declaration
public bool IsChartVaryColor { get; }
Property Value
Type |
---|
System.Boolean |
IsChartVolume
True if chart is a stock chart with volume. False otherwise. Read-only.
Declaration
public bool IsChartVolume { get; }
Property Value
Type |
---|
System.Boolean |
IsChartWalls
True if chart has walls. False otherwise. Read-only.
Declaration
public bool IsChartWalls { get; }
Property Value
Type |
---|
System.Boolean |
IsClustered
True if the chart is a clustered chart. False otherwise. Read-only.
Declaration
public bool IsClustered { get; }
Property Value
Type |
---|
System.Boolean |
IsEmbeded
Gets a value indicating whether chart is embeded into worksheet. False otherwise. Read-only.
Declaration
public bool IsEmbeded { get; }
Property Value
Type |
---|
System.Boolean |
IsManuallyFormatted
True if the chart is manually formatted. False otherwise.
Declaration
public bool IsManuallyFormatted { get; set; }
Property Value
Type |
---|
System.Boolean |
IsPerspective
True if chart has perspective. False otherwise. Read-only.
Declaration
public bool IsPerspective { get; }
Property Value
Type |
---|
System.Boolean |
IsPivotChart3D
Gets a value indicating whether this instance is 3D pivot chart.
Declaration
public bool IsPivotChart3D { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
IsSecondaryAxes
True if at least one of the secondary axes is present. False otherwise. Read-only.
Declaration
public bool IsSecondaryAxes { get; set; }
Property Value
Type |
---|
System.Boolean |
IsSecondaryCategoryAxisAvail
True if secondary category axis is present. False otherwise. Read-only.
Declaration
public bool IsSecondaryCategoryAxisAvail { get; }
Property Value
Type |
---|
System.Boolean |
IsSecondaryValueAxisAvail
True if secondary value axis is present. False otherwise. Read-only.
Declaration
public bool IsSecondaryValueAxisAvail { get; }
Property Value
Type |
---|
System.Boolean |
IsSeriesAxisAvail
True if chart has a series axis. False otherwise. Read-only.
Declaration
public bool IsSeriesAxisAvail { get; }
Property Value
Type |
---|
System.Boolean |
IsSeriesInRows
True to swap the data in DataRange over the axis. Series data is charted on the Y axis by default.
Declaration
public bool IsSeriesInRows { get; set; }
Property Value
Type |
---|
System.Boolean |
Remarks
Data being charted on the X axis will move to the Y axis and vice versa.
IsSeriesLines
True if the chart has series lines. False otherwise. Read-only.
Declaration
public bool IsSeriesLines { get; }
Property Value
Type |
---|
System.Boolean |
IsSpecialDataLabels
True if chart needs special data labels serialization. False otherwise. Read-only.
Declaration
public bool IsSpecialDataLabels { get; }
Property Value
Type |
---|
System.Boolean |
IsStacked
True if chart is stacked. False otherwise. Read-only.
Declaration
public bool IsStacked { get; }
Property Value
Type |
---|
System.Boolean |
IsValueAxisAvail
True if chart has a value axis. False otherwise. Read-only.
Declaration
public bool IsValueAxisAvail { get; }
Property Value
Type |
---|
System.Boolean |
Legend
Gets legend in the chart. Read-only.
Declaration
public IChartLegend Legend { get; }
Property Value
Type |
---|
IChartLegend |
Remarks
This is a key that identifies patterns, colors or symbols associated with the markers of a chart data series. It shows data series name corresponding to each data marker.
Loading
Gets the parsing status of chart. Read-only.
Declaration
public bool Loading { get; }
Property Value
Type |
---|
System.Boolean |
NeedDataFormat
True if chart needs data format to be saved. False otherwise. Read-only.
Declaration
public bool NeedDataFormat { get; }
Property Value
Type |
---|
System.Boolean |
NeedDropBar
True if chart needs drop bars to be saved. False otherwise. Read-only.
Declaration
public bool NeedDropBar { get; }
Property Value
Type |
---|
System.Boolean |
NeedMarkerFormat
True if chart needs marker format to be saved. Read-only.
Declaration
public bool NeedMarkerFormat { get; }
Property Value
Type |
---|
System.Boolean |
NoPlotArea
True if chart has no plot area. False otherwise. Read-only.
Declaration
public bool NoPlotArea { get; }
Property Value
Type |
---|
System.Boolean |
PageSetup
Gets the page setup for the chart. Read-only.
Declaration
public IChartPageSetup PageSetup { get; }
Property Value
Type |
---|
IChartPageSetup |
PageSetupBase
Page setup for the chart. Read-only.
Declaration
public override PageSetupBaseImpl PageSetupBase { get; }
Property Value
Type |
---|
PageSetupBaseImpl |
Overrides
Perspective
Gets or sets the perspective for the 3D chart view (0 to 100).
Declaration
public int Perspective { get; set; }
Property Value
Type |
---|
System.Int32 |
Remarks
This property is ignored if the RightAngleAxes property is True.
PivotChartType
Gets or sets the type of the pivot chart.
Declaration
public ExcelChartType PivotChartType { get; set; }
Property Value
Type | Description |
---|---|
ExcelChartType | The type of the pivot chart. |
PivotFormatsStream
Gets or sets pivot formats stream.
Declaration
public Stream PivotFormatsStream { get; set; }
Property Value
Type |
---|
System.IO.Stream |
PivotSource
Gets or sets the pivot source.
Declaration
public IPivotTable PivotSource { get; set; }
Property Value
Type | Description |
---|---|
IPivotTable | The pivot source. |
PlotArea
Gets the plot area where the chart data is plotted. Read-only.
Declaration
public IChartFrameFormat PlotArea { get; set; }
Property Value
Type |
---|
IChartFrameFormat |
Remarks
The plot area on a 2-D chart contains the data markers, grid lines, data labels, trend lines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls and floor. The plot area is surrounded by the chart area.
PlotAreaLayout
Gets the plot area layout record. Read-only.
Declaration
public ChartPlotAreaLayoutRecord PlotAreaLayout { get; }
Property Value
Type |
---|
ChartPlotAreaLayoutRecord |
PlotVisibleOnly
True if only visible cells are plotted. False if both visible and hidden cells are plotted.
Declaration
public bool PlotVisibleOnly { get; set; }
Property Value
Type |
---|
System.Boolean |
PreservedBandFormats
Gets or sets preserved band formats for surface chart.
Declaration
public Stream PreservedBandFormats { get; set; }
Property Value
Type |
---|
System.IO.Stream |
PreservedPivotSource
Gets or sets name of the preserved pivot source stream.
Declaration
public string PreservedPivotSource { get; set; }
Property Value
Type |
---|
System.String |
PrimaryCategoryAxis
Gets the primary category axis of the chart. Read-only.
Declaration
public IChartCategoryAxis PrimaryCategoryAxis { get; }
Property Value
Type |
---|
IChartCategoryAxis |
Remarks
Charts are plotted using X and Y axes. The Y axes typically have numerical scales, whereas the X axes typically have categorical scales. Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type PrimaryCategoryAxis and vertical axis of type PrimaryValueAxis but some, like BarChart, have the opposite. PrimaryCategoryAxis represents an axis used for categories. Categories can include string, numeric, and date values.
PrimaryFormats
Gets chart format collection in primary axis.
Declaration
public ChartFormatCollection PrimaryFormats { get; }
Property Value
Type |
---|
ChartFormatCollection |
PrimaryParentAxis
Gets the primary parent axis. Read-only.
Declaration
public ChartParentAxisImpl PrimaryParentAxis { get; }
Property Value
Type |
---|
ChartParentAxisImpl |
PrimarySerieAxis
Gets the primary series axis. Read-only.
Declaration
public IChartSeriesAxis PrimarySerieAxis { get; }
Property Value
Type |
---|
IChartSeriesAxis |
Remarks
This is the depth axis showing the depth of the third dimension in 3D charts.
PrimaryValueAxis
Gets the primary value axis. Read-only.
Declaration
public IChartValueAxis PrimaryValueAxis { get; }
Property Value
Type |
---|
IChartValueAxis |
Remarks
Charts are plotted using X and Y axes. The Y axes typically have numerical scales, whereas the X axes typically have categorical scales. Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type PrimaryCategoryAxis and vertical axis of type PrimaryValueAxis but some, like BarChart, have the opposite. PrimaryValueAxis represents an axis used for series values.
ProtectDrawingObjects
True if drawing objects in the tab sheet are protected. Read-only.
Declaration
public override bool ProtectDrawingObjects { get; }
Property Value
Type |
---|
System.Boolean |
Overrides
Protection
Gets protected options. Read-only.
Declaration
public override ExcelSheetProtection Protection { get; }
Property Value
Type |
---|
ExcelSheetProtection |
Overrides
Remarks
For setting protection options use "Protect" method.
ProtectScenarios
True if the scenarios of the current sheet are protected. False otherwise. Read-only.
Declaration
public override bool ProtectScenarios { get; }
Property Value
Type |
---|
System.Boolean |
Overrides
Relations
Gets the collection of chart relations. Read-only.
Declaration
public RelationCollection Relations { get; }
Property Value
Type |
---|
RelationCollection |
RightAngleAxes
True if the chart axes are at right angles, independent of chart rotation or elevation. otherwise False.
Declaration
public bool RightAngleAxes { get; set; }
Property Value
Type |
---|
System.Boolean |
Rotation
Gets or sets the rotation of the 3D chart view (the rotation of the plot area around the z-axis, in degrees)-(0 to 360 degrees).
Declaration
public int Rotation { get; set; }
Property Value
Type |
---|
System.Int32 |
Remarks
The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.
SecondaryCategoryAxis
Gets the secondary category axis of the chart. Read-only.
Declaration
public IChartCategoryAxis SecondaryCategoryAxis { get; }
Property Value
Type |
---|
IChartCategoryAxis |
Remarks
The most commonly used charts have a set of primary axes and may have a set of secondary axes. You can enable and disable this through Visible property.
SecondaryCategoryAxisTitle
Gets or sets the title of the secondary category axis.
Declaration
public string SecondaryCategoryAxisTitle { get; set; }
Property Value
Type |
---|
System.String |
SecondaryFormats
Gets the chart format collection in secondary axis.
Declaration
public ChartFormatCollection SecondaryFormats { get; }
Property Value
Type |
---|
ChartFormatCollection |
SecondaryParentAxis
Gets the secondary parent axis. Read-only.
Declaration
public ChartParentAxisImpl SecondaryParentAxis { get; }
Property Value
Type |
---|
ChartParentAxisImpl |
SecondaryValueAxis
Gets the secondary value axis of the chart. Read-only.
Declaration
public IChartValueAxis SecondaryValueAxis { get; }
Property Value
Type |
---|
IChartValueAxis |
Remarks
The most commonly used charts have a set of primary axes and may have a set of secondary axes. You can enable and disable this through UsePrimaryAxis property.
SecondaryValueAxisTitle
Gets or sets the title of the secondary value axis.
Declaration
public string SecondaryValueAxisTitle { get; set; }
Property Value
Type |
---|
System.String |
Series
Gets the collection of series of the chart. Read-only.
Declaration
public IChartSeries Series { get; }
Property Value
Type |
---|
IChartSeries |
SeriesAxisTitle
Gets or sets the title of the series axis.
Declaration
public string SeriesAxisTitle { get; set; }
Property Value
Type |
---|
System.String |
SeriesNameLevel
Gets or sets a value referring to the source level for series names.
Declaration
public ExcelSeriesNameLevel SeriesNameLevel { get; set; }
Property Value
Type |
---|
ExcelSeriesNameLevel |
ShowAllFieldButtons
Gets or sets a boolean value indicating whether to show all field buttons on a pivot chart.
Declaration
public bool ShowAllFieldButtons { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
ShowAxisFieldButtons
Gets or sets a boolean value indicating whether to show axis field buttons on a pivot chart.
Declaration
public bool ShowAxisFieldButtons { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
ShowLegendFieldButtons
Gets or sets a boolean value indicating whether to show legend field buttons on a pivot chart.
Declaration
public bool ShowLegendFieldButtons { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
ShowPlotVisible
Gets or sets a value indicating whether to show the PlotVisibleOnly attribute.
Declaration
public bool ShowPlotVisible { get; set; }
Property Value
Type |
---|
System.Boolean |
ShowReportFilterFieldButtons
Gets or sets a boolean value indicating whether to show report filter field buttons on a pivot chart.
Declaration
public bool ShowReportFilterFieldButtons { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
ShowValueFieldButtons
Gets or sets a boolean value indicating whether to show value field buttons on a pivot chart.
Declaration
public bool ShowValueFieldButtons { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
|
SideWall
Gets the side wall of the 3D chart. Read-only.
Declaration
public IChartWallOrFloor SideWall { get; set; }
Property Value
Type |
---|
IChartWallOrFloor |
SizeWithWindow
True if the chart is resized to match the size of the chart sheet window. False if the chart size is not attached to the window size. Applies only to chart sheets.
Declaration
public bool SizeWithWindow { get; set; }
Property Value
Type |
---|
System.Boolean |
Style
Gets or sets the style index chart.
Declaration
public int Style { get; set; }
Property Value
Type |
---|
System.Int32 |
SupportWallsAndFloor
Gets a Boolean value indicating whether this chart supports walls and floor. Read-only.
Declaration
public bool SupportWallsAndFloor { get; }
Property Value
Type |
---|
System.Boolean |
TabColor
Gets or sets the chart sheet tab color.
Declaration
public override ExcelKnownColors TabColor { get; set; }
Property Value
Type |
---|
ExcelKnownColors |
Overrides
TypeChanging
True if the chart or series type is changed. False otherwise.
Declaration
public bool TypeChanging { get; set; }
Property Value
Type |
---|
System.Boolean |
ValueAxisTitle
Gets or sets the title of the value axis.
Declaration
public string ValueAxisTitle { get; set; }
Property Value
Type |
---|
System.String |
Walls
Gets the walls of the 3D chart. Read-only.
Declaration
public IChartWallOrFloor Walls { get; set; }
Property Value
Type |
---|
IChartWallOrFloor |
WallsAndGridlines2D
True if grid lines are drawn two-dimensionally on a 3-D chart. otherwise False.
Declaration
public bool WallsAndGridlines2D { get; set; }
Property Value
Type |
---|
System.Boolean |
Width
Gets or sets the width of the chart in points (1/72 inch).
Declaration
public double Width { get; set; }
Property Value
Type |
---|
System.Double |
XPos
Gets or sets the X coordinate of upper-left corner of the chart in points (1/72 inch).
Declaration
public double XPos { get; set; }
Property Value
Type |
---|
System.Double |
YPos
Gets or sets the Y coordinate of upper-left corner of the chart in points (1/72 inch).
Declaration
public double YPos { get; set; }
Property Value
Type |
---|
System.Double |
ZoomToFit
Gets or sets a Bolean value indicating whether chart sheet is zoom to fit window.
Declaration
public bool ZoomToFit { get; set; }
Property Value
Type |
---|
System.Boolean |
Methods
ChangePrimaryAxis(Boolean)
Changes primary axis of the chart to secondary.
Declaration
public void ChangePrimaryAxis(bool isParsing)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | isParsing | If parsing - true; Otherwise false. |
CheckDataTablePossibility(String, Boolean)
Checks whether data table is compatible with specified start type.
Declaration
public static bool CheckDataTablePossibility(string startType, bool bThrowException)
Parameters
Type | Name | Description |
---|---|---|
System.String | startType | Start type of the chart. |
System.Boolean | bThrowException | Boolean value indicating whether to throw exception. |
Returns
Type | Description |
---|---|
System.Boolean | True if data table is compatible with specified start type. False otherwise. |
Exceptions
Type | Condition |
---|---|
System.NotSupportedException | When the chart type is not supported by the data table. |
CheckForSupportGridLine()
Checks for existing gridlines in chart.
Declaration
public bool CheckForSupportGridLine()
Returns
Type | Description |
---|---|
System.Boolean | Returns true if gridlines exist; Otherwise false. |
Clone(Dictionary<String, String>, Object, Dictionary<Int32, Int32>)
Creates a copy of the current instance with the specified dictionary of worksheet names.
Declaration
public ChartImpl Clone(Dictionary<string, string> hashNewNames, object parent, Dictionary<int, int> dicFontIndexes)
Parameters
Type | Name | Description |
---|---|---|
System.Collections.Generic.Dictionary<System.String, System.String> | hashNewNames | Hash table with new Worksheet names. |
System.Object | parent | Parent object. |
System.Collections.Generic.Dictionary<System.Int32, System.Int32> | dicFontIndexes | Dictionary with new font indexes. |
Returns
Type | Description |
---|---|
ChartImpl | Cloned object which is a copy of the current object. |
Clone(Object)
Creates a copy of current instance.
Declaration
public override object Clone(object parent)
Parameters
Type | Name | Description |
---|---|---|
System.Object | parent | Parent object. |
Returns
Type | Description |
---|---|
System.Object | Returns clone of current object. |
Overrides
CreateNecessaryAxes(Boolean)
Creates necessary primary axes.
Declaration
public void CreateNecessaryAxes(bool bPrimary)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean | bPrimary | Value indicating whether axis is primary. |
DetectChartType()
Detects the type of the chart.
Declaration
public void DetectChartType()
Exceptions
Type | Condition |
---|---|
System.ArgumentOutOfRangeException | When it is not possible to detect chart type. |
DetectIsInRowOnParsing()
Detects if series in rows.
Declaration
public void DetectIsInRowOnParsing()
DoubleToFixedPoint(Double)
Converts the specified double value into 32-bits fixed-point value.
Declaration
public static int DoubleToFixedPoint(double value)
Parameters
Type | Name | Description |
---|---|---|
System.Double | value | Value to convert. |
Returns
Type | Description |
---|---|
System.Int32 | Converted 32-bits fixed-point value. |
FixedPointToDouble(Int32)
Converts the specified 32-bits fixed-point value into double.
Declaration
public static double FixedPointToDouble(int value)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | value | Value to convert. |
Returns
Type | Description |
---|---|
System.Double | Converted double value. |
GetCategoryRange(IRange, out IRange, Int32, Boolean)
Finds the category range in the specified chart range.
Declaration
public static IRange GetCategoryRange(IRange Chartvalues, out IRange values, int count, bool bIsInRow)
Parameters
Type | Name | Description |
---|---|---|
IRange | Chartvalues | Range of chart values. |
IRange | values | Outputted category range values. |
System.Int32 | count | Chart values count. |
System.Boolean | bIsInRow | Boolean value indicating if series is in row. |
Returns
Type | Description |
---|---|
IRange | Category range in the specified chart range. |
GetIs100(ExcelChartType)
Determines if the chart is 100% in view.
Declaration
public static bool GetIs100(ExcelChartType chartType)
Parameters
Type | Name | Description |
---|---|---|
ExcelChartType | chartType | The type of the chart. |
Returns
Type | Description |
---|---|
System.Boolean | True if the chart is 100%. False otherwise. |
GetIsChartPie(ExcelChartType)
Determines whether specified chart type is pie chart.
Declaration
public static bool GetIsChartPie(ExcelChartType chartType)
Parameters
Type | Name | Description |
---|---|---|
ExcelChartType | chartType | The chart type to check. |
Returns
Type | Description |
---|---|
System.Boolean | Value indicating whether specified chart type is pie chart. |
GetIsClustered(ExcelChartType)
Determines if the specified chart type is clustered chart.
Declaration
public static bool GetIsClustered(ExcelChartType chartType)
Parameters
Type | Name | Description |
---|---|---|
ExcelChartType | chartType | The chart type to check. |
Returns
Type | Description |
---|---|
System.Boolean | True if teh chart type is clustered. False otherwise. |
GetIsStacked(ExcelChartType)
Determines if the specified chart type is stacked.
Declaration
public static bool GetIsStacked(ExcelChartType chartType)
Parameters
Type | Name | Description |
---|---|---|
ExcelChartType | chartType | The chart type to check. |
Returns
Type | Description |
---|---|
System.Boolean | True if the chart is clustered chart. False otherwise. |
GetSerieOrAxisRange(IRange, Boolean, out IRange)
Gets data range that represents series name or category axis.
Declaration
public IRange GetSerieOrAxisRange(IRange range, bool bIsInRow, out IRange serieRange)
Parameters
Type | Name | Description |
---|---|---|
IRange | range | Represents data range. |
System.Boolean | bIsInRow | Represents if series in row. |
IRange | serieRange | Represents range that contain series value range. |
Returns
Type | Description |
---|---|
IRange | Returns series name or category axis range, if possible; otherwise null. |
InitializeCollections()
Initializes all internal collections.
Declaration
protected override void InitializeCollections()
Overrides
MarkUsedReferences(Boolean[])
Sets items with used reference indexes to true.
Declaration
public override void MarkUsedReferences(bool[] usedItems)
Parameters
Type | Name | Description |
---|---|---|
System.Boolean[] | usedItems | Array to mark used references in. |
Overrides
Parse()
Parses internal records.
Declaration
public override void Parse()
Overrides
ParseData(Dictionary<Int32, Int32>)
Parses object's records.
Declaration
protected override void ParseData(Dictionary<int, int> dictUpdatedSSTIndexes)
Parameters
Type | Name | Description |
---|---|---|
System.Collections.Generic.Dictionary<System.Int32, System.Int32> | dictUpdatedSSTIndexes |
Overrides
ParseLegend(IList<BiffRecordRaw>, ref Int32)
Parses the legend in the chart.
Declaration
public void ParseLegend(IList<BiffRecordRaw> data, ref int iPos)
Parameters
Type | Name | Description |
---|---|---|
System.Collections.Generic.IList<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw> | data | Record storage. |
System.Int32 | iPos | Position in storage. |
PrepareProtectionOptions(ExcelSheetProtection)
Prepares protection options before setting protection.
Declaration
protected override ExcelSheetProtection PrepareProtectionOptions(ExcelSheetProtection options)
Parameters
Type | Name | Description |
---|---|---|
ExcelSheetProtection | options |
Returns
Type |
---|
ExcelSheetProtection |
Overrides
RemoveFormat(IChartFormat)
Removes the specified chart format.
Declaration
public void RemoveFormat(IChartFormat formatToRemove)
Parameters
Type | Name | Description |
---|---|---|
IChartFormat | formatToRemove | Format to remove. |
SaveAsImage(Stream)
Converts the chart to image stream.
Declaration
public void SaveAsImage(Stream imageAsstream)
Parameters
Type | Name | Description |
---|---|---|
System.IO.Stream | imageAsstream |
Serialize(OffsetArrayList)
Saves chart into OffsetArrayList.
Declaration
public override void Serialize(OffsetArrayList records)
Parameters
Type | Name | Description |
---|---|---|
OffsetArrayList | records | OffsetArrayList that will receive all chart's records. |
Overrides
Exceptions
Type | Condition |
---|---|
System.ArgumentNullException | When specified OffsetArrayList is NULL. |
SerializeFloor(OffsetArrayList)
Serialize the chart's floor.
Declaration
public void SerializeFloor(OffsetArrayList records)
Parameters
Type | Name | Description |
---|---|---|
OffsetArrayList | records | Records collection. |
SerializeLegend(OffsetArrayList)
Serialize the chart's legend.
Declaration
public void SerializeLegend(OffsetArrayList records)
Parameters
Type | Name | Description |
---|---|---|
OffsetArrayList | records | Represents record list to serialize into. |
SerializePlotArea(OffsetArrayList)
Serialize plot area to stg stream.
Declaration
public void SerializePlotArea(OffsetArrayList records)
Parameters
Type | Name | Description |
---|---|---|
OffsetArrayList | records | Represents record storage. |
SerializeWalls(OffsetArrayList)
Serialize chart walls.
Declaration
public void SerializeWalls(OffsetArrayList records)
Parameters
Type | Name | Description |
---|---|---|
OffsetArrayList | records | Records collection. |
SetToDefaultGridlines(ExcelChartType)
Sets default chart grid lines on chart type or series type changing.
Declaration
public void SetToDefaultGridlines(ExcelChartType type)
Parameters
Type | Name | Description |
---|---|---|
ExcelChartType | type | Represents chart type to change. |
UpdateCategory(ChartSeriesCollection, Boolean)
Updates chart categories from the specified series collection.
Declaration
public void UpdateCategory(ChartSeriesCollection series, bool fromDataRange)
Parameters
Type | Name | Description |
---|---|---|
ChartSeriesCollection | series | Series collection. |
System.Boolean | fromDataRange | Boolean value indicating if the chart is from data range. |
UpdateChartFbiIndexes(IDictionary)
Updates scalable font indexes in the chart sheet.
Declaration
public void UpdateChartFbiIndexes(IDictionary dicFontIndexes)
Parameters
Type | Name | Description |
---|---|---|
System.Collections.IDictionary | dicFontIndexes | Dictionary with new indexes. |
UpdateChartFontXIndexes(IDictionary)
Updates font indexes in the chart sheet.
Declaration
public void UpdateChartFontXIndexes(IDictionary dicFontIndexes)
Parameters
Type | Name | Description |
---|---|---|
System.Collections.IDictionary | dicFontIndexes | Dictionary with new indexes. |
UpdateChartTitle()
Updates chart title on chart creation.
Declaration
public void UpdateChartTitle()
UpdateFormula(Int32, Int32, Rectangle, Int32, Rectangle)
Updates formulas after copy operation.
Declaration
public override void UpdateFormula(int iCurIndex, int iSourceIndex, Rectangle sourceRect, int iDestIndex, Rectangle destRect)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | iCurIndex | Current worksheet index. |
System.Int32 | iSourceIndex | Source worksheet index. |
Rectangle | sourceRect | Source rectangle. |
System.Int32 | iDestIndex | Destination worksheet index. |
Rectangle | destRect | Destination rectangle. |
Overrides
UpdateReferenceIndexes(Int32[])
Updates reference indexes.
Declaration
public override void UpdateReferenceIndexes(int[] arrUpdatedIndexes)
Parameters
Type | Name | Description |
---|---|---|
System.Int32[] | arrUpdatedIndexes | Array with updated indexes. |
Overrides
UpdateSeries(ChartSeriesCollection)
Updates series filter from the specified series collection.
Declaration
public void UpdateSeries(ChartSeriesCollection series)
Parameters
Type | Name | Description |
---|---|---|
ChartSeriesCollection | series | Series collection. |