Dear Aspose,
I have been playing around with insert range function of Aspose.Cells these days
and I was able to observe the following pattern:
The chart above where I was about to insert range also has its height increased,
and that in excel 2016 it would not be extended.
(Please see “Chart Extend.PNG”)
Below is the code snippet I used.
Workbook wb = new Workbook(“test.xlsx”);
Worksheet ws = wb.Worksheets[0];
CellArea ca = CellArea.CreateCellArea(“D29”, “K29”);
ws.Cells.InsertRange(ca, 10, ShiftType.Down);
//ws.Cells.InsertRange(ca, ShiftType.Down); Does the same thing
wb.Save(“Result.xlsx”);
I have also attached the workbook I used.
Many thanks,
Jonathan Lau