Class RangeInfo

RangeInfo represents a rectangle array of cells that may contain formulas, strings, or numbers that may be referenced by other formulas.

Inheritance

System.Object

RangeInfo

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Syncfusion.Calculate

Assembly: Syncfusion.Calculate.Base.dll

Syntax

public class RangeInfo

Constructors

RangeInfo(Int32, Int32, Int32, Int32)

Constructs a RangeInfo instance with the given top, left, bottom and right values.

Declaration

public RangeInfo(int top, int left, int bottom, int right)

Parameters

Type	Name	Description
System.Int32	top	Top row index of this range.
System.Int32	left	Left column index of this range.
System.Int32	bottom	Bottom row index of this range.
System.Int32	right	Right column index of this range.

Remarks

The range values must be one-based indexes.

Properties

Bottom

A property that gets/sets the bottom row index of this range.

Declaration

public int Bottom { get; set; }

Property Value

Type	Description
System.Int32

Left

A property that gets/sets the left column index of this range.

Declaration

public int Left { get; set; }

Property Value

Type	Description
System.Int32

Right

A property that gets/sets the right row index of this range.

Declaration

public int Right { get; set; }

Property Value

Type	Description
System.Int32

Top

A property that gets/sets the top row index of this range.

Declaration

public int Top { get; set; }

Property Value

Type	Description
System.Int32

Methods

Cells(Int32, Int32, Int32, Int32)

A method to retrieve a range based on the numeric arguments passed in.

Declaration

public static RangeInfo Cells(int top, int left, int bottom, int right)

Parameters

Type	Name	Description
System.Int32	top	Top row index of this range.
System.Int32	left	Left column index of this range.
System.Int32	bottom	Bottom row index of this range.
System.Int32	right	Right column index of this range.

Returns

Type	Description
RangeInfo	A RangeInfo object.

Remarks

The range values must be one-based indexes.

GetAlphaLabel(Int32)

GetAlphaLabel is a method that retrieves a string value for the column whose numerical index is passed in.

Declaration

public static string GetAlphaLabel(int col)

Parameters

Type	Name	Description
System.Int32	col	Number index such as 1, 5, 27.

Returns

Type	Description
System.String	Corresponding alphabets label like A, E, AA.