Hi

As per my requirement i need to create Excel Report. In that report some cell should have formula. I tried to set formula for particular cell like below i got org.apache.poi.ss.formula.FormulaParser.parse Exception in line no 3. Kindly help me on this

1 .String ref = (char)('E' ) + "10:" + (char)('I') + "10";
2. dataCell.setCellType(Cell.CELL_TYPE_FORMULA);
3. dataCell.setCellFormula("SUM(" + ref + ")");

Full Error Log:

javax.el.ELException: java.lang.NoSuchMethodError: org.apache.poi.ss.formula.FormulaParser.parse(Ljav a/lang/String;Lorg/apache/poi/ss/formula/FormulaParsingWorkbook;II)[Lorg/apache/poi/ss/formula/ptg/Ptg;
at com.sun.el.parser.AstValue.invoke(Unknown Source)
at com.sun.el.MethodExpressionImpl.invoke(Unknown Source)
at org.apache.myfaces.trinidadinternal.taglib.listene r.FileDownloadActionListener.processAction(FileDow nloadActionListener.java:121)
at oracle.adfinternal.view.faces.event.rich.FileDownl oadActionListener.processAction(FileDownloadAction Listener.java:77)
at javax.faces.event.ActionEvent.processListener(Acti onEvent.java:88)
at org.apache.myfaces.trinidad.component.UIXComponent Base.broadcast(UIXComponentBase.java:675)
at org.apache.myfaces.trinidad.component.UIXCommand.b roadcast(UIXCommand.java:179)
at oracle.adf.view.rich.component.fragment.UIXRegion. broadcast(UIXRegion.java:148)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent$1.run(ContextSwitchingComponent.ja va:92)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent._processPhase(ContextSwitchingComp onent.java:361)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent.broadcast(ContextSwitchingComponen t.java:96)
at oracle.adf.view.rich.component.fragment.UIXInclude .broadcast(UIXInclude.java:102)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent$1.run(ContextSwitchingComponent.ja va:92)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent._processPhase(ContextSwitchingComp onent.java:361)
at oracle.adf.view.rich.component.fragment.ContextSwi tchingComponent.broadcast(ContextSwitchingComponen t.java:96)
at oracle.adf.view.rich.component.fragment.UIXInclude .broadcast(UIXInclude.java:96)
at oracle.adfinternal.view.faces.lifecycle.LifecycleI mpl.broadcastEvents(LifecycleImpl.java:902)
at oracle.adfinternal.view.faces.lifecycle.LifecycleI mpl._executePhase(LifecycleImpl.java:313)
at oracle.adfinternal.view.faces.lifecycle.LifecycleI mpl.execute(LifecycleImpl.java:186)
at javax.faces.webapp.FacesServlet.service(FacesServl et.java:265)
at weblogic.servlet.internal.StubSecurityHelper$Servl etServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invok eServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute( ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(Tail Filter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.adf.model.servlet.ADFBindingFilter.doFilter (ADFBindingFilter.java:205)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.adfinternal.view.faces.webapp.rich.Registra tionFilter.doFilter(RegistrationFilter.java:106)
at org.apache.myfaces.trinidadinternal.webapp.Trinida dFilterImpl$FilterListChain.doFilter(TrinidadFilte rImpl.java:446)
at oracle.adfinternal.view.faces.activedata.AdsFilter .doFilter(AdsFilter.java:60)
at org.apache.myfaces.trinidadinternal.webapp.Trinida dFilterImpl$FilterListChain.doFilter(TrinidadFilte rImpl.java:446)
at org.apache.myfaces.trinidadinternal.webapp.Trinida dFilterImpl._doFilterImpl(TrinidadFilterImpl.java: 271)
at org.apache.myfaces.trinidadinternal.webapp.Trinida dFilterImpl.doFilter(TrinidadFilterImpl.java:177)
at org.apache.myfaces.trinidad.webapp.TrinidadFilter. doFilter(TrinidadFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.portlet.client.adapter.adf.ADFPortletFilter .doFilter(ADFPortletFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.webcenter.framework.events.dispatcher.Event DispatcherFilter.doFilter(EventDispatcherFilter.ja va:44)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.adf.library.webapp.LibraryFilter.doFilter(L ibraryFilter.java:175)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.wcps.client.PersonalizationFilter.doFilter( PersonalizationFilter.java:75)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.webcenter.content.integration.servlets.Cont entServletFilter.doFilter(ContentServletFilter.jav a:168)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at com.tms.cad.aror.portal.servlet.ArorRequestFilter. doFilter(ArorRequestFilter.java:59)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.webcenter.lifecycle.filter.LifecycleLockFil ter.doFilter(LifecycleLockFilter.java:151)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(Jps AbsFilter.java:111)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged (JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaa sMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMo de(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter( JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(Jps Filter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSSe rvletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFi lter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter (FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.wrapRun(WebAppServletContext. java:3715)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :3681)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.sec uredExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.exe cute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(S ervletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread. java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java :178)
Caused by: java.lang.NoSuchMethodError: org.apache.poi.ss.formula.FormulaParser.parse(Ljav a/lang/String;Lorg/apache/poi/ss/formula/FormulaParsingWorkbook;II)[Lorg/apache/poi/ss/formula/ptg/Ptg;
at org.apache.poi.xssf.usermodel.XSSFCell.setFormula( XSSFCell.java:439)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellForm ula(XSSFCell.java:419)
at com.dev.reports.ExcelReport.java.populateData(Exce lReport.java:178)
at com.dev.reports.ExcelReport.java.populateDataToWor kBook(ExcelReport.java:132)