epplus Creating formulas and calculate ranges Manual calculation
Example
If you use formulas, Excel will ask you to save the file every time, even if there were no changes made. To prevent this behaviour you can set the calculation mode to manual.
excelPackage.Workbook.CalcMode = ExcelCalcMode.Manual;
//fill the sheet with data and set the formulas
excelPackage.Workbook.Calculate();
