Aspose::Slides::Charts::ChartDataCell Class Reference

Represents cell for chart data. More...

Inherits Aspose::Slides::Charts::IChartDataCell.

Public Member Functions

int32_t get_Row ()
 Returns the index of the row of worksheet in which the cell is located. Read-only int32_t. More...
 
int32_t get_Column ()
 Returns the index of the column of worksheet in which the cell is located. Read-only int32_t. More...
 
System::SharedPtr< System::Objectget_Value ()
 Gets the value. Read object. More...
 
void set_Value (System::SharedPtr< System::Object > value)
 Sets the value. Write object. More...
 
System::String get_Formula ()
 Gets the formula in A1-style. More...
 
void set_Formula (System::String value)
 Sets the formula in A1-style. More...
 
System::String get_R1C1Formula ()
 Gets the formula in R1C1-style. More...
 
void set_R1C1Formula (System::String value)
 Sets the formula in R1C1-style. More...
 
System::SharedPtr< IChartDataWorksheetget_ChartDataWorksheet ()
 Gets the worksheet. Read-only IChartDataWorksheet. More...
 
bool get_IsHidden ()
 Determines whether the cell is hidden. Read-only bool. More...
 
System::String get_CustomNumberFormat ()
 Gets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read System::String. More...
 
void set_CustomNumberFormat (System::String value)
 Sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Write System::String. More...
 
uint8_t get_PresetNumberFormat ()
 Gets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Read <see cref="uint8_t">. More...
 
void set_PresetNumberFormat (uint8_t value)
 Sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Write <see cref="uint8_t">. More...
 
- Public Member Functions inherited from System::Object
 Object ()
 Creates object. Initializes all internal data structures. More...
 
virtual ~Object ()
 Destroys object. Frees all internal data structures. More...
 
 Object (Object const &x)
 Copy constructor. Doesn't copy anything, really, just initializes new object and enables copy constructing subclasses. More...
 
Objectoperator= (Object const &x)
 Assignment operator. Doesn't copy anything, really, just initializes new object and enables copy constructing subclasses. More...
 
ObjectSharedRefAdded ()
 Increments shared reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
int SharedRefRemovedSafe ()
 Decrements and returns shared reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
int RemovedSharedRefs (int count)
 Decreases shared reference count by specified value. More...
 
Detail::SmartPtrCounter * WeakRefAdded ()
 Increments weak reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
void WeakRefRemoved ()
 Decrements weak reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
Detail::SmartPtrCounter * GetCounter ()
 Gets reference counter data structure associated with the object. More...
 
int SharedCount () const
 Gets current value of shared refernce counter. More...
 
void Lock ()
 Implements C# lock() statement locking. Call directly or use LockContext sentry object. More...
 
void Unlock ()
 Implements C# lock() statement unlocking. Call directly or use LockContext sentry object. More...
 
virtual bool Equals (ptr obj)
 Compares objects using C# Object.Equals semantics. More...
 
virtual int GetHashCode () const
 Analog of C# Object.GetHashCode() method. Enables hashing of custom objects. More...
 
virtual String ToString () const
 Analog of C# Object.ToString() method. Enables converting custom objects to string. More...
 
virtual ptr MemberwiseClone () const
 Analog of C# Object.MemberwiseClone() method. Enables cloning custom types. More...
 
virtual const TypeInfoGetType () const
 Gets actual type of object. Analog of C# System.Object.GetType() call. More...
 
virtual bool Is (const TypeInfo &targetType) const
 Check if object represents an instance of type described by targetType. Analog of C# 'is' operator. More...
 
virtual void SetTemplateWeakPtr (unsigned int argument)
 Set n'th template argument a weak pointer (rather than shared). Allows switching pointers in containers to weak mode. More...
 
template<>
bool Equals (float const &objA, float const &objB)
 
template<>
bool Equals (double const &objA, double const &objB)
 
template<>
bool ReferenceEquals (String const &str, std::nullptr_t)
 
template<>
bool ReferenceEquals (String const &str1, String const &str2)
 

Protected Member Functions

Aspose::Slides::PptxSerialization::PartParser::XmlParser::CellType get_Type ()
 
System::SharedPtr< Aspose::Slides::Charts::ChartDataWorksheetget_ParentWorksheetInternal ()
 
System::SharedPtr< ChartDataWorkbookget_ParentWorkbook ()
 
bool get_HasDefaultNumberFormat ()
 
System::String get_Name ()
 
void set_Name (System::String value)
 
int32_t get_IntValue ()
 
System::String get_StringValue ()
 
System::SharedPtr< Aspose::Slides::Xlsx::XlsxCellFormat > get_Format ()
 
System::SharedPtr< SpreadsheetCellAdapter > get_Adapter () const
 
 ChartDataCell (System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection > parent)
 
 ChartDataCell (System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection > parent, System::String name)
 
void PutValue (double value)
 
void PutValue (int32_t value)
 
void PutValue (System::String value)
 
void PutValue (System::SharedPtr< System::Object > value)
 
void PutA1Formula (System::String formula)
 
void PutR1C1Formula (System::String formula)
 
System::String GetEffectiveFormatCode (bool cultureDependent)
 Gets effective format code of the cell. More...
 
int32_t GetCellFormatIdx ()
 Gets index of cell format in parent workbook formats collection. More...
 
System::SharedPtr< Aspose::Slides::Xlsx::NumberFormat > GetNumberFormat ()
 Gets number format from parent workbook. More...
 
System::SharedPtr< Aspose::Slides::Xlsx::NumberFormat > GetOrCreateNumberFormat ()
 Searches a nubmer format in parent workbook by cell format code and creates new if it does not exist. More...
 
void CopyFormatFrom (System::SharedPtr< Aspose::Slides::Xlsx::XlsxCellFormat > cellFormat)
 Copies cell format to this object. More...
 
void PrepareForSaving (System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::RowElement > target)
 
 ChartDataCell (System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection > parent, System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::CellElement > elemCell)
 
virtual ~ChartDataCell ()
 

Protected Attributes

bool inCol
 

Additional Inherited Members

- Public Types inherited from System::Object
typedef SmartPtr< Objectptr
 Alias for smart pointer type. More...
 
typedef System::Details::SharedMembersType shared_members_type
 structure to keep list of shared pointers contained in object. More...
 
- Static Public Member Functions inherited from System::Object
static bool ReferenceEquals (ptr const &objA, ptr const &objB)
 Compares objects by reference. More...
 
template<typename T >
static std::enable_if<!IsSmartPtr< T >::value, bool >::type ReferenceEquals (T const &objA, T const &objB)
 Compares objects by reference. More...
 
template<typename T >
static std::enable_if<!IsSmartPtr< T >::value, bool >::type ReferenceEquals (T const &objA, std::nullptr_t)
 Reference-compares value type object with nullptr. More...
 
template<typename T1 , typename T2 >
static std::enable_if< IsSmartPtr< T1 >::value &&IsSmartPtr< T2 >::value, bool >::type Equals (T1 const &objA, T2 const &objB)
 Compares reference type objects in C# style. More...
 
template<typename T1 , typename T2 >
static std::enable_if<!IsSmartPtr< T1 >::value &&!IsSmartPtr< T2 >::value, bool >::type Equals (T1 const &objA, T2 const &objB)
 Compares value type objects in C# style. More...
 
static const TypeInfoType ()
 Impleemnts C# typeof(System.Object) construct. More...
 

Detailed Description

Represents cell for chart data.

Constructor & Destructor Documentation

◆ ChartDataCell() [1/3]

Aspose::Slides::Charts::ChartDataCell::ChartDataCell ( System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection >  parent)
protected

◆ ChartDataCell() [2/3]

Aspose::Slides::Charts::ChartDataCell::ChartDataCell ( System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection >  parent,
System::String  name 
)
protected

◆ ChartDataCell() [3/3]

Aspose::Slides::Charts::ChartDataCell::ChartDataCell ( System::SharedPtr< Aspose::Slides::Xlsx::ChartDataCellCollection >  parent,
System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::CellElement >  elemCell 
)
protected

◆ ~ChartDataCell()

virtual Aspose::Slides::Charts::ChartDataCell::~ChartDataCell ( )
protectedvirtual

Member Function Documentation

◆ CopyFormatFrom()

void Aspose::Slides::Charts::ChartDataCell::CopyFormatFrom ( System::SharedPtr< Aspose::Slides::Xlsx::XlsxCellFormat >  cellFormat)
protected

Copies cell format to this object.

Parameters
cellFormatCell format copy from.

◆ get_Adapter()

System::SharedPtr<SpreadsheetCellAdapter> Aspose::Slides::Charts::ChartDataCell::get_Adapter ( ) const
protected

◆ get_ChartDataWorksheet()

System::SharedPtr<IChartDataWorksheet> Aspose::Slides::Charts::ChartDataCell::get_ChartDataWorksheet ( )
virtual

Gets the worksheet. Read-only IChartDataWorksheet.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_Column()

int32_t Aspose::Slides::Charts::ChartDataCell::get_Column ( )
virtual

Returns the index of the column of worksheet in which the cell is located. Read-only int32_t.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_CustomNumberFormat()

System::String Aspose::Slides::Charts::ChartDataCell::get_CustomNumberFormat ( )
virtual

Gets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read System::String.

Exceptions
ArgumentNullExceptionThrown if value is null.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_Format()

System::SharedPtr<Aspose::Slides::Xlsx::XlsxCellFormat> Aspose::Slides::Charts::ChartDataCell::get_Format ( )
protected

◆ get_Formula()

System::String Aspose::Slides::Charts::ChartDataCell::get_Formula ( )
virtual

Gets the formula in A1-style.

auto cell = workbook->GetCell(0, u"B2");
cell->set_Formula(u"1 + SUM(F2:H5)");

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_HasDefaultNumberFormat()

bool Aspose::Slides::Charts::ChartDataCell::get_HasDefaultNumberFormat ( )
protected

◆ get_IntValue()

int32_t Aspose::Slides::Charts::ChartDataCell::get_IntValue ( )
protected

◆ get_IsHidden()

bool Aspose::Slides::Charts::ChartDataCell::get_IsHidden ( )
virtual

Determines whether the cell is hidden. Read-only bool.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_Name()

System::String Aspose::Slides::Charts::ChartDataCell::get_Name ( )
protected

◆ get_ParentWorkbook()

System::SharedPtr<ChartDataWorkbook> Aspose::Slides::Charts::ChartDataCell::get_ParentWorkbook ( )
protected

◆ get_ParentWorksheetInternal()

System::SharedPtr<Aspose::Slides::Charts::ChartDataWorksheet> Aspose::Slides::Charts::ChartDataCell::get_ParentWorksheetInternal ( )
protected

◆ get_PresetNumberFormat()

uint8_t Aspose::Slides::Charts::ChartDataCell::get_PresetNumberFormat ( )
virtual

Gets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Read <see cref="uint8_t">.

0 General
1 0
2 0.00
3 #,##0
4 #,##0.00
5 $#,##0;$-#,##0
6 $#,##0;[Red]$-#,##0
7 $#,##0.00;$-#,##0.00
8 $#,##0.00;[Red]$-#,##0.00
9 0%
10 0.00%
11 0.00E+00
12 # ?/?
13 # /
14 m/d/yy
15 d-mmm-yy
16 d-mmm
17 mmm-yy
18 h:mm AM/PM
19 h:mm:ss AM/PM
20 h:mm
21 h:mm:ss
22 m/d/yy h:mm
37 #,##0;-#,##0
38 #,##0;[Red]-#,##0
39 #,##0.00;-#,##0.00
40 #,##0.00;[Red]-#,##0.00
41 _ * #,##0_ ;_ * "_ ;_ @_
42 _ $* #,##0_ ;_ $* "_ ;_ @_
43 _ * #,##0.00_ ;_ * "??_ ;_ @_
44 _("$"* # ##0,00_);_("$"* (# ##0,00);_("$"* "-"??_);_(@_)
45 mm:ss
46 h :mm:ss
47 mm:ss.0
48 ##0.0E+00
49 @

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_R1C1Formula()

System::String Aspose::Slides::Charts::ChartDataCell::get_R1C1Formula ( )
virtual

Gets the formula in R1C1-style.

auto cell = workbook->GetCell(0, u"C2");
cell->set_R1C1Formula(u"MAX(R2C6:R5C8) / 3");

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_Row()

int32_t Aspose::Slides::Charts::ChartDataCell::get_Row ( )
virtual

Returns the index of the row of worksheet in which the cell is located. Read-only int32_t.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ get_StringValue()

System::String Aspose::Slides::Charts::ChartDataCell::get_StringValue ( )
protected

◆ get_Type()

Aspose::Slides::PptxSerialization::PartParser::XmlParser::CellType Aspose::Slides::Charts::ChartDataCell::get_Type ( )
protected

◆ get_Value()

System::SharedPtr<System::Object> Aspose::Slides::Charts::ChartDataCell::get_Value ( )
virtual

Gets the value. Read object.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ GetCellFormatIdx()

int32_t Aspose::Slides::Charts::ChartDataCell::GetCellFormatIdx ( )
protected

Gets index of cell format in parent workbook formats collection.

Returns
The zero-based index.

◆ GetEffectiveFormatCode()

System::String Aspose::Slides::Charts::ChartDataCell::GetEffectiveFormatCode ( bool  cultureDependent)
protected

Gets effective format code of the cell.

Parameters
cultureDependentIs builtIn format codes dependent from current culture. Culture-dependent format codes used only for rendering.

◆ GetNumberFormat()

System::SharedPtr<Aspose::Slides::Xlsx::NumberFormat> Aspose::Slides::Charts::ChartDataCell::GetNumberFormat ( )
protected

Gets number format from parent workbook.

Returns
The number format if it contains in parent workbook, otherwise null

◆ GetOrCreateNumberFormat()

System::SharedPtr<Aspose::Slides::Xlsx::NumberFormat> Aspose::Slides::Charts::ChartDataCell::GetOrCreateNumberFormat ( )
protected

Searches a nubmer format in parent workbook by cell format code and creates new if it does not exist.

Returns
The number format attached to parent workbook.

◆ PrepareForSaving()

void Aspose::Slides::Charts::ChartDataCell::PrepareForSaving ( System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::RowElement >  target)
protected

◆ PutA1Formula()

void Aspose::Slides::Charts::ChartDataCell::PutA1Formula ( System::String  formula)
protected

◆ PutR1C1Formula()

void Aspose::Slides::Charts::ChartDataCell::PutR1C1Formula ( System::String  formula)
protected

◆ PutValue() [1/4]

void Aspose::Slides::Charts::ChartDataCell::PutValue ( double  value)
protected

◆ PutValue() [2/4]

void Aspose::Slides::Charts::ChartDataCell::PutValue ( int32_t  value)
protected

◆ PutValue() [3/4]

void Aspose::Slides::Charts::ChartDataCell::PutValue ( System::String  value)
protected

◆ PutValue() [4/4]

void Aspose::Slides::Charts::ChartDataCell::PutValue ( System::SharedPtr< System::Object value)
protected

◆ set_CustomNumberFormat()

void Aspose::Slides::Charts::ChartDataCell::set_CustomNumberFormat ( System::String  value)
virtual

Sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Write System::String.

Exceptions
ArgumentNullExceptionThrown if value is null.

Implements Aspose::Slides::Charts::IChartDataCell.

◆ set_Formula()

void Aspose::Slides::Charts::ChartDataCell::set_Formula ( System::String  value)
virtual

Sets the formula in A1-style.

auto cell = workbook->GetCell(0, u"B2");
cell->set_Formula(u"1 + SUM(F2:H5)");

Implements Aspose::Slides::Charts::IChartDataCell.

◆ set_Name()

void Aspose::Slides::Charts::ChartDataCell::set_Name ( System::String  value)
protected

◆ set_PresetNumberFormat()

void Aspose::Slides::Charts::ChartDataCell::set_PresetNumberFormat ( uint8_t  value)
virtual

Sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Write <see cref="uint8_t">.

0 General
1 0
2 0.00
3 #,##0
4 #,##0.00
5 $#,##0;$-#,##0
6 $#,##0;[Red]$-#,##0
7 $#,##0.00;$-#,##0.00
8 $#,##0.00;[Red]$-#,##0.00
9 0%
10 0.00%
11 0.00E+00
12 # ?/?
13 # /
14 m/d/yy
15 d-mmm-yy
16 d-mmm
17 mmm-yy
18 h:mm AM/PM
19 h:mm:ss AM/PM
20 h:mm
21 h:mm:ss
22 m/d/yy h:mm
37 #,##0;-#,##0
38 #,##0;[Red]-#,##0
39 #,##0.00;-#,##0.00
40 #,##0.00;[Red]-#,##0.00
41 _ * #,##0_ ;_ * "_ ;_ @_
42 _ $* #,##0_ ;_ $* "_ ;_ @_
43 _ * #,##0.00_ ;_ * "??_ ;_ @_
44 _("$"* # ##0,00_);_("$"* (# ##0,00);_("$"* "-"??_);_(@_)
45 mm:ss
46 h :mm:ss
47 mm:ss.0
48 ##0.0E+00
49 @

Implements Aspose::Slides::Charts::IChartDataCell.

◆ set_R1C1Formula()

void Aspose::Slides::Charts::ChartDataCell::set_R1C1Formula ( System::String  value)
virtual

Sets the formula in R1C1-style.

auto cell = workbook->GetCell(0, u"C2");
cell->set_R1C1Formula(u"MAX(R2C6:R5C8) / 3");

Implements Aspose::Slides::Charts::IChartDataCell.

◆ set_Value()

void Aspose::Slides::Charts::ChartDataCell::set_Value ( System::SharedPtr< System::Object value)
virtual

Sets the value. Write object.

Implements Aspose::Slides::Charts::IChartDataCell.

Member Data Documentation

◆ inCol

bool Aspose::Slides::Charts::ChartDataCell::inCol
protected