Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <27070653.post@talk.nabble.com>
Date: Thu, 7 Jan 2010 18:48:44 -0800 (PST)
From: Lion Liang <liangyue_829@163.com>
To: user@poi.apache.org
Subject: Re: How can POI extend the support on excel functions?
In-Reply-To: <27056823.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <27031517.post@talk.nabble.com> <27056823.post@talk.nabble.com>


Thanks Mark.

I found a workaround to use a some complex formula instead of DATEDIF:

=YEAR(B1)*12+MONTH(B1)-(YEAR(A1)*12+MONTH(A1))

This temporarily solve the function which is not supported by OpenOffice.


MSB wrote:
> 
> If you are using OpenOffice to convert the files and it is experiencing
> problems recognising some of Excel's function names then I would be loath
> to proceed further. I do not know that this is the case but I would
> suspect that OpenOffice will rpeserve the function names following the
> conversion process, rendering the file unreadable - well unparsable - to
> Excel.
> 
> Yours
> 
> Mark B
> 

-- 
View this message in context: http://old.nabble.com/How-can-POI-extend-the-support-on-excel-functions--tp27031517p27070653.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org