Hi Dave,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue after executing the following code with the sample Excel file attached with this post and using the latest version: Aspose.Cells
for .NET v8.2.1.1. ListObject.Resize() does not copy the formula in the newly included rows. However, when list object is resized with MS-Excel, the formulas are also copied to newly added rows.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-43028.
Please see the sample Excel file attached with this post and output Excel file generated by Aspose.Cells which is also attached. I have also attached the expected output Excel file and the screenshot illustrating this issue for a reference.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\sample.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets[0];
ListObject lo = worksheet.ListObjects[0];
lo.Resize(0, 1, 10, 3, true);
workbook.Save(“output.xlsx”);