Aspose::Cells::IReferredArea Class Referenceabstract

Represents a referred object by the formula. More...

Inherits Object.

Public Member Functions

virtual bool IsExternalLink ()=0
 Indicates whether this is an external link. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetExternalFileName ()=0
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetSheetName ()=0
 Indicates which sheet this is in More...
 
virtual bool IsArea ()=0
 Indicates whether this is an area. More...
 
virtual Aspose::Cells::Systems::Int32 GetEndColumn ()=0
 The end column of the area. More...
 
virtual Aspose::Cells::Systems::Int32 GetStartColumn ()=0
 The start column of the area. More...
 
virtual Aspose::Cells::Systems::Int32 GetEndRow ()=0
 The end row of the area. More...
 
virtual Aspose::Cells::Systems::Int32 GetStartRow ()=0
 The start row of the area. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Object > GetValues ()=0
 Gets cell values in this area. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Object > GetValue (Aspose::Cells::Systems::Int32 rowOffset, Aspose::Cells::Systems::Int32 colOffset)=0
 Gets cell value with given offset from the top-left of this area. More...
 

Detailed Description

Represents a referred object by the formula.

Member Function Documentation

◆ GetEndColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::IReferredArea::GetEndColumn ( )
pure virtual

The end column of the area.

◆ GetEndRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::IReferredArea::GetEndRow ( )
pure virtual

The end row of the area.

◆ GetExternalFileName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::IReferredArea::GetExternalFileName ( )
pure virtual

◆ GetSheetName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::IReferredArea::GetSheetName ( )
pure virtual

Indicates which sheet this is in

◆ GetStartColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::IReferredArea::GetStartColumn ( )
pure virtual

The start column of the area.

◆ GetStartRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::IReferredArea::GetStartRow ( )
pure virtual

The start row of the area.

◆ GetValue()

virtual intrusive_ptr<Aspose::Cells::Systems::Object> Aspose::Cells::IReferredArea::GetValue ( Aspose::Cells::Systems::Int32  rowOffset,
Aspose::Cells::Systems::Int32  colOffset 
)
pure virtual

Gets cell value with given offset from the top-left of this area.

Parameters
rowOffsetrow offset from the start row of this area
Parameters
colOffsetcolumn offset from the start row of this area
Returns
"#REF!" if this area is invalid; "#N/A" if given offset out of this area; Otherwise return the cell value at given position.

◆ GetValues()

virtual intrusive_ptr<Aspose::Cells::Systems::Object> Aspose::Cells::IReferredArea::GetValues ( )
pure virtual

Gets cell values in this area.

Returns
If this area is invalid, "#REF!" will be returned; If this area is one single cell, then return the cell value object; Otherwise return one array for all values in this area.

◆ IsArea()

virtual bool Aspose::Cells::IReferredArea::IsArea ( )
pure virtual

Indicates whether this is an area.

If this is not an area, only StartRow and StartColumn effect.

◆ IsExternalLink()

virtual bool Aspose::Cells::IReferredArea::IsExternalLink ( )
pure virtual

Indicates whether this is an external link.