Write Cell Activity adds an ' to my formular

Help StudioX
,
1

Hi,
I start my write cell activity with the following value:

“=IF(E”+FirstEmptyRow.ToString+“>SVERWEIS(D”+FirstEmptyRow.ToString+“,Basisdaten!$A$2:$I$15,6,FALSCH)))”

But it adds an ’ around the value “FALSCH”:

“=IF(E”+FirstEmptyRow.ToString+“>SVERWEIS(D”+FirstEmptyRow.ToString+“;Basisdaten!$A$2:$I$15;6;‘FALSCH’)))”

How can I avoid that?

2

Hi @bibalesecret,

Maybe language difference can cause this.

Please check this topic. Uipath add simple quotes on an excel formula

Regards
Ömer

1 Like
3

Yes you are right! Thank you.
I translated FALSCH with WRONG and not with FALSE … my fault

1 Like
4

Hi @bibalesecret,

I’m glad it works.

Have a nice day.

Regards.
Ömer

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.