/// <summary>
/// this constructor used only to create cellcollection range
/// since cellindex can be very large long value considering rows * columns =no of cells in worksheet
/// this constructor is private because its accessibility outside can cause mess
/// </summary>
/// <param name="sheet"></param>
/// <param name="cellIndex"></param>
UsedRange(ExcelWorksheet sheet, long cellIndex)
: base(sheet)
{
this.element = UsedRangeElement.Cell;
this.parentElement = UsedRangeElement.Cells;
CellToAddress(cellIndex);
SetRange();
}
/// <summary>
/// this constructor is private because its accessibility outside can cause mess
/// </summary>
/// <param name="sheet"></param>
/// <param name="element"></param>
/// <param name="elementIndex"></param>
/// <param name="cursor"></param>
UsedRange(ExcelWorksheet sheet, UsedRangeElement element, int elementIndex, int cursor)
: base(sheet)
{
this.element = element;
switch (element)
{
case UsedRangeElement.Rows:
case UsedRangeElement.Columns:
case UsedRangeElement.Cells:
parentElement = UsedRangeElement.Range;
break;
case UsedRangeElement.Row:
parentElement = UsedRangeElement.Rows;
break;
case UsedRangeElement.Column:
parentElement = UsedRangeElement.Columns;
break;
case UsedRangeElement.Cell:
parentElement = UsedRangeElement.Cells;
break;
case UsedRangeElement.RowCell:
parentElement = UsedRangeElement.Row;
break;
case UsedRangeElement.ColumnCell:
parentElement = UsedRangeElement.Column;
break;
default:
parentElement = 0;
break;
}
this.elementIndex = elementIndex;
this.cursor = cursor;
SetRange();
}
/// <summary>
/// this constructor is private because its accessibility outside can cause mess
/// </summary>
/// <param name="sheet"></param>
/// <param name="element"></param>
UsedRange(ExcelWorksheet sheet, UsedRangeElement element)
: this(sheet, element, -1, -1)
{
}
/// <summary>
/// this constructor is private because its accessibility outside can cause mess
/// </summary>
/// <param name="sheet"></param>
/// <param name="element"></param>
/// <param name="elementIndex"></param>
UsedRange(ExcelWorksheet sheet, UsedRangeElement element, int elementIndex)
: this(sheet, element, elementIndex, -1)
{
}
