is there a way that I can get the text value of a cell that contains a formula?
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?
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 .