..2 Form

The Form's source is here .

How to import Form into the system see here .

Open the previous Form and save it by another name

You have to open (in the XLSX Workbench) the form DYNTABLE (from previous example) and and save it by another name DYNTABLE_2 .

Markup of template 

Markup an Excel-template (add two samples of cell formatting near the existing oneas shown below :

Create a Form structure
Select a node of the component  and clone it twice, by pressing the button 
Finally, there will be three «Patterns» in the tree. Change their names (number prefix) for clarifying :

Template binding for components

Perform Template binding for the recently created «Patterns» according to scheme below:

Perform Template binding for the recently created «Values» according to scheme below:

Option «Appearance at runtime»

To control the appearance of the «Patterns» in the Printing form at runtime, You can use an option «Appearance at runtime» in the Properties tab. This option associates the occurrence / absence of «Patterns» in Printing form with the presence / absence of value in a corresponding field of Context (i.e. indicator of appearance).

Setup precondition of appearance each of the three «Patterns»: in the item «Appearance at runtime» of the Properties tab, press the button  and choose from search-help list the corresponding field: FORMAT_1, FORMAT_2 or FORMAT_3. Each of that fields will be used as indicator (flag) of component appearance.

Thus, each of the three «Patterns» will be shown in the Printing form at runtime only when corresponding field (indicator of component appearance) will not be initial (i.e. will contain value 'X') .

Properties tabs of the each «Pattern» are shown below : 


Activate the Form by pressing a button 

Form is ready to use.