Hello,
Thanks for your inquiry!
The difference between the FormulaValue and EnvalutedValue is: the FormulaValue is a
static method, it just shows the current value displayed before you read the workbook by our Spire.Xls, while the EnvalutedValue is
dynamic, it will show the calculated value that based on the data before you use the method.
For example, when I set the formula in A1 is B1*C1, the value of B1 is 1, the value of C1 is 5, and the current displayed value of A1 is 5.
- insheet.png (4.28 KiB) Viewed 2886 times
Then I loaded the workbook and changed the value of B2 to 2 through the code, the result of FormulaValue is still 5, but the value displayed by EnvalutedValue is 10.
- difference.png (15.99 KiB) Viewed 2886 times
What's more, for the issue of "#Recursive reference!" when use "EnvalutedValue", it most likely depends on the data in your workbook and the operation in your project. To help us reproduce your issue, please provide us with your input file and test code, thanks in advance.
Sincerely,
Marcia
E-iceblue support team