/// <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) { }