Returning the value of a cells that contains a formula


#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 http://www.aspose.com/Wiki/default.aspx/Aspose.Excel/FormulaCalculationEngine.html .