Details
-
Bug
-
Status: Testing (building)
-
Medium
-
Resolution: Unresolved
-
Xporter Cloud V 2.0
-
None
Description
When using dateformat function in an iteration inside an Excel cell, it only works if the iteration has more than one element.
If the iteration only has one element, then nothing is exported.
Steps to reproduce:
- Use the following template: Example.xlsx
In column D, nothing is exported.
Expected result:
- All the dates should be exported with the applied format.
Workaround:
- Format the dates using Javascript. For example, for the format:
${dateformat("dd/MM/yyyy"):JQLIssues[i].Links[k].Created}
We may use:
%{"${JQLIssues[i].Links[k].Created}".substr(8,2) + "/" +"${JQLIssues[i].Links[k].Created}".substr(5,2) + "/" + "${JQLIssues[i].Links[k].Created}".substr(0,4)}