Hi Benjamin,
Thank you for using Syncfusion products.
Currently our XlsIO does not support to dynamically change formula with
Template Marker. However you can work around by using UsedRange property after
the ApplyMarker method invocation. We have shared the code snippet for your
reference.
Code Snippet:
marker.ApplyMarker();
int
lastRow=sheet.UsedRange.LastRow;
sheet["H11"].Formula
= string.Format("SUM(H6:H{0})",(lastRow
- 3));
|
Please let us know if you need any clarification.
Regards,
Prasanth