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
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