Hi, When I use “Write Cell” function in StudioX, I input this formula: “string.Format(”=XLOOKUP($A2:A{0},Sheet1!A4:A{1},Sheet1!G4:G{1},0)",number-2,number) However, when I run it and check Excel “@” symbol is added in formula, so it looks like this: “=XLOOKUP(@A2:A36,Sheet1!A4:A38,Sheet1!G4:G38,…

Write Cell formula inserts @ symbol in a formula

loginerror (Maciej Kuźmicz) April 15, 2022, 5:42pm 25

Just to loop back, this issue is fixed by using the Modern Excel activities.

Topic		Replies	Views
Excel Formula adding @ at the beginning Studio excel , activities , question	28	3607	October 4, 2021
Inserting a formula into a excel using write cell adds "@" symbol after "=" Activities excel , studio , question	4	928	September 1, 2022
Excel Formula using Write cell Activities datatable , excel , activities , question	1	868	February 5, 2021
How to write complex formulas in excel Activities excel	7	1586	February 5, 2021
Writing an excel formula adds '@' - Any workaround? Studio studio , question , activities_panel	4	414	September 28, 2023