Yeah, I do reporting via XML as well, and have a small class that converts xml->xls .. some day I'll write a fo->xls converter and use that rather than cocoon serializer.. but thats just a personal preference.
On Fri, 2003-12-19 at 00:36, Savino, Matt C wrote: > Understood. Just fyi - we already have a structure where we create XML for our > reports and query results, then near the last step, transform it via xslt to html, > xsl:fo->pdf and now gmr:->.xls file. So the serializer fits in quite nicely to our > existing setup. We'd rather not have to write the logic to create reports directly > through POI. > > > > > -----Original Message----- > > From: Danny Mui [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 17, 2003 12:14 PM > > To: POI Users List > > Subject: Re: HSSF: Sheet Reference Formula not working > > > > > > I don't believe any work on the serializer has been done. I > > attempted > > to use the serializer in the beginning but the feature set is so much > > smaller than what's available through POI directly. > > > > Savino, Matt C wrote: > > > > > Actually I was talking about creating worksheets through > > the gnumeric-stylesheet/serializer (which I will soon be > > implementing in a production app by the way). After I sent > > this I realized this person was generating the cells > > directly, not going through the serializer. > > > > > > Has there been any work done on the serializer in the last > > 6 months, since I first experiemented? > > > > > > thx, > > > Matt > > > > > > > > > > > >>-----Original Message----- > > >>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > > >>Sent: Tuesday, December 16, 2003 7:18 AM > > >>To: POI Users List > > >>Subject: Re: HSSF: Sheet Reference Formula not working > > >> > > >> > > >>Then you haven't checked recently. > > >>-- > > >>Andrew C. Oliver > > >>http://www.superlinksoftware.com/poi.jsp > > >>Custom enhancements and Commercial Implementation for Jakarta POI > > >> > > >>http://jakarta.apache.org/poi > > >>For Java and Excel, Got POI? > > >> > > >>The views expressed in this email are those of the author and > > >>are almost > > >>definitely not shared by the Apache Software Foundation, its > > >>board or its > > >>general membership. In fact they probably most definitively > > >>disagree with > > >>everything espoused in the above email. > > >> > > >> > > >>>From: "Savino, Matt C" <[EMAIL PROTECTED]> > > >>>Reply-To: "POI Users List" <[EMAIL PROTECTED]> > > >>>Date: Mon, 15 Dec 2003 21:26:05 -0500 > > >>>To: "POI Users List" <[EMAIL PROTECTED]>, "Anant Sagar" > > >>><[EMAIL PROTECTED]> > > >>>Subject: RE: HSSF: Sheet Reference Formula not working > > >>> > > >>>The last I checked HSSF didn't actually handle formulas, > > >> > > >>even though the > > >> > > >>>literature/code markup makes it sound like it does. Here is > > >> > > >>the thread from > > >> > > >>>the archives for this group: > > >>> > > >>>http://marc.theaimsgroup.com/?l=poi-user > > >>><http://marc.theaimsgroup.com/?l=poi-user&m=105190961026425&w=2> > > >>>&m=105190961026425&w=2 > > >>> > > >>>Please let me know if you find a way to get HSSF to do formulas. > > >>> > > >>>thx, > > >>>Matt Savino > > >>> > > >>> > > >>> > > >>>-----Original Message----- > > >>>From: Anant Sagar [mailto:[EMAIL PROTECTED] > > >>>Sent: Saturday, December 13, 2003 1:39 AM > > >>>To: POI Users List > > >>>Subject: HSSF: Sheet Reference Formula not working > > >>> > > >>> > > >>>Hi All, > > >>> > > >>>Need Help! > > >>> > > >>>When I am trying to set a sheet reference formula to a > > >> > > >>cell, I get the > > >> > > >>>'Integer Expected' error. > > >>>I m using latest POI version i.e. "poi-2.0-RC1-20031102". > > >>> > > >>> > > >>>I am trying to create a formula in Sheet 3 to sum > > >> > > >>Sheet1:Cell B12 and > > >> > > >>>Sheet2:Cell.Here is the code where it originates. > > >>>I tried by putting = sign before formula, this also does'nt > > >> > > >>work. The same > > >> > > >>>formula works if i paste on excel cell manually. > > >>> > > >>>------------------------------------------------------- > > >>>String strFormulas = "SUM('Sheet1'!B12,'Sheet2'!B12)" ; > > >>>objCell.setCellFormula(strFormulas); > > >>>------------------------------------------------------- > > >>> > > >>>Here is the stacktrace------- > > >>> > > >>>Error: Integer Expected > > >>>java.lang.RuntimeException: Cannot Parse, sorry : Integer Expected > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser. > > java:154) > > >> > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.Expected(FormulaPars > > er.java:1 > > >> > > >>>61) > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.GetNum(FormulaParser > > .java:258 > > >> > > >>>) > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser > > .java:492 > > >> > > >>>) > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:545) > > >> > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.Expression(FormulaPa > > rser.java > > >> > > >>>:596) > > >>> at > > >> > > >>org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser. > > java:701) > > >> > > >>> at > > >> > > >>org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCe > > ll.java:7 > > >> > > >>>15) > > >>> at > > >> > > >>com.pg.psf.util.ExcelWriter.writeToExcel(E:/JRUN4/servers/PS > > F/default > > >> > > >>>-ear/default-war/WEB-INF/src/com/pg/psf/util/ExcelWriter.java:318) > > >>> > > >>> > > >>>Does someone know how to solve this problem. Pls. let me know. > > >>> > > >>>-Anant Sagar > > >>> > > >>> > > >> > > >> > > >>------------------------------------------------------------ > > --------- > > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > > >>For additional commands, e-mail: [EMAIL PROTECTED] > > >> > > >> > > >> > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
