{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TestExecutions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TestExecutions","index":0,"n_rows":7,"n_cols":21,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,20],[6,0,6,20],[0,0,0,20]]}
[]
["Key","Summary","Fix Versions","Revision","Begin Date","End Date","Test Environment","Test Plan","Defects","Elapsed Time","#Test Runs","Passed","Passed (%)","Failed","Failed (%)","Executing","Executing (%)","To do","To do (%)","Aborted","Aborted (%)"]
["&{for issues}"]
["#{if (%{'${IssueTypeName}'.equals('Test Execution')})}"]
["${link:title=${Key},href=${BaseURL}/browse/${Key}}","${Summary}","#{if (%{'${FixVersions}'.equals('')})}\nNone\n#{end}\n#{if (%{!'${FixVersions}'.equals('')})}\n${FixVersionsList}\n#{end}","#{if (%{'${Revision}'.equals('')})}\nNone\n#{end}\n#{if (%{!'${Revision}'.equals('')})}\n${Revision}\n#{end}","${dateformat(\"dd-MM-yyyy HH:mm:ss\"):Begin Date}","${dateformat(\"dd-MM-yyyy HH:mm:ss\"):End Date}","#{if (%{'${TestEnvironments}'.equals('')})}\nNone\n#{end}\n#{if (%{!'${TestEnvironments}'.equals('')})}\n${TestEnvironments}\n#{end}","#{for testPlans}\n${TestPlans[n].Key}\n#{end}","${set(Def, ‘A’)}\n#{for testruns}\n#{for d=TestRuns[n].ExecutionDefectsCount}\n#{if (%{'${Def}'.indexOf('${TestRuns[n].ExecutionDefects[d].Key}')==-1})}\n${set(Def,%{'${Def}'.concat('${TestRuns[n].ExecutionDefects[d].Key}')})}\n${TestRuns[n].ExecutionDefects[d].Key}\n#{end}\n#{end}\n#{for m=TestRuns[n].TestStepsCount}\n#{for dc=TestRuns[n].TestSteps[m].DefectsCount}\n#{if (%{'${Def}'.indexOf('${TestRuns[n].TestSteps[m].Defects[dc].Key}')==-1})}\n${set(Def,%{'${Def}'.concat('${TestRuns[n].TestSteps[m].Defects[dc].Key}')})}\n${TestRuns[n].TestSteps[m].Defects[dc].Key} \n#{end}\n#{end}\n#{end}\n#{for it=TestRuns[n].IterationsCount}\n#{for r=TestRuns[n].Iterations[it].TestStepsCount}\n#{for dc=TestRuns[n].Iterations[it].TestSteps[r].DefectsCount}\n#{if (%{'${Def}'.indexOf('${TestRuns[n].Iterations[it].TestSteps[r].Defects[dc].Key}')==-1})}\n${set(Def,%{'${Def}'.concat('${TestRuns[n].Iterations[it].TestSteps[r].Defects[dc].Key}')})}\n${TestRuns[n].Iterations[it].TestSteps[r].Defects[dc].Key}\n#{end}\n#{end}\n#{end}\n#{end}\n#{end}","${set(dateDifTotal,0)}\n#{for testruns}\n${set(CreatedSpt,%{\"${TestRuns[n].Started On}\".split(\"[\")[0]})}\n${set(ResolvedSpt,%{\"${TestRuns[n].Finished On}\".split(\"[\")[0]})}\n${set(cr,%{new Date(\"${CreatedSpt}\").getTime()})}\n${set(res,%{new Date(\"${ResolvedSpt}\").getTime()})}\n${set(dateDif,%{${res} - ${cr}})}\n${set(dateStr,%{new Date(${dateDif}).toISOString().substr(11, 8)})}\n${set(dateDifTotal,%{${dateDifTotal} + ${dateDif}})}\n#{end}\n${set(dateStrTotal,%{new Date(${dateDifTotal}).toISOString().substr(11, 8)})}\n${dateStrTotal}\n","${TestRunsCount}","${Overall Execution Status.PASSED.Count}","${Overall Execution Status.PASSED.Percentage}","${Overall Execution Status.FAILED.Count}","${Overall Execution Status.FAILED.Percentage}","${Overall Execution Status.EXECUTING.Count}","${Overall Execution Status.EXECUTING.Percentage}","${Overall Execution Status.TO DO.Count}","${Overall Execution Status.TO DO.Percentage}","${Overall Execution Status.ABORTED.Count}","${Overall Execution Status.ABORTED.Percentage}"]
["#{end}"]
["&{end}"]