How to Fill Empty Cell

<< Click to Display Table of Contents >>

Current:  Common Analysis Scenarios 

How to Fill Empty Cell

Previous pageReturn to chapter overviewNext page

When the table contains blank cells, the blank cell in the table can be filled with "-" to make it more convenient for the user to read the table data.

Take the following table as an example.

table

1. Select the blank cell and click the General tab on the right to enter the general pane.

filltable

2. Select [Highlight] to open the Highlight window.

3. Click the button addhighlight to add a new highlight.

4. Set the filter condition for highlight that sales_sum is null.

highlightcondition

5. Set the highlighted format. Select the "Text" format and set the text content to "-".

highlightformat