Error asigning formula to excel

[Antoal (Antonio Alonso)]

Dear all,

Is my first day working here, sorry if I’m not using well this forum but I have been looking the solution for the problem for a couple of days and I’m desesperated.

Im in the last challenge of the RPA Citizen Developer Fundation

I do my formula in excel and is adding correctly to the excel, but it gives an error as NAME?

It appears in this way

But If I do clic in the tick it changes and works

Any clue how to solve it? Or any tip, Its been a couple of weeks on UiPath and I’m enjoying but I’m totally stucked.

Kind regards

[Anil_G (Anil Gorthi)]

@Antoal

Is it possible to send a sample flow and an excel you are using to check

Alternately …can you click on the plus and open advanced editor and show what does the formula look like in the write cell

As per screenshot looks like write cel is working as expected and autofill range is failing…is it so?

Cheers

[Antoal (Antonio Alonso)]

Dear Anil,

First thanks, Do you mean this plus editor

BookInventory.xlsx (29.7 KB)
WeeklySales.xlsx (60.4 KB)

Main.xaml (12.3 KB)

I hope with this examples are enought to clarify, if it can give you a clue, this is the example I’m following

Microsoft Excel Automation in StudioX

[Antoal (Antonio Alonso)]

Dear @Anil_G

I can’t believe it, Just few minutes later I made a change that has fixed all, the thing is that I have UiPath English version and Excel in spanish, then I need to write all the information for the formula in english to be pasted in the correct way

A silly thing that have had me stucked for days, I hope it helps for the rest of people.

Kind regards

[Anil_G (Anil Gorthi)]

@Antoal

These differences sometimes are costly on time…

glad you were able to resolve

Happy Automation

Cheers