Free Support Forum - aspose.com

Formula not getting copied

Hi,

We have an excel template like this:

A B

1 &=prodInfo.Name &=prodInfo.Amount

2 [blank] [blank] - this row is hidden in the template

3 =SUM(B1:B2)

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.

Thanks,

Vikram Sinha

Hi,

Well, you may try to use Repeat Dynamic formula in Smart Markers to set the formulas repeatedly, you may change the formula to e.g
&=&=SUM(B{-2}:B{-1}) if it suits your need.

Furthermore, you may use smart markers Grouping options (Aspose.Cells supports grouping data in smart markers), e.g group:normal/merge/repeat. For complete reference, please see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html


Thank you.