Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Excel export severely broken in current Showcase

    Hi Isomorphic,

    please see this sample (v11.1p_2017-09-23 and v11.1p_2017-09-20, current GC 61.0.3163.100).
    • Export as CSV: Seems ok on first view
    • Export as XLS: Data there, but only one column header
    • Export as XLSX: Only one cell filled in Excel
    Click image for larger version  Name:	Broken Export.png Views:	1 Size:	23.9 KB ID:	249324

    This does not happen in the same sample in v10.1p_2017-09-22.

    I'm not using this in production, but we are showing the new Tahoe-based skin on 11.1 for new customers. This now happened in a customer presentation, which was very unfortunate.

    Best regards
    Blama
    Last edited by Blama; 25 Sep 2017, 01:45.

    #2
    Hi Isomorphic,

    can you reproduce the issue?

    Best regards
    Blama

    Comment


      #3
      Yes, we see the problem and are investigating

      Comment


        #4
        SmartClient Version: v11.1p_2017-09-27/Enterprise Deployment (built 2017-09-27)

        Hello, I also see the excel export broken in my application, this is the error in tomcat logs:

        Code:
        java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.CellStyle.setVerticalAlignment(Lorg/apache/poi/ss/usermodel/VerticalAlignment;)V
            at com.isomorphic.rpc.ExcelDataExport$HeaderStyle.createHeaderStyle(ExcelDataExport.java:314)
            at com.isomorphic.rpc.ExcelDataExport$HeaderStyle.<init>(ExcelDataExport.java:280)
            at com.isomorphic.rpc.ExcelDataExport.getExportObject(ExcelDataExport.java:449)
            at com.isomorphic.rpc.DataExport.exportResultSet(DataExport.java:631)
            at com.isomorphic.rpc.DataExport.exportResultSet(DataExport.java:452)
            at com.isomorphic.rpc.RPCManager.completeResponse(RPCManager.java:1279)
            at com.isomorphic.rpc.RPCManager.send(RPCManager.java:715)
            at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:187)
            at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:152)
            at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119)
            at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
            at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:176)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:200)
            at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:178)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at com.juve.utils.Log4jSessionFilter.doFilter(Log4jSessionFilter.java:77)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
            at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
            at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:109)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:109)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at com.isomorphic.js.JSSyntaxScannerFilter._doFilter(JSSyntaxScannerFilter.java:262)
            at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:93)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:247)
            at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:93)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at com.juve.jtk.CustomCORS.doFilter(CustomCORS.java:32)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at com.juve.jtk.filter.JuventusCustomCORSFilter.doFilter(JuventusCustomCORSFilter.java:31)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
            at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
            at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
            at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
            at java.lang.Thread.run(Thread.java:745)

        Comment


          #5
          Blama, your reported issue is fixed and available in nightlies from September 28 (today). Let us know please how it worked for you.

          claudiobosticco, can you check please which version of POI you are using?

          Comment


            #6
            Hi Isomorphic,

            great, thanks a lot.
            I'll do so asap, most likely tomorrow morning.

            Best regards
            Blama

            Comment


              #7
              Hello, I'm using POI 3.14:
              Code:
              poi-3.14-20160307.jar
              poi-ooxml-3.14-20160307.jar
              poi-ooxml-schemas-3.14-20160307.jar
              as with 3.15 I was having a problem with JasperReports:
              https://forums.smartclient.com/forum...43200-poi-3-15

              Comment


                #8
                We are now shipping POI 3.17, not 3.15. Are you also having the same problem with POI 3.17 and Jasper reports?

                Comment


                  #9
                  Note that it still possible to run with older POI, if the newer version still creates issues.

                  We upgraded to get some relatively obscure fixes related to rounding, that do not appear to affect typical exports.

                  Comment


                    #10
                    Originally posted by Isomorphic View Post
                    We are now shipping POI 3.17, not 3.15. Are you also having the same problem with POI 3.17 and Jasper reports?
                    Hello, yes that problem with JasperReports is present also with POI 3.17.
                    I've discovered that they updated to the 3.15 POI in the latest release, JasperReports 6.4.1.
                    I've tested it and works with both POI 3.15 and 3.17.

                    So I may try to upgrade the JasperReports version, but it may take a while as I've got many reports and I need to test all of them.

                    Instead, with POI 3.14 and using the build:
                    SmartClient Version: v11.1p_2017-09-29/Enterprise Deployment (built 2017-09-29)
                    or
                    SmartClient Version: v11.1p_2017-09-30/Enterprise Deployment (built 2017-09-30)

                    I've still got the error from post #4.

                    Comment


                      #11
                      Hi Isomorphic,

                      my error from #1 is fixed in my application using v11.1p_2017-10-05.

                      Best regards
                      Blama

                      Comment


                        #12
                        Hi Team,

                        I am getting the same error as above. I am using SmartGWT v11.1p_2017-07-24/PowerEdition Deployment (built 2017-07-24) and apache poi-ooxml version 3.17.

                        java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.CellStyle.setVerticalAlignment(S)V
                        at com.isomorphic.rpc.ExcelDataExport$HeaderStyle.createHeaderStyle(ExcelDataExport.java:311)
                        at com.isomorphic.rpc.ExcelDataExport$HeaderStyle.<init>(ExcelDataExport.java:277)
                        at com.isomorphic.rpc.ExcelDataExport.getExportObject(ExcelDataExport.java:446)
                        at com.isomorphic.rpc.DataExport.exportResultSet(DataExport.java:631)
                        at com.isomorphic.rpc.DataExport.exportResultSet(DataExport.java:452)
                        at com.isomorphic.rpc.RPCManager.completeResponse(RPCManager.java:1279)
                        at com.isomorphic.rpc.RPCManager.send(RPCManager.java:715)

                        Please help.

                        Comment


                          #13
                          See above - this is a bug with POI, but users have discovered specific versions that do work, and they are reported above.

                          Comment

                          Working...
                          X