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

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

WorksheetBaseImpl.DefaultProtectionOptions

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	`true` if this instance is 3D pivot chart; `false` otherwise. Read-only.

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

WorksheetBaseImpl.PageSetupBase

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

WorksheetBaseImpl.ProtectDrawingObjects

Protection

Gets protected options. Read-only.

Declaration

public override ExcelSheetProtection Protection { get; }

Property Value

Type
ExcelSheetProtection

Overrides

WorksheetBaseImpl.Protection

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

WorksheetBaseImpl.ProtectScenarios

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	`true` to show all field buttons; `false` otherwise.

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	`true` to show axis field buttons; `false` otherwise.

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	`true` to show legend field buttons; `false` otherwise.

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	`true` to show report filter field buttons; `false` otherwise.

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	`true` to show value field buttons; `false` otherwise.

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

WorksheetBaseImpl.TabColor

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

WorksheetBaseImpl.Clone(Object)

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

WorksheetBaseImpl.InitializeCollections()

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

WorksheetBaseImpl.MarkUsedReferences(Boolean[])

Parse()

Parses internal records.

Declaration

public override void Parse()

Overrides

WorksheetBaseImpl.Parse()

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

WorksheetBaseImpl.ParseData(Dictionary<Int32, Int32>)

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

WorksheetBaseImpl.PrepareProtectionOptions(ExcelSheetProtection)

RemoveFormat(IChartFormat)

Removes the specified chart format.

Declaration

public void RemoveFormat(IChartFormat formatToRemove)

Parameters

Type	Name	Description
IChartFormat	formatToRemove	Format to remove.

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

WorksheetBaseImpl.Serialize(OffsetArrayList)

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

WorksheetBaseImpl.UpdateFormula(Int32, Int32, Rectangle, Int32, Rectangle)

UpdateReferenceIndexes(Int32[])

Updates reference indexes.

Declaration

public override void UpdateReferenceIndexes(int[] arrUpdatedIndexes)

Parameters

Type	Name	Description
System.Int32[]	arrUpdatedIndexes	Array with updated indexes.

Overrides

WorksheetBaseImpl.UpdateReferenceIndexes(Int32[])

UpdateSeries(ChartSeriesCollection)

Updates series filter from the specified series collection.

Declaration

public void UpdateSeries(ChartSeriesCollection series)

Parameters

Type	Name	Description
ChartSeriesCollection	series	Series collection.

Implements

System.IDisposable

IChart

ITabSheet

IParentApplication

ISerializableNamedObject

INamedObject

IParseable

ICloneParent

Extension Methods

DateTimeExtension.ToDateTime(Object)