Class CompositeRange

Represents a range made of simple ranges

Inheritance

System.Object

Range

CompositeRange

Implements

IEnumerable<System.Object>

Inherited Members

Range.Sort()

Range.Sort(SortOrder)

Range.Sort(SortOrder, SortOrientation)

Range.ToString()

Range.ClearBorders()

Range.SetArrayFormula(String, Boolean)

Range.SetArrayFormula(String)

Range.FindAll(FindArguments)

Range.ReplaceAll(ReplaceArguments)

Range.CopyFrom(Range, PasteOptions)

Range.NameOrLabel

Range.Item[Int32]

Range.FirstRowIndex

Range.FirstColumnIndex

Range.Foreground

Range.Background

Range.WrapText

Range.VerticalAlignment

Range.HorizontalAlignment

Range.Format

Range.IsLocked

Range.AbsoluteLabel

Range.FullAbsoluteLabel

Range.FullLabel

Range.Intersects(Range, Range)

Range.PropertyChanged

Range.ClearFormats()

Range.Clear()

Range.ClearContents()

Range.ClearComments()

Range.ClearHyperlinks()

Range.CellCount

Range.Fill

Range.Font

Range.Merge()

Range.Union(Range, Range)

Range.Intersection(Range, Range)

Range.SetColumnsWidthPixel(Double)

Range.SetRowsHeight(Double)

Range.SetFormula(String)

Range.SetFormula(String[])

Range.SetValue(Object)

Range.SetValue(Object[,])

Range.SetValue(Object[])

Range.SetValue(DateTime[])

Range.SetValue(Double[])

Range.SetValue(Int32[])

Range.SetValue(ErrorType[])

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class CompositeRange : Range, IRange, IArray, IEnumerable<object>, ICellEnumerator

Constructors

CompositeRange(IEnumerable<SimpleRange>)

Declaration

public CompositeRange(IEnumerable<SimpleRange> ranges)

Parameters

Type	Name	Description
IEnumerable<SimpleRange>	ranges

Properties

ColumnCount

Declaration

public override int ColumnCount { get; }

Property Value

Type	Description
System.Int32

Overrides

Range.ColumnCount

IsFullColumn

Declaration

public override bool IsFullColumn { get; }

Property Value

Type	Description
System.Boolean

Overrides

Range.IsFullColumn

IsFullRow

Declaration

public override bool IsFullRow { get; }

Property Value

Type	Description
System.Boolean

Overrides

Range.IsFullRow

Item[Int32, Int32]

Declaration

public override Cell this[int row, int column] { get; }

Parameters

Type	Name	Description
System.Int32	row
System.Int32	column

Property Value

Type	Description
Cell

Overrides

Range.Item[Int32, Int32]

Label

Declaration

public override string Label { get; }

Property Value

Type	Description
System.String

Overrides

Range.Label

Ranges

Declaration

public List<SimpleRange> Ranges { get; }

Property Value

Type	Description
List<SimpleRange>

RowCount

Declaration

public override int RowCount { get; }

Property Value

Type	Description
System.Int32

Overrides

Range.RowCount

TopLeftCell

Declaration

public override Cell TopLeftCell { get; }

Property Value

Type	Description
Cell

Overrides

Range.TopLeftCell

Worksheet

Declaration

public override Worksheet Worksheet { get; }

Property Value

Type	Description
Worksheet

Overrides

Range.Worksheet

Methods

Equals(Range)

Declaration

public override bool Equals(Range r)

Parameters

Type	Name	Description
Range	r

Returns

Type	Description
System.Boolean

Overrides

Range.Equals(Range)

GetAllCells()

Declaration

public override IEnumerable<Cell> GetAllCells()

Returns

Type	Description
IEnumerable<Cell>

Overrides

Range.GetAllCells()

GetColumns()

Declaration

public override IEnumerable<Column> GetColumns()

Returns

Type	Description
IEnumerable<Column>

Overrides

Range.GetColumns()

GetRows()

Declaration

public override IEnumerable<Row> GetRows()

Returns

Type	Description
IEnumerable<Row>

Overrides

Range.GetRows()

SetBorder(Border, BorderType)

Declaration

public override void SetBorder(Border border, BorderType borderType)

Parameters

Type	Name	Description
Border	border
BorderType	borderType

Overrides

Range.SetBorder(Border, BorderType)

SetStyle(CellStyle)

Declaration

public override void SetStyle(CellStyle cellStyle)

Parameters

Type	Name	Description
CellStyle	cellStyle

Overrides

Range.SetStyle(CellStyle)

Implements

IEnumerable<>