Trigger calculation in JavaScript API for Excel
<p>I am trying to use <a href="https://dev.office.com/reference/add-ins/excel/range?product=excel" rel="nofollow">JavaScript API for Excel</a>.</p>

<p>Does anyone know how to trigger <strong>calculation</strong> for a cell, a range, a worksheet or a workbook?</p>

<p>For instance, the following code selects a range, but how can we re-calculate the range?</p>

<pre><code>Excel.run(function (ctx) {
    var sheetName = "Sheet1";
    var rangeAddress = "F5:F10"; 
    var range = ctx.workbook.worksheets.getItem(sheetName).getRange(rangeAddress);
    range.select();
    return ctx.sync(); 
    });
}).catch(function(error) {
        console.log("Error: " + error);
        if (error instanceof OfficeExtension.Error) {
            console.log("Debug info: " + JSON.stringify(error.debugInfo));
        }
});
</code></pre>