When a formula embedded in a forEach iteration is using multiple cell references, only the first one(?) is incremented from one row to the next.
I attached a sample template with this formula in the B1 cell:
=IF(A1<>"foo",0,C1)
I also attached the output file that shows the problem. In the rendered output I'd expect that the cell B3 becomes:
=IF(A3<>"foo",0,C3)
but it is:
=IF(A3<>"foo",0,C1)
As you see the "C1" reference is unchanged through the loops of the iteration.
Please note that:
it was working in Jett 0.9.0, but it occurs in Jett 0.10.0.
It may even be the same problem as the other one reported by another user here: https://sourceforge.net/p/jett/tickets/82/
If it is, then it affects many users. If it isn't, it may be rooted in a similar cause.
Template file
Output file
Aron,
The fix applied to Ticket #82 is the same that would be applied to this ticket. I'll mark this ticket as a duplicate of #82.