Available Tags
Additional tags and tag options are available for use in addition to the jt:forEach and jt:if tags in the previous example.
 |
Tags must be closed to operate properly. For example, if <jt:forEach> tag is opened, there must be a matching </jt:forEach> tag at the end of the block.
|
The following are examples of other useful tags that are available:
• jt:hyperlink turns a cell to hyperlink
• jt:comment adds comments to cells
• jt:style adds styling to cells
• jt:formula creates a formula inside a cell
For the complete list of available tags, see the JETT tag documentation.
jt:formula tag
The jt:formula tag is used to create cells with Excel formulas inside. The engine evaluates the expression and places the Excel formula in the cell.
The following are usage examples for the jt:formula tag:
|
Example
|
Description
|
||
|---|---|---|---|
|
<jt:formula text= "VALUE(${items.getCustomField(1)})"/>
|
Converts a string to an integer in the cell.
|
||
|
<jt:formula text= "${items.getCustomField(0)}/86400000"/>
|
Converts long values to dates. You will also need to set the cell format in the template to the desired time format.
|
