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 188.8.131.52
Worksheet ws = x.Worksheets;
//works... string formula = "=SUM(F10:J10)";
//doesn't work... until touched
string formula = "=SUMPRODUCT(F10:H10,F16:H16)";
ws.Cells[1, 1].Formula = formula;