Cell Progress Bar Plugin

Version

Application Scenario

You may hope that cells display data or levels in the progress bar format to present the trend, bottleneck, progress and other information of data during report design, facilitating further data analysis.

Function Description

You can display data in the progress bar format in cells through the Cell Progress Bar plugin. Supported data formats include integer, decimal, percentage, and ¥**.

Note:

You can also use HTML to display progress bar styles. For details, see Graphical Display of Data (Progress Bar/Level).

Plugin Installation

You can obtain the plugin at https://community.finereport.com/market/.

For details about how to install plugins in the designer, see Designer Plugin Management.

For details about how to install plugins on the server, see Server Plugin Management.

Procedure

After plugin installation, select a cell and choose Cell Attribute > Display > Progress Bar in the right attribute panel. Then you can set the attributes of the progress bar, as shown in the following figure.

You can also choose Conditional Attribute > Display > Other Displays > Progress Bar. The specific attribute settings are consistent with those in Cell Attribute.

Usage Scenario

1. Progress bars can be displayed on mobile terminals.

2. Suppose that conditional attributes are set for a template.

• On PC, progress bars can only be displayed during data entry preview and data analysis preview, rather than pagination preview.

• On mobile terminals, progress bars can only be displayed during data entry preview, rather than pagination preview and data analysis preview.

3. Suppose that the content of a cell is a formula.

• Progress bars can be displayed if Retain Formula for Calculation During Data Entry/Analysis is unticked.

• Progress bars can only be displayed during pagination preview if Retain Formula for Calculation During Data Entry/Analysis is ticked.

4. Progress bars can be displayed during printing/exporting (except for exporting to Excel).

5. Progress bars support table components for FineVis visualization dashboards.

6. You can set the display of progress bars for report blocks in dashboards of the earlier version in Cell Attribute, rather than in Conditional Attribute.

7. Dashboards of the new version do not support the Cell Progress Bar plugin.

8. Task schedule pushes do not support the Cell Progress Bar plugin.

9. Engine-X does not support the Cell Progress Bar plugin.

You can set the following attributes of the progress bar: Color, Fill, Background Color, Width, Rounded Corner, Direction, Max Value, Hide Data, and Negative Number.

Color

You can select the color (default color: blue) of the progress bar.

Fill

You can set the filling effect of the progress bar to Gradient or Solid (default setting).

Background Color

You can select the background color (default color: gray) of the progress bar.

Width

You can set the width of the progress bar to any value equal to or greater than 0 (default value).

Rounded Corner

You can set the rounded corner size of the progress bar to any value equal to or greater than 0 (default value).

Direction

You can set the display direction of the progress bar to Left to Right (default setting) or Right to Left.

Max Value

You can set the max value of completely filled progress bars to Default or Custom.

1. Default: The longest progress bar is determined by the max value of the extended data.

2. Custom: You can customize the longest progress bar by entering one Integer, Double, or Formula.

For example, the extended data of the cell is the sales volume ranging from 2708 to 4522.

If Max Value is set to Default, the progress bar of 4522 is the longest and filled completely.

If you set Max Value to Custom and enter 4000, progress bars of values greater than 4000 are filled completely, as shown in the following figure.

Note:

If the cell is not expandable, you must set Max Value to Custom and specify the max value, otherwise all progress bars share the same length.

Max Value	Difference	Example Graph
Default	Only the progress bar of the max value is filled completely.
Custom	Progress bars of values greater than the custom value are filled completely.

Hiding Data

You can determine whether to display the corresponding data of progress bars.

1. If Hide Data is unticked (default setting), progress bars and data are displayed.

2. If Hide Data is ticked, only progress bars are loaded and the cell data is not displayed during template preview.

Negative Number

You can set the display method of negative numbers to Ignore or Custom.

Ignoring Negative Numbers

If Ignore (default setting) is selected, progress bars of negative numbers are not displayed during preview.

Customizing Negative Numbers

If Custom is selected, you can set the Color, Fill, Min Value, Divider Position, and Divider Color.

1. Color: You can set the color of the progress bar for negative numbers in the same way as in section "Color."

2. Fill: You can set the fill method for negative numbers to Gradient or Solid in the same way as in section "Fill."

3. Min Value: You can set Min Value to Default or Custom in the same way as in section "Max Value."

4. Divider Position: You can set the position of dividers separating positive and negative numbers to Auto Based on Value or Cell Center.

• Auto Based on Value (default setting): Progress bars for the minimum negative number and the maximum positive number are both filled completely.

• Cell Center: Dividers remain in the middle of cells and the progress bar of the value which has the maximum absolute value among positive and negative numbers is filled completely. The length ratio of progress bars of other cells is calculated based on the max value.

5. Divider Color: Dividers are dashed lines (non-modifiable) and the color of dividers is black (modifiable) by default.

Render Mode

Note:

 Only general reports of earlier frontend on PC support the Render Mode function, and cells with embedded elements such as superscripts and subscripts temporarily do not support the Frontend Render function.

The Render Mode parameter includes two values: Frontend Render and Image Mode. If you tick Dynamic Expansion in the frontend render mode, progress bars will display a gradual animation effect during loading.

The comparison effects and differences between Image Mode and Frontend Render are as follows.

• When multiple progress bars exist in a template, the template boasts faster loading in the frontend render mode.

• Progress bars zoomed in have jagged edges in the image mode but have no jagged edges in the frontend render mode.

• Dividers are thinner and spacing is smaller in the frontend render mode than those in the image mode.

Color

Download the template: Cell Progress Bar-Color.cpt.

Fill

Download the template: Cell Progress Bar-Fill.cpt.

Background Color

Download the template: Cell Progress Bar-Background Color.cpt.

Width

Download the template: Cell Progress Bar-Width.cpt.

Rounded Corner

Download the template: Cell Progress Bar-Rounded Corner.cpt.

Direction

Download the template: Cell Progress Bar-Direction.cpt.

Max Value

Download the template: Cell Progress Bar-Max Value.cpt.

Hiding Data

Download the template: Cell Progress Bar-Hide Data.cpt.

Negative Number

Ignoring Negative Numbers

Download the template: Cell Progress Bar-Ignoring Negative Numbers.cpt.

Customizing Negative Numbers

Download template: Cell Progress Bar-Customizing Negative Numbers.cpt.

Impact of the Cell Background Color

The cell background color can affect the display of cell progress bars, as shown in the following table.

Impact of the Browser Background Color

Suppose that you have set the browser background color for an aggregation report by choosing Template > Web Attribute > Browser Background > Color.

Then the selected browser background color will also become the background color of progress bars.

Impact of the Collapse/Expand Button

Suppose that hierarchical relationships of collapse/expansion exist for the rows where cell progress bars are located. If Max Value is set to Default, the max value is based on the level where the cell is located in the current displayed view.

To avoid this situation, you can choose Cell Attribute > Display > Progress Bar and set Max Value to Custom, as shown in the following figure.