Skip to main content
Question

Defining Formula in Attribute manager

  • November 17, 2025
  • 1 reply
  • 45 views
aashnaparikh
Contributor
Forum|alt.badge.img+3

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 &quot. 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?

1 reply

crystalwang
Safer
Forum|alt.badge.img+15
  • crystalwangSafer
  • Safer
  • December 12, 2025

Hi ​@aashnaparikh,

Thank you for posting your question on the FME Community, and apologies for the delayed response. Unfortunately, I wasn’t able to reproduce this behaviour on my end.

To help narrow down where the quotes may be getting changed, could you please provide a bit more information?

  • How are you converting the Excel file to XML?
  • What is the value of AK.formula before it reaches the Excel writer? Does it contain regular quotes or show "?
  • Which version of FME Form are you using?
  • If possible, a sample workspace (with sample data) demonstrating this issue.

Thank you for your patience!

Community Stats

32,208
Posts
122,311
Replies
39,892
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.