Ranges in ReoGrid are defined by a starting position and size. A range encompasses one or more cells. Ranges can intersect, and a range is not the same as a merged cell (though a range can be merged).

ReoGrid represents ranges through two primary types:

• RangePosition — A lightweight struct holding position and size. Not tied to any worksheet.
• ReferenceRange — A class bound to a specific worksheet, providing direct access to data, styles, and operations.

RangePosition

The RangePosition struct stores numeric information for identifying a range: start row, start column, row count, and column count. All indices are zero-based.

// From an address string
var range = new RangePosition("C5:H14");

// From row, column, rows, columns
var range = new RangePosition(4, 2, 10, 6);

// From start and end positions
var range = new RangePosition(new CellPosition("C5"), new CellPosition("H14"));

// From two address strings
var range = new RangePosition("C5", "H14");

// Single cell
var range = new RangePosition(new CellPosition("A1"));

Properties

Methods

Static Members

Get a Safe Range

When a range might exceed worksheet bounds, use FixRange:

var safeRange = sheet.FixRange(range);

ReferenceRange

A ReferenceRange is bound to a specific worksheet and provides direct access to data, styles, borders, formatting, and operations on that range.

Get a ReferenceRange

Use the Ranges collection on the worksheet:

var range = sheet.Ranges["B2:D3"];
var range = sheet.Ranges[1, 1, 2, 3];         // row, col, rows, cols
var range = sheet.Ranges[new RangePosition(1, 1, 2, 3)];
var range = sheet.Ranges[new CellPosition("B2"), new CellPosition("D3")];

Properties

Position

Data and Content

// Set range data
range.Data = new object[] { "Product", "Price", "Quantity" };

Styling

range.Style.BackColor = Color.LightBlue;
range.Style.Bold = true;

Border Shortcuts

range.BorderOutside = RangeBorderStyle.BlackSolid;
range.Border.Outside = RangeBorderStyle.BlackSolid;  // equivalent

Data Format

Protection

Validation

Methods

Iterate Cells

var range = sheet.Ranges["A1:C3"];

range.IterateCells((row, col, cell) =>
{
    Console.WriteLine($"Cell [{row},{col}]: {cell?.Data}");
    return true;  // continue iterating
});

Convert Between Types

// RangePosition → ReferenceRange
var refRange = sheet.Ranges[rangePosition];

// ReferenceRange → RangePosition
RangePosition pos = refRange.Position;

// Implicit conversion (ReferenceRange to RangePosition)
RangePosition pos = refRange;

// Both work in assignments
sheet.SelectionRange = rangePosition;
sheet.SelectionRange = refRange;

Clear Range Content

Use ClearRangeContent to selectively clear elements from a range:

// Clear only data
sheet.ClearRangeContent("A1:B5", CellElementFlag.Data);

// Clear only formulas
sheet.ClearRangeContent("A1:B5", CellElementFlag.Formula);

// Clear everything
sheet.ClearRangeContent("A1:B5", CellElementFlag.All);

CellElementFlag Enum (Flags)

Used Range

Get the range that contains data:

RangePosition usedRange = sheet.UsedRange;

Named Range

Named ranges are special ReferenceRange instances with a name. See Named Range.

Related Topics

• Named Range — Defining and using named ranges
• Merge Cells — Merging and unmerging ranges
• Cell Style — Styling cells and ranges
• Border — Border styles
• Data Format — Data formatting