Class SingleCellRange

Represents a range that consists of a single cell.

Inheritance

object

Range

SimpleRange

CellsRange

SingleCellRange

Implements

INotifyPropertyChanged

IEnumerable<object>

IEnumerable

Inherited Members

CellsRange.ApplySharedFormula(string)

CellsRange.IsFullColumn

CellsRange.IsFullRow

Range.Sort()

Range.Sort(SortOrder)

Range.Sort(SortOrder, SortOrientation)

Range.ToString()

Range.ClearBorders()

Range.SetArrayFormula(string, bool)

Range.SetArrayFormula(string)

Range.FindAll(FindArguments)

Range.ReplaceAll(ReplaceArguments)

Range.CopyFrom(Range, PasteOptions)

Range.Equals(Range)

Range.Intersects(Range, Range)

Range.ClearFormats()

Range.Clear()

Range.ClearContents()

Range.ClearComments()

Range.ClearHyperlinks()

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(int[])

Range.SetValue(ErrorType[])

Range.RemoveDuplicates(RemoveDuplicatesOptions)

Range.DeleteEmptyRows(DeleteEmptyRowsOptions)

Range.DeleteEmptyColumns(DeleteEmptyColumnsOptions)

Range.CleanText(TextCleansingOptions)

Range.NameOrLabel

Range.this[int]

Range.Foreground

Range.Background

Range.WrapText

Range.VerticalAlignment

Range.HorizontalAlignment

Range.Format

Range.IsLocked

Range.AbsoluteLabel

Range.FullAbsoluteLabel

Range.FullLabel

Range.CellCount

Range.Fill

Range.Font

Range.PropertyChanged

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class SingleCellRange : CellsRange, INotifyPropertyChanged, IEnumerable<object>, IEnumerable

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

Examples

// Create a single cell range
var singleCell = new SingleCellRange(worksheet.Cells["A1"]);
singleCell.Value = "Hello, World!";

Properties

BottomLeft

Exposes the bottom left associated with SingleCellRange.

Declaration

public override Cell BottomLeft { get; }

Property Value

Type	Description
Cell	The bottom left returned by the operation.

Overrides

CellsRange.BottomLeft

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

BottomRight

Exposes the bottom right associated with SingleCellRange.

Declaration

public override Cell BottomRight { get; }

Property Value

Type	Description
Cell	The bottom right returned by the operation.

Overrides

CellsRange.BottomRight

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

ColumnCount

Reports the number of items currently held by SingleCellRange.

Declaration

public override int ColumnCount { get; }

Property Value

Type	Description
int	The column count returned by the operation.

Overrides

Range.ColumnCount

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

FirstColumnIndex

Exposes the first column index associated with SingleCellRange.

Declaration

public override int FirstColumnIndex { get; }

Property Value

Type	Description
int	The first column index returned by the operation.

Overrides

Range.FirstColumnIndex

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

FirstRowIndex

Exposes the first row index associated with SingleCellRange.

Declaration

public override int FirstRowIndex { get; }

Property Value

Type	Description
int	The first row index returned by the operation.

Overrides

Range.FirstRowIndex

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

this[int, int]

Provides indexed access to values in the SingleCellRange.

Declaration

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

Parameters

Type	Name	Description
int	row
int	column

Property Value

Type	Description
Cell	The this returned by the operation.

Overrides

Range.this[int, int]

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

Label

Exposes the label associated with SingleCellRange.

Declaration

public override string Label { get; }

Property Value

Type	Description
string	The label returned by the operation.

Overrides

Range.Label

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

RowCount

Reports the number of items currently held by SingleCellRange.

Declaration

public override int RowCount { get; }

Property Value

Type	Description
int	The row count returned by the operation.

Overrides

Range.RowCount

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

TopLeftCell

Converts the supplied data for use with the SingleCellRange.

Declaration

public override Cell TopLeftCell { get; }

Property Value

Type	Description
Cell	The top left cell returned by the operation.

Overrides

Range.TopLeftCell

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

TopRight

Converts the supplied data for use with the SingleCellRange.

Declaration

public override Cell TopRight { get; }

Property Value

Type	Description
Cell	The top right returned by the operation.

Overrides

CellsRange.TopRight

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

Worksheet

Exposes the worksheet associated with SingleCellRange.

Declaration

public override Worksheet Worksheet { get; }

Property Value

Type	Description
Worksheet	The worksheet returned by the operation.

Overrides

Range.Worksheet

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

Methods

GetAllCells()

Retrieves the requested all cells from the SingleCellRange.

Declaration

public override IEnumerable<Cell> GetAllCells()

Returns

Type	Description
IEnumerable<Cell>	The get all cells returned by the operation.

Overrides

Range.GetAllCells()

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

GetColumns()

Retrieves the requested columns from the SingleCellRange.

Declaration

public override IEnumerable<Column> GetColumns()

Returns

Type	Description
IEnumerable<Column>	The get columns returned by the operation.

Overrides

Range.GetColumns()

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

GetRows()

Retrieves the requested rows from the SingleCellRange.

Declaration

public override IEnumerable<Row> GetRows()

Returns

Type	Description
IEnumerable<Row>	The get rows returned by the operation.

Overrides

Range.GetRows()

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

SetBorder(Border, BorderType)

Updates the border held by the SingleCellRange.

Declaration

public override void SetBorder(Border border, BorderType borderType)

Parameters

Type	Name	Description
Border	border	The border used by the operation.
BorderType	borderType	The border type used by the operation.

Overrides

Range.SetBorder(Border, BorderType)

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

SetStyle(CellStyle)

Updates the style held by the SingleCellRange.

Declaration

public override void SetStyle(CellStyle cellStyle)

Parameters

Type	Name	Description
CellStyle	cellStyle	The cell style used by the operation.

Overrides

Range.SetStyle(CellStyle)

Remarks

SingleCellRange is a specialized CellsRange for single-cell ranges. It provides optimized operations for working with individual cells.

This class is commonly used when a range operation needs to target a specific cell, such as when setting a formula or formatting a single cell.

Implements

INotifyPropertyChanged

IEnumerable<T>

IEnumerable

Extension Methods

SortingExtensions.Sort(Range, bool)