Excel cannot Write Cell with non-english formulas

Help
, ,
1

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

2

Hi @mchavez_pe

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

3

Hi bro,

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

Regards.

4

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

6

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?

7

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

8

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
10

Hi,
this is the solution.

Regards

1 Like
11

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