POI::HSSF 1.x does not support formulas as of yet. This development is in the works. The serializer currently just ignores formula cells entirely for the moment. If anyone is interested in helping with this (preferrably with parser experience) check out the poi-dev list over on Jakarta.
I think Ken's samples include formulas mostly to *test* the serializer. The serializer should avoid failure for any XML that matches the Gnumeric 1.0 dtd/schema regardless of whether the feature is *supported* or not. As various features are implemented they'll appear. To test this download the latest version of gnumeric and create a spreadsheet, drop it into a context covered by your HSSF Serializer pipeline and you should be able to get an XLS regardless. Please feel free to ask any questions here or on the poi lists. I'll submit a patch shortly for the alignment bug. (Its more a POI::HSSF bug but the serializer shouldn't try and create unaligned text anyhow even if HSSF should default it to left). We'll have an interim 1.5 release very soon. In a few months the 2.0 release will add both Graphing and Formula support. We'll of course add these features to the serializer as they are available. We're very interested in working with experienced Cocoon developers in improving upon the serializer and adding new POI features to it. Great work Ken! Thanks, Andy >> Nicola Ken Barozzi wrote: >> POI stuff committed with samples. >> >> :-) >> >> Please cross check. > > Very, very interesting stuff; I have been testing it with OpenOffice > Build 641b, and all samples technically work, although I have never seen > a sample using formulas for calculation; those fields where I would have > expected it, for example the Loss field in the web_page_sample.xls, are > empty. > > Best regards, > > Michael Hartle, > Hartle & Klug GbR --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
