poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lion Liang <liangyue_...@163.com>
Subject Re: How can POI extend the support on excel functions?
Date Fri, 08 Jan 2010 02:48:44 GMT

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


Mime
View raw message