Please check this out, might be helpful to you @tk-wf
Thanks @darshthakkar that is somewhat helpful.
The downside is that for us it misses the requirement of writing multiple sheets to a workbook (sans manual intervention).
It is a bit surprising that the Excel Formatter(s) cannot produce a field recognized as a Formula, though not sure if the fault lies in the SL implementation, a Java Component, or on the Excel side.
As a result of this, we are reevaluating the requirement to have the Formulas in the output, which might be the better thing anyway.
Yes, I agree to your workaround @tk-wf.
We might be implementing it in an incorrect way on SL and I still haven’t achieved formulas on excel.
