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 override void Do() { // Get a backup of target range that will be overwritten backupedGrid = Worksheet.GetPartialGrid(TargetRange, PartialGridCopyFlag.CellData, ExPartialGridCopyFlag.None); try { Worksheet.AutoFillSerial(SourceRange, TargetRange); Worksheet.SelectionRange = RangePosition.Union(SourceRange, TargetRange); } catch (Exception ex) { Worksheet.NotifyExceptionHappen(ex); } }