Problems with some formulas in Excel OLE2 Object

[Former Member]

Hi experts,

I need to write the several formulas inside some cells in Excel. Simple arithmetic like "=X1$Y$1" works fine, but i got fail with some built-in excel function. When i try to write formula which contains "ROUND" (f.e. "=ROUND(X1Y2;2)") or "VLOOKUP" (f.e. VLOOKUP(U9;W:Y;3;FALSE)) functions i receive SY-SUBRC = 3, and then cell is empty. But for example "=SUM(X1:X100)" works without any problem.

I use SET PROPERTY OF g_cell 'Formula' = form. I use Excel 2010.

What is the problem?

Thanks in advance.

Edited by: Vl89gm on Sep 29, 2011 7:30 PM

[Former Member]

Hi experts,

I need to write the several formulas inside some cells in Excel. Simple arithmetic like "=X1$Y$1" works fine, but i got fail with some built-in excel function. When i try to write formula which contains "ROUND" (f.e. "=ROUND(X1Y2;2)") or "VLOOKUP" (f.e. VLOOKUP(U9;W:Y;3;FALSE)) functions i receive SY-SUBRC = 3, and then cell is empty. But for example "=SUM(X1:X100)" works without any problem.

I use SET PROPERTY OF g_cell 'Formula' = form. I use Excel 2010.

What is the problem?

Thanks in advance.

Edited by: Vl89gm on Sep 29, 2011 7:30 PM

[Former Member]

are you using semi colons between your parameters in the formula, rather than commas?

[Former Member]

You are genius. I changed ";" to "," in formulas and it works. Great thanks.