Class RangesOperations
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class RangesOperations : ObjectConstructors
RangesOperations()
Default constructor.
Declaration
public RangesOperations()RangesOperations(List<Rectangle>)
Creates new instance of current class.
Declaration
public RangesOperations(List<Rectangle> arrCells)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Collections.Generic.List<Rectangle> | arrCells | Cell ranges list. | 
Properties
CellList
Gets / sets list of the cells.
Declaration
public virtual List<Rectangle> CellList { get; set; }Property Value
| Type | 
|---|
| System.Collections.Generic.List<Rectangle> | 
Methods
AddCells(IList<Rectangle>)
Adds cells from the collection.
Declaration
public void AddCells(IList<Rectangle> arrCells)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Collections.Generic.IList<Rectangle> | arrCells | Cells to add to the collection. | 
AddRange(Rectangle)
Adds new cell range to the collection.
Declaration
public void AddRange(Rectangle rect)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle | rect | Range to add. | 
AddRange(IRange)
Adds range to the collection.
Declaration
public void AddRange(IRange range)Parameters
| Type | Name | Description | 
|---|---|---|
| IRange | range | Range to add. | 
AddRectangles(IList<Rectangle>)
Adds cells from the collection.
Declaration
public void AddRectangles(IList<Rectangle> arrCells)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Collections.Generic.IList<Rectangle> | arrCells | Cells to add to the collection. | 
Clear()
Clears internal list.
Declaration
public void Clear()Clone()
Creates copy of the current object.
Declaration
public RangesOperations Clone()Returns
| Type | Description | 
|---|---|
| RangesOperations | Copy of the current object. | 
Contains(Rectangle)
Indicates whether collection contains specified range.
Declaration
public bool Contains(Rectangle range)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle | range | Range to check. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains specified range. | 
Contains(Rectangle, Int32)
Indicates whether collection contains specified range.
Declaration
public bool Contains(Rectangle range, int iStartIndex)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle | range | Range to check. | 
| System.Int32 | iStartIndex | Start index in the internal ranges collection to search from. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains specified range. | 
Contains(Rectangle[])
Indicates whether collection contains all specified ranges.
Declaration
public bool Contains(Rectangle[] arrRanges)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle[] | arrRanges | Ranges to check. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains all specified ranges. | 
Contains(Rectangle[], Int32)
Indicates whether collection contains all specified ranges.
Declaration
public bool Contains(Rectangle[] arrRanges, int iStartIndex)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle[] | arrRanges | Ranges to check. | 
| System.Int32 | iStartIndex | Start index in the internal ranges collection to search from. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains all specified ranges. | 
Contains(IList<Rectangle>)
Indicates whether collection contains all specified ranges.
Declaration
public bool Contains(IList<Rectangle> arrRanges)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Collections.Generic.IList<Rectangle> | arrRanges | Ranges to check. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains all specified ranges. | 
Contains(IList<Rectangle>, Int32)
Indicates whether collection contains all specified ranges.
Declaration
public bool Contains(IList<Rectangle> arrRanges, int iStartIndex)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Collections.Generic.IList<Rectangle> | arrRanges | Ranges to check. | 
| System.Int32 | iStartIndex | Start index in the internal ranges collection to search from. | 
Returns
| Type | Description | 
|---|---|
| System.Boolean | True if collection contains all specified ranges. | 
ContainsCount(Rectangle)
Returns contains count for specified range.
Declaration
public int ContainsCount(Rectangle range)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle | range | Range to check. | 
Returns
| Type | Description | 
|---|---|
| System.Int32 | Contains count | 
GetPart(Rectangle, Boolean, Int32, Int32)
Gets part of the cells.
Declaration
public RangesOperations GetPart(Rectangle rect, bool remove, int rowIncrement, int columnIncrement)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle | rect | Rectangle to get new collection for. | 
| System.Boolean | remove | Indicates whether to remove cells from the collection. | 
| System.Int32 | rowIncrement | Number of rows to add to each resulting rectangle. | 
| System.Int32 | columnIncrement | Number of columns to add to each resulting rectangle. | 
Returns
| Type | 
|---|
| RangesOperations | 
OptimizeStorage()
Optimize storage
Declaration
public void OptimizeStorage()Remove(Rectangle[])
Removes range from the collection of conditional formats.
Declaration
public void Remove(Rectangle[] arrRanges)Parameters
| Type | Name | Description | 
|---|---|---|
| Rectangle[] | arrRanges | Array of ranges to remove. | 
SetLength(Int32)
Set maximum length
Declaration
public void SetLength(int maxLength)Parameters
| Type | Name | Description | 
|---|---|---|
| System.Int32 | maxLength |