Free Support Forum -

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

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;


Please check the fix attached at .