locked
Problem with evaluate method RRS feed

  • Question

  • Hello,

    we have  a shared Addin wriiten in C# using the Excel Interop.

    For testing I use a german Excel 2016.

    Wenn I use the following code in the sheetactive event

     string result = "CONCATENATE(\"Feb\",\" YTD\")";
     dynamic res = ws.Evaluate(result);

    where ws is an Excel Workshhet object I get for res the value Feb YTD.

    Now there's also a C++/CLI extension and one mthod uses a delegate and this delegate is implemented in C# method getvalue.

    When then the above code is executed in the conetxt of the callback, then res get the value -2146826273 whcih means #VALUE.

    I already set CurrentThread.CurrentCulture and CurrentThread.CurrentUICulture to en-us.

    Has anyone ideas how to solve this problem ?

    tia

      Hendrik Schmieder

    Tuesday, July 28, 2020 1:29 PM