No not at all. I am creating workbook which has 15 sheets and each sheet has 150 rows and 50 columns. There are as many numbers of formulas, both cross sheet as well as intra sheet.
POI 2.0 version seems to be very stable till now.And its fast. -Anant Sagar ----- Original Message ----- From: "Brian Andersen" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Wednesday, December 17, 2003 8:17 PM Subject: 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]
