We have an excel template like this:
1 &=prodInfo.Name &=prodInfo.Amount
2 [blank] [blank] - this row is hidden in the template
At runtime, we need to repeat the above section multiple times so we are opening the template xlsx using WorkbookDesigner and then repeating the section in the template using Cells.InsertRows and Cells.CopyRows.
The problem is that the formula is not getting copied over. Is this a bug in the current version of Aspose.Cells or are we doing something wrong? We are using 4.8.2.