- SAP BusinessObjects Dashboards 4.1 Cookbook
- David Lai Xavier Hacking
- 203字
- 2021-07-23 19:44:00
Debugging the spreadsheets
It is common that SAP BusinessObjects Dashboards developers may accidently put in the incorrect formula when developing logic on their spreadsheets. Using the Ctrl + ` hotkey will make things much easier.
How to do it...
- Select the worksheet you want to see formulas for.
- Hit the Ctrl + ` (grave accent) hotkey.
- You will see the value in the cell change to the formula.
How it works...
The Ctrl + ` hotkey works by showing the underlying formula of a cell. This is extremely useful if you are comparing formulas from multiple cells, as the developer does not have to flip between formulas in order to see what they are doing wrong when comparing multiple cells. Developers can quickly analyze their worksheet and find the cause of their problem.
The following screenshot shows the results of two Excel formulas in cells A1 and A2:
After using the Ctrl + ` hotkey, the formulas of both cells are displayed, as you can see in the next screenshot:
- HTML5+CSS3+JavaScript從入門到精通：上冊（微課精編版·第2版）
- Android應(yīng)用程序開發(fā)與典型案例
- 信息可視化的藝術(shù)：信息可視化在英國
- Learning RxJava
- PostgreSQL Cookbook
- Internet of Things with Intel Galileo
- 單片機(jī)應(yīng)用與調(diào)試項目教程（C語言版）
- Swift細(xì)致入門與最佳實踐
- Spring Boot+Vue全棧開發(fā)實戰(zhàn)
- 時空數(shù)據(jù)建模及其應(yīng)用
- Java EE架構(gòu)設(shè)計與開發(fā)實踐
- 例解Python：Python編程快速入門踐行指南
- 用Go語言自制編譯器
- Python深度學(xué)習(xí)入門：從零構(gòu)建CNN和RNN
- Visual Basic程序設(shè)計