Encapsulates the object that represents a range of cells within a spreadsheet.
More...
Inherits Object.
|
virtual void | AutoFill (intrusive_ptr< Aspose::Cells::IRange > target)=0 |
| Automaticall fill the target range. More...
|
|
virtual void | AutoFill (intrusive_ptr< Aspose::Cells::IRange > target, Aspose::Cells::AutoFillType autoFillType)=0 |
| Automaticall fill the target range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IRange > | GetCurrentIRegion ()=0 |
| Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::IHyperlink * > > | GetIHyperlinks ()=0 |
| Gets all hyperlink in the range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IHyperlink > | AddIHyperlink (intrusive_ptr< Aspose::Cells::Systems::String > address, intrusive_ptr< Aspose::Cells::Systems::String > textToDisplay, intrusive_ptr< Aspose::Cells::Systems::String > screenTip)=0 |
| Adds a hyperlink to a specified cell or a range of cells. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::Collections::IEnumerator > | GetEnumerator ()=0 |
| - Returns
- The cells enumerator
More...
|
|
virtual bool | IsIntersect (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Indicates whether the range is intersect. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IRange > | Intersect (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Returns an IRange object that represents the rectangular intersection of two ranges. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > | Union (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Returns the union of two ranges. More...
|
|
virtual Aspose::Cells::Systems::Int32 | GetRowCount ()=0 |
| Gets the count of rows in the range. More...
|
|
virtual Aspose::Cells::Systems::Int32 | GetColumnCount ()=0 |
| Gets the count of columns in the range. More...
|
|
virtual Aspose::Cells::Systems::Int32 | GetCellCount ()=0 |
| Gets all cell count in the range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::String > | GetName ()=0 |
| Gets or sets the name of the range. More...
|
|
virtual void | SetName (intrusive_ptr< Aspose::Cells::Systems::String > value)=0 |
| Sets the name of the range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::String > | GetRefersTo ()=0 |
| Gets the range's refers to. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::String > | GetAddress ()=0 |
| Gets address of the range. More...
|
|
virtual bool | IsBlank ()=0 |
| Indicates whether the range contains values. More...
|
|
virtual Aspose::Cells::Systems::Double | GetLeft ()=0 |
| Gets the distance, in points, from the left edge of column A to the left edge of the range. More...
|
|
virtual Aspose::Cells::Systems::Double | GetTop ()=0 |
| Gets the distance, in points, from the top edge of row 1 to the top edge of the range. More...
|
|
virtual Aspose::Cells::Systems::Double | GetWidth ()=0 |
| Gets the width of a range in points. More...
|
|
virtual Aspose::Cells::Systems::Double | GetHeight ()=0 |
| Gets the width of a range in points. More...
|
|
virtual Aspose::Cells::Systems::Int32 | GetFirstRow ()=0 |
| Gets the index of the first row of the range. More...
|
|
virtual Aspose::Cells::Systems::Int32 | GetFirstColumn ()=0 |
| Gets the index of the first column of the range. More...
|
|
virtual void | Merge ()=0 |
| Combines a range of cells into a single cell.
More...
|
|
virtual void | UnMerge ()=0 |
| Unmerges merged cells of this range. More...
|
|
virtual void | PutValue (intrusive_ptr< Aspose::Cells::Systems::String > stringValue, bool isConverted, bool setStyle)=0 |
| Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::Object > | GetValue ()=0 |
| Gets the value of the range. More...
|
|
virtual void | SetValue (intrusive_ptr< Aspose::Cells::Systems::Object > value)=0 |
| Sets the value of the range. More...
|
|
virtual void | SetIStyle (intrusive_ptr< Aspose::Cells::IStyle > style, bool explicitFlag)=0 |
| Apply the cell style. More...
|
|
virtual void | ApplyIStyle (intrusive_ptr< Aspose::Cells::IStyle > style, intrusive_ptr< Aspose::Cells::IStyleFlag > flag)=0 |
| Applies formats for a whole range. More...
|
|
virtual void | SetIStyle (intrusive_ptr< Aspose::Cells::IStyle > style)=0 |
| Sets the style of the range. More...
|
|
virtual void | SetOutlineBorders (Aspose::Cells::CellBorderType borderStyle, intrusive_ptr< Aspose::Cells::ICellsColor > borderColor)=0 |
| Sets the outline borders around a range of cells with same border style and color. More...
|
|
virtual void | SetOutlineBorders (Aspose::Cells::CellBorderType borderStyle, intrusive_ptr< Aspose::Cells::Systems::Drawing::Color > borderColor)=0 |
| Sets the outline borders around a range of cells with same border style and color. More...
|
|
virtual void | SetOutlineBorders (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::CellBorderType >> borderStyles, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Drawing::Color *>> borderColors)=0 |
| Sets out line borders around a range of cells. More...
|
|
virtual void | SetOutlineBorder (Aspose::Cells::BorderType borderEdge, Aspose::Cells::CellBorderType borderStyle, intrusive_ptr< Aspose::Cells::ICellsColor > borderColor)=0 |
| Sets outline border around a range of cells. More...
|
|
virtual void | SetOutlineBorder (Aspose::Cells::BorderType borderEdge, Aspose::Cells::CellBorderType borderStyle, intrusive_ptr< Aspose::Cells::Systems::Drawing::Color > borderColor)=0 |
| Sets outline border around a range of cells. More...
|
|
virtual void | SetInsideBorders (Aspose::Cells::BorderType borderEdge, Aspose::Cells::CellBorderType lineStyle, intrusive_ptr< Aspose::Cells::ICellsColor > borderColor)=0 |
| Set inside borders of the range. More...
|
|
virtual Aspose::Cells::Systems::Double | GetColumnWidth ()=0 |
| Sets or gets the column width of this range More...
|
|
virtual void | SetColumnWidth (Aspose::Cells::Systems::Double value)=0 |
| Sets or gets the column width of this range More...
|
|
virtual Aspose::Cells::Systems::Double | GetRowHeight ()=0 |
| Sets or gets the height of rows in this range More...
|
|
virtual void | SetRowHeight (Aspose::Cells::Systems::Double value)=0 |
| Sets or gets the height of rows in this range More...
|
|
virtual void | MoveTo (Aspose::Cells::Systems::Int32 destRow, Aspose::Cells::Systems::Int32 destColumn)=0 |
| Move the current range to the destination range. More...
|
|
virtual void | CopyIRangeData (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Copies cell data (including formulas) from a source range. More...
|
|
virtual void | CopyIRangeValue (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Copies cell value from a source range. More...
|
|
virtual void | CopyIRangeStyle (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Copies style settings from a source range. More...
|
|
virtual void | CopyIRange (intrusive_ptr< Aspose::Cells::IRange > range, intrusive_ptr< Aspose::Cells::IPasteOptions > options)=0 |
| Copying the range with paste special options. More...
|
|
virtual void | CopyIRange (intrusive_ptr< Aspose::Cells::IRange > range)=0 |
| Copies data (including formulas), formatting, drawing objects etc. from a source range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::ICell > | GetObjectByIndex (Aspose::Cells::Systems::Int32 rowOffset, Aspose::Cells::Systems::Int32 columnOffset)=0 |
| Gets ICell object in this range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::ICell > | GetICellOrNull (Aspose::Cells::Systems::Int32 rowOffset, Aspose::Cells::Systems::Int32 columnOffset)=0 |
| Gets ICell object or null in this range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IRange > | GetIRangeOffset (Aspose::Cells::Systems::Int32 rowOffset, Aspose::Cells::Systems::Int32 columnOffset)=0 |
| Gets IRange range by offset. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IRange > | GetEntireIRangeColumn ()=0 |
| Gets a Range object that represents the entire column (or columns) that contains the specified range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IRange > | GetEntireIRangeRow ()=0 |
| Gets a Range object that represents the entire row (or rows) that contains the specified range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::IWorksheet > | GetIWorksheet ()=0 |
| Gets the IWorksheet object which contains this range. More...
|
|
virtual intrusive_ptr< Aspose::Cells::Systems::String > | ToString ()=0 |
| Returns a string represents the current Range object. More...
|
|
Encapsulates the object that represents a range of cells within a spreadsheet.