[jXLS-user] Dynamic column foreach don't evaluate formulas as I expected

[Guilherme]

Hi,

I have the following dynamic column foreach:

Row 1:
Column A) <jx:forEach items="${myObj.dateList}" var="dateResultList">
Column B) ${dateResultList.value}
Column C) </jx:forEach>

This will fill for instance 10 columns (A to J) with 10 different dates.
This is working OK. Now here is my second row:

Row 2:
Column A) <jx:forEach items="${myObj.dateList}" var="dateResultList">
Column B) $[DAY(B1)]
Column C) </jx:forEach>

I expected that each column at row 2 would have a reference for the cell
above like this:
Column A) =DAY(A1)
Column B) =DAY(B1)
... and so on. This is the behaviour I get from a regular row foreach.

But what I got was:
Column A) =DAY(A1:J1)
Column B) =DAY(A1:J1)

Is there a way to solve this?

Thanks!!

-- 
Sincerely.,

Guilherme

------------------------------------------------------------------------------
Own the Future-Intel&reg; Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user