Clear Range
The Clear Range function clears various elements of the Apply To range.
Settings | |
|---|---|
Clear | All Everything the range is cleared including content and any applied formatting. |
Contents The content of every cell in the range is cleared. This is the equivalent of highlighting a range of cells and pressing the Delete key. | |
Formats All formatting including font size, style, color as well as background color and any conditional formatting is cleared from the cell. The content in the cells remains. | |
Errors This option clears cells containing the error #REF or #DIV/0! In the case of #DIV/0 the cell content is cleared. In the case of #REF the part of the formula that is causing the #REF is removed to correct it. For example, if cell contains the equation =$A$3+$A$4+#REF then it will become =$A$3+$A$4. If the formula cannot be corrected, then it is cleared. | |
Example
A live dashboard template is configured which always shows the last 10 temperature readings from a tank with the most recent value on top and the previous 9 below. The data connection that brings in the temperature is set up to Insert At Start with a Direction of Down. Since 10 values need to be shown the report cannot be overwritten every time but once 10 rows are filled, for every update the 11th value should “drop off” leaving the last 10. This can be accomplished using a Clear Range function. If the value starts in cell $B$4 the 10th value is in $B$13. The settings for the function are:
Apply To | |
|---|---|
Cell | $B$14 |
Direction | Down |
Setting | Value |
|---|---|
Clear | All |