I'm evaluating Aspose.Cells for .NET. My problem has to do with an array function. The function is:
SetArrayFormula(string.Format("=SUMPRODUCT(IF(ISNUMBER(C{0}:C{1}),D{0}:D{1}),IF(ISNUMBER(C{0}:C{1}),C{0}:C{1}))/SUM(IF(ISNUMBER(C{0}:C{1}),D{0}:D{1}))", startRow, endRow), 1, 1)
When I open the Excel sheet there is a value in the cell, but it is incorrectly calculated. When I "edit" it and hit CTRL + SHIFT + ENTER myself, the value is then correct. I was using Aspose.Cells 4.5.0.0, but I came across 4.5.0.13 on the forums but the problem is still there.
I have attached a copy of my problem from my original test. The value at the bottom should equal -4.8%.
-Damien