Show Formulas Instead of Values in a Worksheet
Contents
[
Hide
]
It is possible to show formulas instead of calculated values in Microsoft Excel using the Show Formulas option from the Formulas ribbon. When formulas are shown, Microsoft Excel displays formulas in the worksheet. You can achieve the same thing using Aspose.Cells.
Aspose.Cells provides a Worksheet.ShowFormulas property. Set this to true to set Microsoft Excel to display formulas.