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]
