Uploaded image for project: 'ZK'
  1. ZK
  2. ZK-4168

Excel Report Format Jasper Reports

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 8.6.0.1
    • Fix Version/s: None
    • Component/s: General
    • Labels:
      None
    • Environment:

      IntelliJ, Java, Jasper Reporting Engine.

      Description

      Hello,

      Our team hosts a web app that displays various types of jasper reports. We recently upgraded to ZK PE 8.6.0.1. In this version, when attempting to access one of these jasper reports in the Excel format, there is an error shown in the report component window. Our workaround to this is to revert back to ZK PE 8.5.0.1, and the Excel report loads properly without any issue. I have attached images displaying the error message and the output window call stack.

      Error Message:
      Could not initialize class net.sf.jasperreports.engine.export.JRXlsExporter

      And here is the call stack from the output window:
      java.lang.NoSuchMethodError: org.apache.poi.hssf.util.HSSFColor.getTripletHash()Ljava/util/Map;
      at net.sf.jasperreports.engine.export.JRXlsExporter.<clinit>(JRXlsExporter.java:160)
      at org.zkoss.zkex.zul.Jasperreport$JasperreporteExporterImpl.getJRExporter(Jasperreport.java:603)
      at org.zkoss.zkex.zul.Jasperreport.doReport(Jasperreport.java:512)
      at org.zkoss.zkex.zul.Jasperreport.access$200(Jasperreport.java:87)
      at org.zkoss.zkex.zul.Jasperreport$ExtraCtrl.getMedia(Jasperreport.java:444)
      at org.zkoss.zk.au.http.AuDynaMediar.service(AuDynaMediar.java:131)
      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:455)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Thread.java:748)

        Issue Links

          Activity

          Hide
          CharlesQiu CharlesQiu added a comment -

          JasperReports now depends on Apache POI 3.15, please update your POI version to solve this problem.

          Show
          CharlesQiu CharlesQiu added a comment - JasperReports now depends on Apache POI 3.15, please update your POI version to solve this problem.
          Hide
          marthatischuk marthatischuk added a comment -

          Thank you, that resolved the issue for us.

          Show
          marthatischuk marthatischuk added a comment - Thank you, that resolved the issue for us.

            People

            • Assignee:
              CharlesQiu CharlesQiu
              Reporter:
              marthatischuk marthatischuk
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h