That's good news, I did not know if you would had the flexibility with regard to creating the file to do something like that.
Just as an aside, I remembered after posting my last reply that if you are developing for OpenOffice alone, then there is the ODFToolkit project at http://odftoolkit.org/. This is an API designed to do what POI does but targeted at OpenOffice's 'native' xml based file format. Of course, these files cannot be opened using Excel so if you are developing for both platforms POI is still the best bet even if there are issues such as this formula problem to sidestep. Yours Mark B Lion Liang wrote: > > 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--tp27031517p27072438.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]
