As per previous post I have discovered the bug, if you create a formula in aspose such as
1. stringForumla="=(1+7)-(4)+(2)+(2)+(2)" ;//result should be 10 but is -2
Then the result is -2, if you, in excel work with this formula the result is10
If you however bracket the first sum such as
2. stringForumla="=((1+7)-(4))+(2)+(2)+(2)" ;//result should be 10
Then this works. Thus excel is using one order of preference and aspose another. If when aspose has created the sheet you go in and edit the first formula, leaving the result the same as the formula then the result is correct.
Can you let me know when we can have a fix for this, we have a global financial report that is incorrect at the moment, and there is a lot of pressure from management for a fix
Thanks for the fix launrence, this works, I dont suppose you have a release of this code which is bacwardly compatible with version 2.5.3.1, the changes that break are the constructor of the excel object, you cant pass in the license file, and setactiveworkbook has gone. Its just that Im mid way through a release which hasnt been fully tested, and if we can just release the aspose dll, it would be really handy
Do you use the latest hotfix v3.0.3? The formula bug is fixed.
About the Excel constructor issue, we upgrade our license schema since 01/22/2005 to make license trouble free. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.License.html. It shows how to set license in current version.
About SetActiveSheetIndex method, now you can use Worksheets.ActiveSheetIndex property for the same purpose. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Worksheets.ActiveSheetIndex.html.