..2 Form
Create and save a new form
Launch an XLSX Workbench, and create a new form with name GANTTCHART .
Assign a context to the form
Assign a context ZCONTEXT_GANTTCHART to the form. When an automatically creation of the Form structure will be prompted, you should press the button
to create a structure manually.
Markup of template
Markup an Excel-template as shown below :
Create a Form structure
Add the new components into form structure as shown in the picture below:
Template binding for components
Perform Template binding for all the «Patterns» and all the «Values» according to scheme below:
Context binding for components
Perform Context binding for «Loopsteps» and «Values» according to scheme below:
Activate the Form by pressing a button
Form is ready to use.
Explanations
The form structure is quite branched, due to the strong variability of form:
Table has a variable (dynamic) number of Columns and Rows.
Table has dynamically merged cells (with column spans / row spans ).
There are cells with dynamically defined formatting.
For convenience, the form structure is conventionally divided into two parts:
Title (folder HEADER)
Items (folder POSITIONS).
The following are the properties tab for the main components of the form structure. Note the options, marked by the red frames («Output direction», «Appearance at runtime», «Merge cells») :
Properies tab of components of the Header :
Properies tab of components of the Positions :