Resolve formula from cell names into formula with values

Hello,

is it possible to resolve a formula that has the following format?

var cell = sheet.Cells["A1"];
cell.Formula // =SUM(A2;B2) and A2 has the value 1; B2 has the value 2

into

=SUM(1;2)

So that I see the values instead the cellnames?

@mservdev

Thanks for using Aspose APIs.

It seems you are seeking Evaluate Formula feature as shown in this screenshot.

We are afraid, this feature is not available.

But you can get the whole value of the formula after calling the Worbook.CalculateFormula() method and then using the Cell.StringValue property.


Please note, once you invoke Worbook.CalculateFormula() method, you will be able to see the resulting value of the formula in Debug Tooltip as shown in the following screenshot.