@ in excel formulas, only when running from orchestrator

Help Orchestrator
,
1

Hello!

I need help with the following issue: I’ve created a workflow where the robot needs to fill in formulas in excel and autofill the rest of the range column.

I developed the automation locally and after publishing and running it from orchestrator, I noticed that the columns where the formulas are being used, gave an error as result. After investigating why this happened, I noticed that suddenly in excel, an @ appeared in front of the formula, causing them to throw the error. After manually removing the @ the formulas work fine.

This issue only happens when running the process from orchestrator, locally it runs as expected. I have already searched similar topics and have tried to put the syntax of String.Format(“=ExcelFormula”) but this only works locally when testing and not when running from orchestrator. The result in excel then is =@ExcelFormula. I also looked at the language in which the formula is being written (as the @ can also be an effect of the formula being written in a particular language) but this is not the issue here as I use English for writing the formulas.

The version of Studio I’m currently using is 2023.8.0.
Excel version is Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit.

Any help would be appreciated, thanks in advance!

Kind regards, Job