report组件的grouph使用报错

tianhaoweiUp

版本3.8和版本3.9都存在此问题。在使用grouph时，如果加在一列上没有问题，加在多列上就有问题，多列使用Excel的合并居中功能。参照x5自带案例做的
案例如图：

本人做的例子Excel和xlm文件：




控制台报错信息：
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/JustepSoftware/BeX5_V3.8_ERP/model/UI2/ERP/testReport/process/testReport/multiDatasetVerticalReport.xml
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/JustepSoftware/BeX5_V3.8_ERP/model/UI2/ERP/testReport/process/testReport/multiDatasetVerticalReport.xml
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 20 more
Caused by: java.lang.RuntimeException: Excel生成报表定义失败
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        ... 32 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 8
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        ... 33 more
十月 12, 2021 10:55:59 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 8
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

jishuang

在excel的最前面多加几行空行看看

tianhaoweiUp

jishuang 发表于 2021-10-12 19:32
在excel的最前面多加几行空行看看

不行，还是报错

jishuang

这个目前没有好的处理办法，那样就在sql中分组中报表中直接显示，要么就减少分组的个数