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]);
        }
Пример #2
0
        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);
            }
        }