Returning the value of a cells that contains a formula

Aspose.Cells Product Family
1

Hi there,



is there a way that I can get the text value of a cell that contains a formula?



Example

A1=“test”

B1=A1



if I use cells[0,1].StringValue I need to get “test” returned.

Is this possible, or is there a way that I can get around this?





Regards

Morne

2

Hi Morne,

Please call Excel.CalculateFormula method before retrieving formula result values.

For more information, please check