Thanks Leo. Your suggestion worked after I wrapped the line with
.
From: Leo [mailto:leon...@gmail.com]
Sent: 22 October 2013 14:05
To: jxls-user@lists.sourceforge.net
Subject: Re: [jXLS-user] Copying an Excel template file containing formulas
You should write your formula as $[YEARFRAC
You should write your formula as $[YEARFRAC(B2, TODAY(), 3)]
--
Regards,
Leo
On Tue, Oct 22, 2013 at 7:16 AM, Manish Java wrote:
> I have been using jXls for a while now. Recently we have come across some
> use cases where we need to output data to an Excel template file that
> contains formul
I have been using jXls for a while now. Recently we have come across some
use cases where we need to output data to an Excel template file that
contains formulas. For example:
Name
Birth date
Age
John Doe
01-Jan-60
53.8
Jane Doe
03-Sep-44
69.2
jXls is expected to populate
