topic RE: Regarding excel formula write and drag in Product Forum

Regarding excel formula write and drag

Barboraurbinova — Tue, 03 May 2022 18:08:00 GMT

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
------------------------------

RE: Regarding excel formula write and drag

JacobClary — Tue, 03 May 2022 21:31:00 GMT

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
------------------------------

RE: Regarding excel formula write and drag

MichealCharron — Wed, 04 May 2022 00:59:00 GMT

@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
------------------------------

RE: Regarding excel formula write and drag

ManpreetKaur1 — Wed, 04 May 2022 06:30:00 GMT

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
------------------------------

RE: Regarding excel formula write and drag

Barboraurbinova — Wed, 04 May 2022 06:57:00 GMT

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
------------------------------

RE: Regarding excel formula write and drag

Barboraurbinova — Wed, 04 May 2022 06:58:00 GMT

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
------------------------------

RE: Regarding excel formula write and drag

MichealCharron — Wed, 04 May 2022 13:01:00 GMT

@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
------------------------------