We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to repeat static values for each row generated using smart markers?


We are using Aspose Cell v5.0 to generate documents based on Excel templates.

We use smart markers to dynamically generate data but we are also have some columns containing static values.

Our problem is that when multiple rows of data are generated, static values are not repeated for these rows.

Example of a template:

Column1 Column2
&=SmartMarker1 StaticValue

Example of data generated:
Column1 Column2
dynamicValue1 StaticValue

When the above model is used to generated data, the static value is not repeated for all my rows.

Is is possible to tell Aspose Cells to repeat the static values for each row it will be generating in my template ?


The urgent need of our product going to release, helped us in finding a solution.

The solution is to use an Aspose dynamic formula with the static value to repeat.
For example,


Doing this repeats the values for all lines generated by Aspose.