Indexing modes used by CellRange.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025

Syntax

C#
public enum RangeIndexingMode
Visual Basic
Public Enumeration RangeIndexingMode

Members

Member nameValueDescription
Rectangular0 Rectangular indexing mode. Rectangular cell range is higher than one row and wider than one column.
Horizontal1 Horizontal indexing mode. Horizontal cell range has CellRange.Height equal to 1.
Vertical2 Vertical indexing mode. Vertical cell range has CellRange.Width equal to 1.

Examples

Following code creates horizontal, vertical and rectangular cell ranges and demonstrates how indexing works different in different context. SetBorders method is used to mark outside borders of the rectangular range.
CopyVB.NET
Dim cr As CellRange = excelFile.Worksheets(0).Rows(1).Cells

cr(0).Value = cr.IndexingMode
cr(3).Value = "D2"
cr("B").Value = "B2"

cr = excelFile.Worksheets(0).Columns(4).Cells

cr(0).Value = cr.IndexingMode
cr(2).Value = "E3"
cr("5").Value = "E5"

cr = excelFile.Worksheets(0).Cells.GetSubrange("F2", "J8")
cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed)

cr("I7").Value = cr.IndexingMode
cr(0, 0).Value = "F2"
cr("G3").Value = "G3"
cr(5).Value = "F3" <font color="Green">' Cell range width is 5 (F G H I J).</font>
CopyC#
CellRange cr = excelFile.Worksheets[0].Rows[1].Cells;                

cr[0].Value = cr.IndexingMode;
cr[3].Value = "D2";
cr["B"].Value = "B2";

cr = excelFile.Worksheets[0].Columns[4].Cells;

cr[0].Value = cr.IndexingMode;
cr[2].Value = "E3";
cr["5"].Value = "E5";

cr = excelFile.Worksheets[0].Cells.GetSubrange("F2", "J8");
cr.SetBorders(MultipleBorders.Outside, Color.Navy, LineStyle.Dashed);

cr["I7"].Value = cr.IndexingMode;
cr[0,0].Value = "F2";
cr["G3"].Value = "G3";
cr[5].Value = "F3"; <font color="Green">// Cell range width is 5 (F G H I J).</font>

See Also