html-to-xlsx reference How to reference the current column in the formula

NickBok

I want to insert the formulas in the cycle. Calculate min/avg/max for each data column.

<tr >
{{#each flags}}
<td data-cell-type="formula" class="cell-project-name-content" >=MAX({How?}:{How?})</td>
{{/each}}
</tr >

jan_blaha

Handlebars provide 1 attribute with current index in the each iteration.
You can write a custom helper and use current index to calculate the current cell.

<td data-cell-type="formula">=A{{currentCell 1}}</td>

function currentCell(index) {    
    return index + 1
}

See a demo
https://playground.jsreport.net/w/anon/EDql1QWn