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,0)”
How can I get rid of “@” from being added ?
Thanks
this looks like a bug.
can you please give more details? studiox version, excel package version?
Excel package version: 2.9.0-preview.
StudioX 2020.6.0-beta.93 Community License.
For now try reverting your packages to stable versions like this:
a fix will be available in next release
Hi @studioX may I know if the fix has been released? I am on excel package version 2.9.3, 2020.10.2 community license and am facing the same issue of having a “@” inserted into my Write Cell formulas, kindly advise thanks!
can you update to any beta version over 2.9.3 excel? fix should be there. maybe it’s another issue.
can you post the expression from advanced editor?
Hi @studioX, I tried updating to 2.9.3-beta.1188448 but the bug still occurs. This is what I am running in Write Cell:
This is my formula in UiPath:
“=IFERROR(IF(D”+Last.ToString+“=”“XXX”“,(VLOOKUP(LEFT(N”+Last.Tostring+“,51),LEFT($N$1:$N”+Lastminus1.ToString+“,51),1,FALSE)),IF(D”+Last.ToString+“=”“XXX”“,”“DELETE”“,IF(D”+Last.ToString+“=”“XXX”“,IF((INDEX($G$1:$G”+Lastminus1.ToString+“,MATCH(1,(C”+Last.ToString+“=C:C)*(D”+Last.ToString+“=D:D),0))=G”+Last.ToString+“),”“DELETE”“,”“LEAVE”“),VLOOKUP(N”+Last.ToString+“,$N$1:$N”+Lastminus1.ToString+“,1,FALSE)))),”“LEAVE”“)”
This is my intended output in Excel:
=IFERROR(IF(D10132=“XXX”,(VLOOKUP(LEFT(N10132,51),LEFT($N$1:$N10131,51),1,FALSE)),IF(D10132=“XXX”,“DELETE”,IF(D10132=“XXX”,IF((INDEX($G$1:$G10131,MATCH(1,(C10132=C:C)*(D10132=D:D),0))=G10132),“DELETE”,“LEAVE”),VLOOKUP(N10132,$N$1:$N10131,1,FALSE)))),“LEAVE”)
This is the actual output with “@” appearing:
=IFERROR(IF(D10132=“XXX”,(VLOOKUP(LEFT(N10132,51),LEFT(@$N$1:$N10131,51),1,FALSE)),IF(D10132=“XXX”,“DELETE”,IF(D10132=“XXX”,IF((INDEX($G$1:$G10131,MATCH(1,(C10132=**@C:C)*(D10132=@**D:D),0))=G10132),“DELETE”,“LEAVE”),VLOOKUP(N10132,$N$1:$N10131,1,FALSE)))),“LEAVE”)
Please kindly advise, thanks!
which office/excel version are you using?
might be a problem because of office2010.
it’s working fine for me your expression on office2019. let me try on office 2010 and will get back
can you attach the workflow where you get the error? or a simplified version of it?
i’m not able to reproduce and it’s odd that you using office 2010 you get the @ since office 2010 should not know about that
I am getting the error that new users are unable to attach a workflow 
Please find a screenshot here:
It is strange cause my other formulas in the same workflow (SUM, CONCATENATE, etc) do not face this problem @studioX
@loginerror can we get some help here? we need the workflow please
Hi @Nette
Please try again now 
Thanks @loginerror! Here you go @studioX - I replaced the workbook/sheet names with generic ones instead but the rest of the formulas etc are the original ones. Appreciate your help!
Workflow with Error.xaml (34.7 KB)
Hi @studioX, any luck on your end on solving this bug? Thanks! 
this is under investigation, the fix i was mentioning above is only in studiox, your project is Studio.
Hi @studioX! Hope you are doing well, just wanted to check in and see if there is any update on the investigation for the bug in Studio? Thanks!
a fix is available in studiox, but the project you attached is in studio, using studio activities, a bug was raised and will be investigated for future releases.
in your project you are using write cell from studio instead of write cell from studiox.
somehow you started with a studiox project, but opened in studio and used studio activites
Yoichi
Anil_G
SorenB
sven.wullum1
jast1631
takehiro.ichikura
sharazkm32
A_Learner
ashokkarale
pradeep-shukla