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: [email protected] For additional commands, e-mail: [email protected]
