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
