June 25th, 2004, 12:44 pm
I am trying to set a formula to a range using the IDISP_range.OlePropertySet (the same as Invoke with DISPATCH_PROPERTYPUT) but Excel crashes after the first use. In fact, Excel starts a kinf of endless looping and stop calculation at all.Here is some pieces of my code in C++ (Builder 6):*********************************************String formula;formula="=1";Variant range;//Some code to take rangel IDispatch...cell.OlePropertySet("Formula", formula.c_str()); //Works fine//Try again and crashescell.OlePropertySet("Formula", formula.c_str()); //Ole call never returns!! ************************************************I got the same when using GetDisp and Invoke functions.Any help?Tx in advance!