Skip to main content
Solved

FME adds @ in front of excel formulas at writing

  • October 1, 2025
  • 3 replies
  • 64 views
hlynur
Supporter
Forum|alt.badge.img+10

Hello, its me again.

So I’m playing with changing excel documents in Form 2024.1 and its going superb, except from the fact that when Form writes out my changed excel it adds an @ in front of some of the formulas. So for example the formula that gets read in as:

=XLOOKUP(blabla)

Gets written out as:
=@XLOOKUP(blabla)

Which then makes the whole outcome excel document breaks.

I have ran this with caching and see that at last cache before writing then the formulas are intact, so this must happen in the writer or that the excel gets written out in some manner that my excel setup *misunderstands* it?

As always, all comments are welcomed (as long as you not a person just looking to score some points by copy/pasting what AI said the problem was).

-Hlynur

Best answer by hlynur

Figured out a solution by myself, ok maybe not a solution but a comfortable workaround:
Changing a cell entry in an overly complex Excel document | Community

danilo_fme
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

geomancer
Evangelist
Forum|alt.badge.img+59
  • geomancerEvangelist
  • Evangelist
  • October 1, 2025

Do you use attributename.formula for your formulas, as mentioned in the documentation under Formulas? 

 

hlynur
Supporter
Forum|alt.badge.img+10
  • hlynurSupporter
  • Author
  • Supporter
  • October 2, 2025

Hey ​@geomancer and thanks for the response.
I’m not even doing that complex thing as to create formulas with Form.
I’m inheriting all formulas written out from the writer, leaving them completely untouched in the workspace while just changing a single number in a cell that only contains that number. Have both tried to write the whole thing out as a fresh document and just done a update command to a existing document, both fail through those @’s being added.

-Hlynur

hlynur
hlynur
Supporter
Forum|alt.badge.img+10
  • hlynurSupporter
  • Author
  • Supporter
  • Best Answer
  • October 2, 2025

Figured out a solution by myself, ok maybe not a solution but a comfortable workaround:
Changing a cell entry in an overly complex Excel document | Community

Community Stats

32,127
Posts
121,961
Replies
39,777
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.