I have a question about Range.AutoFill functionality.
Workbook workbook = new Workbook();
// Get the first Worksheet Cells.
Cells cells = workbook.Worksheets.Cells;
// AutoFill bottom -> up cells["B10"].Formula = "=A10"; Range source = cells.CreateRange("B10"); Range target = cells.CreateRange("B1:B10"); source.AutoFill(target);
// AutoFill top -> down
cells[“D1”].Formula = “=C1”;
Range source1 = cells.CreateRange(“D1”);
Range target1 = cells.CreateRange(“D1:D10”);
//Save the Excel file
in the code above you can see two usage of autoFill usage, top-down bottom-up
Seems like there is a different behavior in these two scenarios, when the target range includes the source range (top-down fails, while bottom-up succeeded). please see attached result file.
book1.zip (6.9 KB)