I found that when i assign a formula in a cell, say :
cell[1, 1].Formula = "1+1";
the value of the cell (cell[1,1].value) is null.
even i save the file and then reload the file, the value is null.
I can only get the right value (in this case "2") if i open the saved file by Micrsoft EXCEL
and then save it again with Micrsoft EXCEL.
After the above step, when i open the file again by the C1Excel, it can get the value "2".
Is there any method that help me to get the calculated value without using Micrsoft EXCEL?
Thank a lot,