public void AutoFillSerial_Vertical() { // Arrange sheet[1, 1] = 1; sheet[2, 1] = 2; // Act sheet.AutoFillSerial(RangePosition.FromCellPosition(1, 1, 2, 1), RangePosition.FromCellPosition(3, 1, 4, 1)); // Assert Assert.AreEqual(3, sheet[3, 1]); Assert.AreEqual(4, sheet[4, 1]); }
public void AutoFillSerial_Horizontol() { // Arrange sheet[1, 1] = 1; sheet[1, 2] = 2; // Act sheet.AutoFillSerial(RangePosition.FromCellPosition(1, 1, 1, 2), RangePosition.FromCellPosition(1, 3, 1, 4)); // Assert Assert.AreEqual(3, sheet[1, 3]); Assert.AreEqual(4, sheet[1, 4]); }
public void AutoFillSerial_InputData_ExpectedOutputData(object[] inputData, object[] outputData) { // Arrange for (int r = 0; r < inputData.Length; r++) { sheet[r, 0] = inputData[r]; } var outputRange = RangePosition.FromCellPosition(inputData.Length, 0, inputData.Length + outputData.Length - 1, 0); // Act sheet.AutoFillSerial( RangePosition.FromCellPosition(0, 0, inputData.Length - 1, 0), outputRange ); // Assert Console.WriteLine("Values in input range:"); inputData.ToList().ForEach(Console.WriteLine); Console.WriteLine("Expected output:"); outputData.ToList().ForEach(Console.WriteLine); Console.WriteLine("Actual output:"); sheet.IterateCells(outputRange, (r, c, cell) => { Console.WriteLine(cell.Data); return(true); }); var offset = inputData.Length; for (var r = 0; r < outputData.Length; r++) { Assert.AreEqual(outputData[r], sheet[r + offset, 0]); } }
protected override RangePosition CreateRange(int i) { return(RangePosition.FromCellPosition(FTopRow[i], FLeftCol[i], FBottomRow[i], FRightCol[i])); }
protected override RangePosition CreateRange(int i) { return(RangePosition.FromCellPosition(FRow[i], FCol[i], 1, 1)); }