Patterns
Patterns are cell ranges, defined in the excel template that are used for creating a stamp. Patterns are set in the following way:
Mark the cell range for a new pattern
Head to Formulas → Define Name and set a new name for the cell range. Note: This name is static, and needs to be referenced identically in the implementation
Stamp
From a pattern the implementation creates stamps. When a pattern is loaded it is assigned an object with all relevant keys and values, i.e. data.<key> references this object. The pattern can be overloaded but when it is stamped, it will only insert the values from the pattern as defined in the excel template in the same format (i.e., same number formatting, same font style, font type etc.)
Defined Patterns
Excel Pattern Name | Usage | Available Keys |
|---|---|---|
| Used as a header, displaying basic report information |
|
| Column headers of the table | Dependent on the sources of the |
| Rows with explicit indent value for individual positions | Dependent on the sources of the |
| Rows used for the individual positions | Dependent on the sources of the |
Template
The default template for assets list follows the design principle of the NGIS FO-Report.
0 Comments