topic Re: Formula in OLE2 Objects in Application Development and Automation Discussions

Formula in OLE2 Objects

lydia_martinezmartinez — Mon, 26 Sep 2011 08:31:01 GMT

Hi experts,

I want to know how I can define a formula in ole2 objects.

I had done the next steps:

1º) I define the next formula A1-SUMA(B1:E1)

2º) Add the formula to the object, in this case I used two options

a) SET PROPERTY OF g_cell 'Formula' = form.

b) SET PROPERTY OF g_cell 'Value' = form.

But, in both cases, when I open the excel document this formula give me an error #¿NAME?.

What is the problem?

Thanks in advance.

Former Member — Mon, 26 Sep 2011 08:50:08 GMT

you use ole already. why don't you calculate in code and write to excel manually?

lydia_martinezmartinez — Mon, 26 Sep 2011 09:09:09 GMT

Thanks Tolga, but I have to use OLE because the excel could be modify by the users and it has to recalculate the result.

I resolved my proble, I use the key word SUM instead of SUMA.

Thanks anyway!

Former Member — Mon, 26 Sep 2011 09:15:01 GMT

Hi,

Use the property FORMULA only, and add an '=' sign in front of the formula.

added: didn't see you've solved it

Kr,

Edited by: Manu D'Haeyer on Sep 26, 2011 11:15 AM