Skip to main content

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

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

 

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

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,012
Posts
121,585
Replies
39,634
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.