Free Support Forum - aspose.com

Add formula via api?

I am in the process of evaluating aspose.excel. I am trying to add a formula to a cell via api.
My code is something like the following:

cells[startRow+dtInvoice.Rows.Count,4].PutValue("=SUM(E"+iStartRow.ToString()+":E"+iEndRow.ToString()+")");


The problem is that the cell output the string as a result rather than take it as a formula.How can I solve this problem.Thanks

Never mind,found that there is a formula property