Excel Implicit Conversion Operator causing problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2224894%22%20slang%3D%22en-US%22%3EExcel%20Implicit%20Conversion%20Operator%20causing%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224894%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3EI%20am%20using%20an%20RPA%20Automation%20tool%20to%20write%20a%20FILTER%20formula.%20Problem%20is%20when%20I%20write%20that%20formula%20excel%20automatically%20adds%20the%20implicit%20conversion%20operator%20which%20makes%20my%20formula%20look%20like%20this%20%3A%20%3D%40FILTER(A2%3AS477%2CR2%3AR477%3D%22A%22).%3CBR%20%2F%3EI%20did%20not%20write%20that%20%40%20in%20the%20formula%2C%20that%20is%20something%20which%20excel%20added%20automatically.%3CBR%20%2F%3EI%20want%20to%20know%20how%20can%20I%20avoid%20this%20%40%20addition%20by%20excel.%3CBR%20%2F%3EI%20can't%20go%20ahead%20and%20manually%20delete%20this(which%20gives%20correct%20results)%20because%20I%20am%20using%20BluePrism%20RPA%20tool.%20So%20I'll%20be%20needing%20maybe%20a%20modification%20in%20the%20formula%20to%20get%20the%20same%20job%20done.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20advices%2Fsuggestions%20are%20welcome%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2224894%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Hi all,
I am using an RPA Automation tool to write a FILTER formula. Problem is when I write that formula excel automatically adds the implicit conversion operator which makes my formula look like this : =@FILTER(A2:S477,R2:R477="A").
I did not write that @ in the formula, that is something which excel added automatically.
I want to know how can I avoid this @ addition by excel.
I can't go ahead and manually delete this(which gives correct results) because I am using BluePrism RPA tool. So I'll be needing maybe a modification in the formula to get the same job done.

Any advices/suggestions are welcome
4 Replies

@Mani_ayush 

If that's exact formula and implicit intersection operator appears only if you use RPA, when afraid that question is more to BluePrism RPA people.

I guess what I am asking is : is there a way to not have @ added in excel? A way to bypass it?

@Mani_ayush 

Short answer - not. It is added automatically if calc engine suspect that dynamic arrays could be not supported, other words adds former silent implicit intersection in explicit form. That's only to rebuild formulas in pre-DA style. 

 

Another story why calc engine think so in your case if you open the file in 365 Excel. That's if only RPA affects somehow.

@Mani_ayush 

I forgot about this setting

image.png

Try to play with it if helps.