We have recently upgraded our Aspose version from 7.5 to 18.5.1. As a result the newest version is incorrectly return the result when using:
var value = sheet.CalculateFormula(sheet.Cells[6, 21].Formula);
When looking at the sheet the formula parsed is correctly executed, however from a .net side the value is not calculated.
Attached is the spreadsheet in question. AsposeTestSheet_20180821.zip (13.5 KB)