Regarding excel formula write and drag

[Barboraurbinova]

Dear All,
I have one query and need to write formula in the cell and then drag it to down.
Steps, what I used - Create instance - Open workbook - Show Workbook - Set cell Value and so on.......
.
But after running it and when it reached to Set Cell Value stage then error appears....

If dear members have some spare time then any kind of support, help or assistance will be highly appreciated.
Thanks in advance to all.

With Regards,
B

------------------------------
Barbora urbinova
------------------------------

[JacobClary · Accepted solution]

Hey Barbora, I hope you are doing well today. 

This issue in particular is not caused directly by Blue Prism, but instead this issue is coming from Excel and displaying within Blue Prism.

Here is a KB article we have about it. It is a somewhat generic Excel error so it will require further digging on the Excel side of things. I hope this info helps some!

------------------------------
Jacob Clary
Customer Support Engineer
Blue Prism
------------------------------

[MichealCharron]

@Barboraurbinova

Looking at your screenshot, it appears you are separating your parameters in the Excel Concatenate function with a semi-colon. Parameters in Excel formula functions should be separated with a comma.​

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

[ManpreetKaur1]

Hi @Barboraurbinova,

It seems the formula is incorrect. The correct formula should be "=CONCATENATE(A2,B2)" i.e. comma should be used instead of semi-colon. Also, if you want to perform drag and drop functionality as well, you can refer below youtube video:

https://www.youtube.com/watch?v=b_H-Zy_TJ4M&t=56s​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

[Barboraurbinova]

Hi Manpe,
Thank you so much for your suggestion and you are absolutely right BUT in my excel there is a setting like that and I have to use semicolons instead of coma.
As manually, when I'm writing this formula in excel with semicolons, it's working perfectly fine.
But when trying with BP then the same error appears as I shared.

With Regards,
B

------------------------------
Barbora urbinova
------------------------------

[Barboraurbinova]

Hi Mike
Thank you so much for your suggestion and you are absolutely right BUT in my excel there is a setting like that and I have to use semicolons instead of coma.
As manually, when I'm writing this formula in excel with semicolons, it's working perfectly fine.
But when trying with BP then the same error appears as I shared.

With Regards,
B

------------------------------
Barbora urbinova
------------------------------

[MichealCharron]

@Barbora urbinova,

Then your regional setting would have a list separator value of ";". Unfortunately, working through COM you would have to treat it ​​as having a setting of "," because the regions settings are ignored. It should translate it automatically once it gets to the Excel worksheet.

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------