Formulas in Excel spreadsheet do not calculate until “Enable Editing” is clicked

Question

When export the excel, the formulas was not calculating until “Enable Editing” is clicked in Excel spreadsheet.

Am using below code for cell formula:

            var cellFormula = new CellFormula();  
            cellFormula.Text = value?.ToString();  
            result.CellFormula = cellFormula;