Menu

#84 Cell references as formula parameters are not consistently incremented

1.0
closed
None
2018-05-31
2017-07-03
Aron Gombas
No

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.

Discussion

  • Aron Gombas

    Aron Gombas - 2017-07-03

    Template file

     
  • Aron Gombas

    Aron Gombas - 2017-07-03

    Output file

     
  • Randy Gettman

    Randy Gettman - 2017-08-11

    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.

     
  • Randy Gettman

    Randy Gettman - 2018-05-31
    • status: open --> closed
     

Log in to post a comment.