Free Support Forum - aspose.com

SUMPRODUCT in formula displays #Value! error

I have a formula that doesn't calculate until I "touch it" (ie. click on the cell, press F2, enter). Seems to be an issue with SUMPRODUCT, but not SUM...

Aspose.Excel v 3.5.3.0

Worksheet ws = x.Worksheets[1];
//works... string formula = "=SUM(F10:J10)";
//doesn't work... until touched
string formula = "=SUMPRODUCT(F10:H10,F16:H16)";
ws.Cells[1, 1].Formula = formula;

Thanks!

Please check the fix attached at http://www.aspose.com/Community/Forums/37593/ShowPost.aspx .