Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel Report
-
Hello, I'm having trouble making a report with Excel, it follows error:
Report Setup:
Thank you very much if anyone can help me.
-
Hi leoboeng,
The error implies that you have created a formula in your excel report based on a named range that is not defined. So, if you have a named range like 'range' but your forumla is '=SUM(arange)' that mismatch will produce the shown error (provided there is no named range 'arange' in the worksheet).
Posting a screenshot of error text is not as useful as posting the content of the error. Images are not searchable.
Here's the text of the error from my reproduction:
ERROR 2018-05-04T13:29:19,095 (com.infiniteautomation.mango.excelreports.rt.ExcelReportWorkItem.execute:673) - Specified named range 'BARange' does not exist in the current workbook. org.apache.poi.ss.formula.FormulaParseException: Specified named range 'BARange' does not exist in the current workbook. at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:910) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:501) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1540) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1498) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1485) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1858) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1986) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1970) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1927) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1471) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1343) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:896) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:586) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:322) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1540) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1498) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1485) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1858) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1986) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1970) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1927) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1900) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1880) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2028) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:85) ~[poi-ooxml-3.17.jar:3.17] at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:276) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:220) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:64) ~[poi-ooxml-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(BaseFormulaEvaluator.java:192) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:267) ~[poi-3.17.jar:3.17] at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateAllFormulaCells(BaseFormulaEvaluator.java:258) ~[poi-3.17.jar:3.17] at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAllFormulaCells(XSSFFormulaEvaluator.java:72) ~[poi-ooxml-3.17.jar:3.17] at com.infiniteautomation.mango.excelreports.rt.ExcelReportWorkItem.execute(ExcelReportWorkItem.java:649) [excel-reports-3.4.1-SNAPSHOT.jar:?] at com.serotonin.m2m2.rt.maint.BackgroundProcessingImpl$WorkItemRunnable.run(BackgroundProcessingImpl.java:676) [classes/:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [?:?] at java.lang.Thread.run(Thread.java:844) [?:?]
