Use Show Formulas Feature of GridWeb
Contents
[
Hide
]
Sometimes, you need to find an easy way for the cells containing formulas. You need to have an approach to quickly read through all formulas to check for errors. This can help you to trace the data being used in a formula.
Aspose.Cells.GridWeb provides the feature what is called Show Formulas in Microsoft Excel.
Using Show Formulas Feature
All you need to use a shortcut “CTRL + ~” to display all the formulas in the worksheet.
For example, we load a template file into the GridWeb which has formulas in the C column, here is the code we simply used to load the file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Gets the web application's path. | |
| string path = (this.Master as Site).GetDataDir(); | |
| // Clear the sheets | |
| GridWeb1.WorkSheets.Clear(); | |
| // Load the file | |
| GridWeb1.ImportExcelFile(path + "\\Articles\\source.xlsx"); |
The file is loaded into the GridWeb and we can see a sheet with all the values in the picture below.
After pressing CTRL + ~, all formulas are displayed.
