I have the following code in VB.net: The template file.xls has a formula in cell m11 (=m4)...
Dim Excel as new Excel
Then later on I use aspose.cells to check the same Excel file for the value of cell m11. There is no value. If I open the file.xls with Excel, the cell calculates as expected. Then if I once again use aspose.cells to check m11 obviously I get '99'.
How can I get the routine above to force execution of formulae in cells without opening the file in Excel to look at it?