Hi Brian. We use also this development version and wait for the release version which shall come soon (or maybe was already released in the meantime) and didn't discover problems.
We use a lot of functionality up to yet. Formulas themselves we didn't need up to yet because for flexibility reasons (no restrictions) we've solved such things in another way. MfG Karl-Heinz Zengerle ___________________________________________________ More than competence in Document Management ___________________________________________________ SAW AG Waldm�nchenerstr. 12 81549 M�nchen Tel.: ++49-89-68088368 Fax: ++49-89-68088389 www.sawag.com ___________________________________________________ -----Urspr�ngliche Nachricht----- Von: Brian Andersen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 17. Dezember 2003 15:47 An: POI Users List Betreff: Re: HSSF: Sheet Reference Formula not working (FINALLY RESOLVED) I have been watching this conversation with interest because I need to do the same thing. It looks like you are using a development version of POI to get this done. Have you had any problems with it or has it been stable? Anant Sagar wrote: >Hi All, > >I could finally resolve this formula problem. Just to give you all what had >happened and how it got resolved. > >The sheet reference formula requires that the sheet name should not contain >spaces and special characters ( _ , - ). My actual application had the sheet >name such as "LA_PRD SUB1" and hence the exception. I changed it to >"LAPRDSUB1" and everything started working. > >To figure out this simple thing, it took me 2 days. I wanted to check the >source code (2.0 ) but everytime I downloaded (6 times from 6 different site >addresses ) , I got a corrupted zip file. Did anybody else faced the same >problem? > >One more thing formula should not start with + sign. In that case you may >encounter EmptyStackException. > >I was earlier using JCOM for sheet reference formula, but now with support >for this in 2.0 , my excel generation takes less than half the time. Thanks >you all the people responsible for this. > >-Anant Sagar > >----- Original Message ----- >From: "Andrew C. Oliver" <[EMAIL PROTECTED]> >To: "POI Users List" <[EMAIL PROTECTED]> >Sent: Tuesday, December 16, 2003 8:47 PM >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]
