报表模版Excel中若有除法运算时总是报执行错误

willis

如题，在设计一报表时有一格有除法计算，如=E3/E4，结果总是报错：报表执行错误：获取单元格值失败，表达式:45/52，数据行:1
数据是有的，45和52，其他加减乘运算都可。请问除法应该怎么写？或是否是平台运算的bug？

willis

附上后台出错信息，及模版文件，若不用/，用+-*都有结果

2013-06-18 15:39:44 开始编译Window: /UI/logistics/DataReport/process/companyReport/mainActivity.w
2013-06-18 15:39:44 结束编译Window: /UI/logistics/DataReport/process/companyReport/mainActivity.w
[ERROR] 2013-06-18 15:39:46,919 com.justep.report.controller.ReportController - 报表执行失败
获取单元格值失败，表达式:45/52，数据行:1
com.justep.report.exception.ReportServerException: 获取单元格值失败，表达式:45/52，数据行:1
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: 获取单元格值失败，表达式:45/52，数据行:1
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledSheet.compile(Unknown Source)
        at com.justep.report.CompiledTable.compile(Unknown Source)
        at com.justep.report.Table.transform(Unknown Source)
        at com.justep.report.Content.transform(Unknown Source)
        at com.justep.report.ContentSet.transform(Unknown Source)
        at com.justep.report.Report.a(Unknown Source)
        at com.justep.report.ReportDocument.transform(Unknown Source)
        at com.justep.report.ReportTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more

jishuang

报表中的除法用的是div

willis

请问应该怎么写？ 我用了 =DIV(E3,E4)，还是报错：
报表执行错误：获取单元格值失败，表达式:DIV(45,52)，数据行:1

jishuang

《X5.2.4高级开发手册.pdf》手册中有说明

willis

非常感谢，问题解决了。高级的还没看完