writing excel formulas with blueprism ends in #NAME? error in the excel file

[Digital_WorkerB]

I have an excel file that I open with blueprism to add some simple data like text and formulas in certain cells.

I use get excel sheet as collection action for this and then I loop through the collection and edit certain "cells" of the collection.

For exporting back to excel I use the write collection action.

I tried writing these texts by using a simple calculation stage and also the set cell value action. Unfortunately both ways of writing the text bring the same result once I open the file in excel.

• writing simple text into a cell works
• writing simple formulas in a cell e.g. =L2 works

But when I write a formula like: =SUMME(L2:L4) into a cell Excel displays #NAME? in the cell when I open then excel file to see the result. (see screenshot)

When I double click the cell with the #NAME? in it, excel suddenly acknowledges the formula and switches the #NAME? to the correct result of the formula.

screenshot of excel result

My questions are:

Is there a way to write formulas with blueprism that the #NAME? error does not happen ?

Is there a way to force excel to refresh the #NAME? cells so that the formula appears and I dont have to doubleclick every cell that has #NAME? in it ?

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Marco.

[ewilson]

This might be a locale issue. I assume the function "SUMME" is the German version of SUM? I've just tested writing a summation formula to a cell (=SUM(A1:B1)) to a cell and it worked fine.

What version of Blue Prism are you using?

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------