Excel cannot Write Cell with non-english formulas

Hi guys,

i have problem when i tried write cell a function,
“=SI.ERROR(PROMEDIO(C4:F4),”")"

the error is, the range does not exist

any help

Regards

Hi @mchavez_pe

Could you maybe attach the sample project that reproduces the issue?

Hi bro,

attachment .zip
any help, please?
SAMPLE01.zip (31.5 KB)

Regards.

Thank you. I can see what the issue might be here.

Could you try with the Write Cell of the workbook activity instead of the Excel Application Scope one?
image

Hi @mchavez_pe

Actually, I traced the issue to the formula. It worked for me with a simple
=SUM(C4:F4)

Could you give a simpler formula a try? Also, could you give a try with this one I posted above just as a test?

Hi, when i trieded activity write cell within of the Excel Application Scope,
= SUM for each row,
if this work,

So, English formula worked correctly? If this is the case, it would seem that the Write Cell activity does not handle formulas in other languages, which is strange.

I will report it as a bug.

A workaround would be to use English formulas…

1 Like

Hi,
this is the solution.

Regards

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.