There is a excel template file with some formulas. First I use xlsIO to open the template in code.
Then I put some data into the template for the formulas and save the file in code behind.
After that I open the excel file, but the formula not work, unless I focus on the data of cell and lost focus on the data of cell.
How can I let formulas run automatically use xlsIO.