I see.
This is probably a bug.
Not sure if this will help but you may try the following
1) Replace hash (#) cell reference with real cell references in your
template.
So in cell F10 put $[E12/E10] and in cell E10 put $[C10*(1+D10)]
If it does not help create one more formula cell above the inner for-each
tag for example in a cell E6 and just reference the formula cell with sum:
=E12 .
Then in your percentage column reference this cell E6 instead of E12.
If it works then you can hide the row or column with this intermediate cell.
If it does not work then I suppose you cannot do with the current jXLS
version. In this case you will have to calculate the SUM on java side and
reference it in a cell or use POI or excel macros.
--
Regards,
Leo
On Mon, Oct 21, 2013 at 2:18 PM, Jana Maureen Nissen <nis...@atesio.de>wrote:
> The SUM worked even with the if-Tags, but the percentage-column does
> not. It does not reference the cell with the sum-Value.
> See result.
> How can I reference it right?
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
> _______________________________________________
> jXLS-user mailing list
> jXLS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jxls-user
>
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
