The best I can tell you is Late April, Early May is our target date. If you need it before then then crack that puppy open and lend us a hand.
As for Diagrams... I don't actually know what those are... You mean Graphs? There is very little currently done on formulas. You'd need the following: 1. A formula parser to parse it into what the book calls PTGs 2. A PTG parser to parse PTGs into Formulas (aka english) If you want to help with this, the best thing to do is contact Marc Johnson who is working on it: mjohnson at apache dot org. Certainly collaboration on the list by default is suggested but you might want to introduce yourself to him. Next: The below won't work because of pieces of preliminary formula support are enabled. If you disable recognition of "Formula" records in the org.apache.poi.hssf.record.RecordFactory then they'll not be recognized and will be rewritten exactly the way they were. Currently the development version of HSSF barfs if it doesn't understand a piece of a formula record. (we'll need to disable this again for 1.5) -Andy On Thu, 2002-02-28 at 04:49, Reto Badertscher wrote: > Hello, > > i need to read in Excel templates containing Formulas and Diagrams, change > some values in cells and write a new File: > FileInputStream fileInputStream = new FileInputStream(aInputFile); > POIFSFileSystem in = new POIFSFileSystem(fileInputStream); > HSSFWorkbook wb = new HSSFWorkbook(in); > // Do some changes in the workbook > FileOutputStream fileOutputStream = new FileOutputStream(aOutputFile); > wb.write(fileOutputStream); > fileInputStream.close(); > fileOutputStream.close(); > > I get an Nullpointer Exception when the template contains formulas or > diagrams (Sheet.serialize). From previous mails i know that writing formulas > is currently not supported. > Could please tell me someone, when it will be possible to write formulas? > Writing diagrams ? > Can i support the project in some ways - just ordered the Excel 97 > Developer's Kit? I looked into the code and saw a lot of commented out code > and not to much comments - so i guess it would be pretty hard. What's the > best way to start with - i need these two features in the near future. > > Thanks for your help > > Reto > -- http://www.superlinksoftware.com http://jakarta.apache.org - port of Excel/Word/OLE 2 Compound Document format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
