Nope. Any volunteers? First step: move from cocoon to POI -- cocoon voted +1 -- 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: Danny Mui <[EMAIL PROTECTED]> > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > Date: Wed, 17 Dec 2003 15:14:07 -0500 > To: POI Users List <[EMAIL PROTECTED]> > 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(FormulaParser.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(FormulaParser.java >>> >>>> :596) >>>> at >>> >>> org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:701) >>> >>>> at >>> >>> org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:7 >>> >>>> 15) >>>> at >>> >>> com.pg.psf.util.ExcelWriter.writeToExcel(E:/JRUN4/servers/PSF/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]
