Hi Lorin,
Formula like $[ROUND(A1 / 1000, 3)] works for me in similar example (tested
on jxls-1.0).
Can you share your excel template so I can take a look?
Dynamic variables in formulas are not yet supported. This is a task for
next releases.
--
Leo
On Sun, Jan 8, 2012 at 3:13 PM, Lorin <lorin.kobashig...@gmail.com> wrote:
> Hello,
>
> I'm trying to figure out how to use an Excel formula to calculate a value
> on the same row within a foreach.
>
> Lets say I have a sheet where I have a value represented in milliliters in
> column A and I'd like to show that value in Liters and Gallons in columns B
> and C
>
> Column A: ${row.volumeInMl} - outputs 750
> Column B: I want it to show .750
>
> If I put in =Round(A1 / 1000,3) I will get the value of the first row in
> every row's output.
> If I put in $[ROUND(A1 / 1000, 3)] I will get it converted into
> =ROUND(A1:An / 1000, 3)
>
> Is there any way for me to output an excel formula that refers another
> cell in the current row? Or, to output an excel formula that accepts a
> dynamic value? something like
>
> =Round(${row.volumeInML}, 3)
>
> -Lkb
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> jXLS-user mailing list
> jXLS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jxls-user
>
>
------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
