I. Overview
1) Problem description
When filling in with a cell widget, if the widget data dictionary sets the actual and display values, the cell will end up displaying the actual values when the widget is out of focus. What if you want to retain the displayed value after filling in?
2) Implementation roadmap
When the cell widget is filled in and out of focus, the program sends the actual value corresponding to the input value of the widget to the cell and displays it. Therefore, you only need to modify the Attribute of the cell where the widget resides, set thedata dictionary for it, and set the actual value and display value to be consistent with the widget data dictionary to solve the above problems.
Note: The actual values submitted to the library are always not affected by the scheme settings
II. Example
This section uses the Product table in the built-in database FRDemoEN as an example.
1) Template design
Add drop-down box widgets to cells A2 and B2, as shown below:
The data dictionaries for widgets in cells A2 and B2 are set as shown below:
2) Set the cell attribute
Select cell B2, select "Data Dictionary" in "Cell Attributes>Display ", as shown below:
3) Effect preview
Save the template and click Data Entry Preview to preview. The A2 widget is out of focus and displays the actual value, while the B2 widget is out of focus and displays the displayed value.
III. Download the template
Click to download the template: