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:
Example of data generated:
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.
Doing this repeats the values for all lines generated by Aspose.