I'm still evaluating Aspose.Cells for .NET 126.96.36.199. I've attached a multi-sheet XLS file generated by my application using Aspose. The code simply creates various sheets, stores values and formulas, and saves the file. Note that in most of the cells with formulas Excel 2003 displays #VALUE! instead of the calculated result. If I go to cell E6 on the Inputs worksheet, for example, I see that it shows the formula "=D6". D6 has a number in it. If I type the F2 key and hit enter, without making any edits to the formula, the correct value is displayed. Thus, the formula itself seems to be correct but for some reason the calculation was suppressed.
Adding a CalculateFormula call before saving doesn't fix the problem. What I would like to have happen is for the entire workbook to be recomputed when first loaded into Excel so that the values are numerically what Excel wants them to be.
The underlying application code works fine when run against the Excel COM interface.