My scope currently is to produce an excel output using FME ensuring the template is being leveraged to populate the values in this columns.
Some of these columns have formulas which have been coded in FME as AK.formula if the column AK has formula.
However when I convert the FME produced Excel to XML and investigated this, the formula seems to be converting “ into ". However I get to know about this only when I checked XML since Excel exactly imprints the formula as coded in FME.
What is the best way to resolve this issue?