- 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:
- Android Wearable Programming
- 自己動手寫搜索引擎
- PyTorch自動駕駛視覺感知算法實戰
- PHP 7底層設計與源碼實現
- 深入淺出Java虛擬機：JVM原理與實戰
- Instant 960 Grid System
- Django Design Patterns and Best Practices
- Mastering Yii
- Python高效開發實戰：Django、Tornado、Flask、Twisted（第3版）
- 零基礎入門學習Python（第2版）
- 執劍而舞：用代碼創作藝術
- Python機器學習算法: 原理、實現與案例
- TMS320LF240x芯片原理、設計及應用
- Kubernetes進階實戰
- 貫通Tomcat開發