Read value cells with formulas

Question

Hi

I have an excel that have cells with some formulas. I trie to read those cells with open xml sdk code snippets, but i just get the text formula, not the value result of the formula. Does anybody know how to retrieve the value of a cell formula?

Thanks

Answer 1

Cell cell;

cell.CellFormula.CalculateCell.Value = true;