Represents Microsoft Excel DataLabels collection. More...

#include <wxAutoExcelDataLabels.h>

Inheritance diagram for wxAutoExcel::wxExcelDataLabels:

Public Member Functions
bool	Delete ()
	Deletes the object.

wxExcelDataLabel	Item (long index)
	Returns a single object from a collection.

void	Propagate (long index)
	Enables to take the contents and formatting of a single data label and apply it to every other data label in the series.

bool	Select ()
	Selects the object.

bool	GetAutoScaleFont ()
	True if the text in the object changes font size when the object size changes.

void	SetAutoScaleFont (bool autoScaleFont)
	True if the text in the object changes font size when the object size changes.

bool	GetAutoText ()
	True if the object automatically generates appropriate text based on context.

void	SetAutoText (bool autoText)
	True if the object automatically generates appropriate text based on context.

long	GetCount ()
	Returns a Long value that represents the number of objects in the collection.

wxExcelChartFormat	GetFormat ()
	Returns the ChartFormat object.

long	GetHorizontalAlignment ()
	Returns a Variant value that represents the horizontal alignment for the specified object.

void	SetHorizontalAlignment (long horizontalAlignment)
	Sets a Variant value that represents the horizontal alignment for the specified object.

wxString	GetName ()
	Returns a String value that represents the name of the object.

wxString	GetNumberFormat ()
	Returns a String value that represents the format code for the object.

void	SetNumberFormat (const wxString &numberFormat)
	Sets a String value that represents the format code for the object.

bool	GetNumberFormatLinked ()
	True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

void	SetNumberFormatLinked (bool numberFormatLinked)
	True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

wxString	GetNumberFormatLocal ()
	Returns a Variant value that represents the format code for the object as a string in the language of the user.

void	SetNumberFormatLocal (const wxString &numberFormatLocal)
	Sets a Variant value that represents the format code for the object as a string in the language of the user.

long	GetOrientation ()
	Returns a Variant value that represents the text orientation.

void	SetOrientation (long orientation)
	Sets a Variant value that represents the text orientation.

XlDataLabelPosition	GetPosition ()
	Returns a XlDataLabelPosition value that represents the position of the data label.

void	SetPosition (XlDataLabelPosition position)
	Sets a XlDataLabelPosition value that represents the position of the data label.

long	GetReadingOrder ()
	Returns the reading order for the specified object.

void	SetReadingOrder (long readingOrder)
	Sets the reading order for the specified object.

wxString	GetSeparator ()
	Returns a Variant representing the separator used for the data labels on a chart.

void	SetSeparator (const wxString &separator)
	Sets a Variant representing the separator used for the data labels on a chart.

bool	GetShadow ()
	Returns a Boolean value that determines if the object has a shadow.

void	SetShadow (bool shadow)
	Sets a Boolean value that determines if the object has a shadow.

bool	GetShowBubbleSize ()
	True to show the bubble size for the data labels on a chart.

void	SetShowBubbleSize (bool showBubbleSize)
	True to show the bubble size for the data labels on a chart.

bool	GetShowCategoryName ()
	True to display the category name for the data labels on a chart.

void	SetShowCategoryName (bool showCategoryName)
	True to display the category name for the data labels on a chart.

bool	GetShowLegendKey ()
	True if the data label legend key is visible.

void	SetShowLegendKey (bool showLegendKey)
	True if the data label legend key is visible.

bool	GetShowPercentage ()
	True to display the percentage value for the data labels on a chart.

void	SetShowPercentage (bool showPercentage)
	True to display the percentage value for the data labels on a chart.

bool	GetShowRange ()
	Toggles the Range field if it exists on the data label range.

void	SetShowRange (bool showRange)
	Toggles the Range field if it exists on the data label range.

bool	GetShowSeriesName ()
	Returns a Boolean to indicate the series name display behavior for the data labels on a chart.

void	SetShowSeriesName (bool showSeriesName)
	Sets a Boolean to indicate the series name display behavior for the data labels on a chart.

bool	GetShowValue ()
	Returns a Boolean corresponding to a specified chart's data label values display behavior.

void	SetShowValue (bool showValue)
	Sets a Boolean corresponding to a specified chart's data label values display behavior.

long	GetVerticalAlignment ()
	Returns a Variant value that represents the vertical alignment of the specified object.

void	SetVerticalAlignment (long verticalAlignment)
	Sets a Variant value that represents the vertical alignment of the specified object.

virtual wxString	GetAutoExcelObjectName_ () const
	Returns "DataLabels".

Public Member Functions inherited from wxAutoExcel::wxExcelObject
bool	IsOk_ () const
	Returns true if the object has a valid dispatch.

wxString	GetAutomationObjectName_ (bool stripUnderscores=false) const
	Returns object name as provided by IDispatch->GetTypeInfo()->GetDocumentation(MEMBERID_NIL, &name, NULL, NULL, NULL).

wxSharedPtr< wxAutomationObject >	GetAutomationObject_ ()
	Returns the underlying wxAutomationObject.

	operator bool () const
	Returns true if the object has a valid dispatch and its last automation call (if any), i.e.

WXLCID	GetAutomationLCID_ () const
	Returns the locale identifier used in automation calls.

bool	SetAutomationLCID_ (WXLCID lcid)
	Sets the locale identifier to be used in automation calls.

bool	GetPropertyAndMethodNames_ (wxArrayString &propertyNames, wxArrayString &methodNames, bool includeHidden=false)
	Returns lists of property and method names the automation interface exposes.

bool	GetUnimplementedObject_ (const wxString &name, wxAutomationObject &object)
	Helper function for receiving an automation object not implemented in wxAutoExcel, see FAQ on how to use.

Additional Inherited Members
Public Types inherited from wxAutoExcel::wxExcelObject
enum	ErrorFlags { Err_DoNothing = 0 , Err_LogOnInvalidDispatch = 1 , Err_AssertOnInvalidDispatch = 1 << 1 , Err_ThrowOnInvalidDispatch = 1 << 2 , Err_LogOnInvalidArgument = 1 << 3 , Err_AssertOnInvalidArgument = 1 << 4 , Err_ThrowOnInvalidArgument = 1 << 5 , Err_LogOnFailedInvoke = 1 << 6 , Err_AssertOnFailedInvoke = 1 << 7 , Err_ThrowOnFailedInvoke = 1 << 8 , Err_LogOnInvalidReturnType = 1 << 9 , Err_AssertOnInvalidReturnType = 1 << 10 , Err_ThrowOnInvalidReturnType = 1 << 11 , Err_LogOnOtherError = 1 << 12 , Err_AssertOnOtherError = 1 << 13 , Err_ThrowOnOtherError = 1 << 14 }
	Flags affecting the behaviour of wxExcelObject and its descendants when an error occurs during accessing an Excel object property or calling its method. More...

Static Public Member Functions inherited from wxAutoExcel::wxExcelObject
static unsigned	GetErrorMode_ ()
	Sets the error mode to the combination of wxExcelObject::ErrorFlags.

static void	SetErrorMode_ (unsigned mode)
	Sets the error mode as the combination of wxExcelObject::ErrorFlags.

static bool	GetUnimplementedCollectionItem_ (wxAutomationObject &collection, const long index, wxAutomationObject &item, bool asProperty)
	Helper function for obtaining an item from MS Excel collection not implemented in wxAutoExcel, see FAQ on how to use.

Detailed Description

Represents Microsoft Excel DataLabels collection.

Member Function Documentation

◆ Delete()

bool wxAutoExcel::wxExcelDataLabels::Delete ( )

Deletes the object.

MSDN documentation for DataLabels.Delete.

◆ Item()

wxExcelDataLabel wxAutoExcel::wxExcelDataLabels::Item ( long index )

Returns a single object from a collection.

MSDN documentation for DataLabels.Item.

◆ Propagate()

void wxAutoExcel::wxExcelDataLabels::Propagate ( long index )

Enables to take the contents and formatting of a single data label and apply it to every other data label in the series.

Excel VBA documentation for DataLabels.Propagate

◆ Select()

bool wxAutoExcel::wxExcelDataLabels::Select ( )

Selects the object.

[MSDN documentation for DataLabels.Select]().

◆ GetAutoScaleFont()

bool wxAutoExcel::wxExcelDataLabels::GetAutoScaleFont ( )

True if the text in the object changes font size when the object size changes.

The default value is True. Read/write Variant.

MSDN documentation for DataLabels.AutoScaleFont.

◆ SetAutoScaleFont()

void wxAutoExcel::wxExcelDataLabels::SetAutoScaleFont ( bool autoScaleFont )

True if the text in the object changes font size when the object size changes.

The default value is True. Read/write Variant.

MSDN documentation for DataLabels.AutoScaleFont.

◆ GetAutoText()

bool wxAutoExcel::wxExcelDataLabels::GetAutoText ( )

True if the object automatically generates appropriate text based on context.

MSDN documentation for DataLabels.AutoText.

◆ SetAutoText()

void wxAutoExcel::wxExcelDataLabels::SetAutoText ( bool autoText )

True if the object automatically generates appropriate text based on context.

MSDN documentation for DataLabels.AutoText.

◆ GetCount()

long wxAutoExcel::wxExcelDataLabels::GetCount ( )

Returns a Long value that represents the number of objects in the collection.

MSDN documentation for DataLabels.Count.

◆ GetFormat()

wxExcelChartFormat wxAutoExcel::wxExcelDataLabels::GetFormat ( )

Returns the ChartFormat object.

Since Excel 2007.

MSDN documentation for DataLabels.Format.

◆ GetHorizontalAlignment()

long wxAutoExcel::wxExcelDataLabels::GetHorizontalAlignment ( )

Returns a Variant value that represents the horizontal alignment for the specified object.

MSDN documentation for DataLabels.HorizontalAlignment.

◆ SetHorizontalAlignment()

void wxAutoExcel::wxExcelDataLabels::SetHorizontalAlignment ( long horizontalAlignment )

Sets a Variant value that represents the horizontal alignment for the specified object.

MSDN documentation for DataLabels.HorizontalAlignment.

◆ GetName()

wxString wxAutoExcel::wxExcelDataLabels::GetName ( )

Returns a String value that represents the name of the object.

MSDN documentation for DataLabels.Name.

◆ GetNumberFormat()

wxString wxAutoExcel::wxExcelDataLabels::GetNumberFormat ( )

Returns a String value that represents the format code for the object.

MSDN documentation for DataLabels.NumberFormat.

◆ SetNumberFormat()

void wxAutoExcel::wxExcelDataLabels::SetNumberFormat ( const wxString & numberFormat )

Sets a String value that represents the format code for the object.

MSDN documentation for DataLabels.NumberFormat.

◆ GetNumberFormatLinked()

bool wxAutoExcel::wxExcelDataLabels::GetNumberFormatLinked ( )

True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

MSDN documentation for DataLabels.NumberFormatLinked.

◆ SetNumberFormatLinked()

void wxAutoExcel::wxExcelDataLabels::SetNumberFormatLinked ( bool numberFormatLinked )

True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

MSDN documentation for DataLabels.NumberFormatLinked.

◆ GetNumberFormatLocal()

wxString wxAutoExcel::wxExcelDataLabels::GetNumberFormatLocal ( )

Returns a Variant value that represents the format code for the object as a string in the language of the user.

MSDN documentation for DataLabels.NumberFormatLocal.

◆ SetNumberFormatLocal()

void wxAutoExcel::wxExcelDataLabels::SetNumberFormatLocal ( const wxString & numberFormatLocal )

Sets a Variant value that represents the format code for the object as a string in the language of the user.

MSDN documentation for DataLabels.NumberFormatLocal.

◆ GetOrientation()

long wxAutoExcel::wxExcelDataLabels::GetOrientation ( )

Returns a Variant value that represents the text orientation.

MSDN documentation for DataLabels.Orientation.

◆ SetOrientation()

void wxAutoExcel::wxExcelDataLabels::SetOrientation ( long orientation )

Sets a Variant value that represents the text orientation.

MSDN documentation for DataLabels.Orientation.

◆ GetPosition()

XlDataLabelPosition wxAutoExcel::wxExcelDataLabels::GetPosition ( )

Returns a XlDataLabelPosition value that represents the position of the data label.

MSDN documentation for DataLabels.Position.

◆ SetPosition()

void wxAutoExcel::wxExcelDataLabels::SetPosition ( XlDataLabelPosition position )

Sets a XlDataLabelPosition value that represents the position of the data label.

MSDN documentation for DataLabels.Position.

◆ GetReadingOrder()

long wxAutoExcel::wxExcelDataLabels::GetReadingOrder ( )

Returns the reading order for the specified object.

Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.

MSDN documentation for DataLabels.ReadingOrder.

◆ SetReadingOrder()

void wxAutoExcel::wxExcelDataLabels::SetReadingOrder ( long readingOrder )

Sets the reading order for the specified object.

Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.

MSDN documentation for DataLabels.ReadingOrder.

◆ GetSeparator()

wxString wxAutoExcel::wxExcelDataLabels::GetSeparator ( )

Returns a Variant representing the separator used for the data labels on a chart.

MSDN documentation for DataLabels.Separator.

◆ SetSeparator()

void wxAutoExcel::wxExcelDataLabels::SetSeparator ( const wxString & separator )

Sets a Variant representing the separator used for the data labels on a chart.

MSDN documentation for DataLabels.Separator.

◆ GetShadow()

bool wxAutoExcel::wxExcelDataLabels::GetShadow ( )

Returns a Boolean value that determines if the object has a shadow.

MSDN documentation for DataLabels.Shadow.

◆ SetShadow()

void wxAutoExcel::wxExcelDataLabels::SetShadow ( bool shadow )

Sets a Boolean value that determines if the object has a shadow.

MSDN documentation for DataLabels.Shadow.

◆ GetShowBubbleSize()

bool wxAutoExcel::wxExcelDataLabels::GetShowBubbleSize ( )

True to show the bubble size for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowBubbleSize.

◆ SetShowBubbleSize()

void wxAutoExcel::wxExcelDataLabels::SetShowBubbleSize ( bool showBubbleSize )

True to show the bubble size for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowBubbleSize.

◆ GetShowCategoryName()

bool wxAutoExcel::wxExcelDataLabels::GetShowCategoryName ( )

True to display the category name for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowCategoryName.

◆ SetShowCategoryName()

void wxAutoExcel::wxExcelDataLabels::SetShowCategoryName ( bool showCategoryName )

True to display the category name for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowCategoryName.

◆ GetShowLegendKey()

bool wxAutoExcel::wxExcelDataLabels::GetShowLegendKey ( )

True if the data label legend key is visible.

MSDN documentation for DataLabels.ShowLegendKey.

◆ SetShowLegendKey()

void wxAutoExcel::wxExcelDataLabels::SetShowLegendKey ( bool showLegendKey )

True if the data label legend key is visible.

MSDN documentation for DataLabels.ShowLegendKey.

◆ GetShowPercentage()

bool wxAutoExcel::wxExcelDataLabels::GetShowPercentage ( )

True to display the percentage value for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowPercentage.

◆ SetShowPercentage()

void wxAutoExcel::wxExcelDataLabels::SetShowPercentage ( bool showPercentage )

True to display the percentage value for the data labels on a chart.

False to hide.

MSDN documentation for DataLabels.ShowPercentage.

◆ GetShowRange()

bool wxAutoExcel::wxExcelDataLabels::GetShowRange ( )

Toggles the Range field if it exists on the data label range.

Excel VBA documentation for DataLabels.ShowRange

◆ SetShowRange()

void wxAutoExcel::wxExcelDataLabels::SetShowRange ( bool showRange )

Toggles the Range field if it exists on the data label range.

Excel VBA documentation for DataLabels.ShowRange

◆ GetShowSeriesName()

bool wxAutoExcel::wxExcelDataLabels::GetShowSeriesName ( )

Returns a Boolean to indicate the series name display behavior for the data labels on a chart.

True to show the series name. False to hide.

MSDN documentation for DataLabels.ShowSeriesName.

◆ SetShowSeriesName()

void wxAutoExcel::wxExcelDataLabels::SetShowSeriesName ( bool showSeriesName )

Sets a Boolean to indicate the series name display behavior for the data labels on a chart.

True to show the series name. False to hide.

MSDN documentation for DataLabels.ShowSeriesName.

◆ GetShowValue()

bool wxAutoExcel::wxExcelDataLabels::GetShowValue ( )

Returns a Boolean corresponding to a specified chart's data label values display behavior.

True displays the values. False to hide.

MSDN documentation for DataLabels.ShowValue.

◆ SetShowValue()

void wxAutoExcel::wxExcelDataLabels::SetShowValue ( bool showValue )

Sets a Boolean corresponding to a specified chart's data label values display behavior.

True displays the values. False to hide.

MSDN documentation for DataLabels.ShowValue.

◆ GetVerticalAlignment()

long wxAutoExcel::wxExcelDataLabels::GetVerticalAlignment ( )

Returns a Variant value that represents the vertical alignment of the specified object.

MSDN documentation for DataLabels.VerticalAlignment.

◆ SetVerticalAlignment()

void wxAutoExcel::wxExcelDataLabels::SetVerticalAlignment ( long verticalAlignment )

Sets a Variant value that represents the vertical alignment of the specified object.

MSDN documentation for DataLabels.VerticalAlignment.

◆ GetAutoExcelObjectName_()

virtual wxString wxAutoExcel::wxExcelDataLabels::GetAutoExcelObjectName_ ( ) const

inlinevirtual

Returns "DataLabels".

Reimplemented from wxAutoExcel::wxExcelObject.

Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ Delete()

◆ Item()

◆ Propagate()

◆ Select()

◆ GetAutoScaleFont()

◆ SetAutoScaleFont()

◆ GetAutoText()

◆ SetAutoText()

◆ GetCount()

◆ GetFormat()

◆ GetHorizontalAlignment()

◆ SetHorizontalAlignment()

◆ GetName()

◆ GetNumberFormat()

◆ SetNumberFormat()

◆ GetNumberFormatLinked()

◆ SetNumberFormatLinked()

◆ GetNumberFormatLocal()

◆ SetNumberFormatLocal()

◆ GetOrientation()

◆ SetOrientation()

◆ GetPosition()

◆ SetPosition()

◆ GetReadingOrder()

◆ SetReadingOrder()

◆ GetSeparator()

◆ SetSeparator()

◆ GetShadow()

◆ SetShadow()

◆ GetShowBubbleSize()

◆ SetShowBubbleSize()

◆ GetShowCategoryName()

◆ SetShowCategoryName()

◆ GetShowLegendKey()

◆ SetShowLegendKey()

◆ GetShowPercentage()

◆ SetShowPercentage()

◆ GetShowRange()

◆ SetShowRange()

◆ GetShowSeriesName()

◆ SetShowSeriesName()

◆ GetShowValue()

◆ SetShowValue()

◆ GetVerticalAlignment()

◆ SetVerticalAlignment()

◆ GetAutoExcelObjectName_()