MMULT issue in version 10

MMULT issue in version 10

Posted by: ecd1973 on 8 September 2017, 3:25 pm EST

• 

  ecd1973

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 3:25 pm EST

  I have a formula that works in excel but returns VALUE! in Spread vb.net

  =SQRT(MMULT(MMULT($L$3:$AM$3,‘Premium Correlations’!$B$2:$AC$29),‘C2.B’!E3:E30))

  Premium Correlations is a 28x28 range on another tab. L3:AM3 is a 28 item row and E3:E30 is a 28 item column.

  Does Spread support this MMULT embedding?

• 

  deepaksharma14

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 3:25 pm EST

  Hello,

  I am able to replicate this issue at my end. I will inform the concerned team about the “#value” error when embedding MMULT formula . I will update you once I get any information about the same.

  Regards,
  
  Deepak Sharma

• 

  deepaksharma14

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 3:25 pm EST

  Hello,

  I have submitted it as a bug to development team. The bug id for this issue is #235878.

  Regards,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 December 2017, 3:26 am EST

  Hello,

  This issue is fixed in our latest release of Spread .NET i.e. v11.0.
  
  You can download the same from our website.

  Thanks,
  
  Deepak Sharma