org.zkoss.poi.ss.formula.eval.NotImplementedException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • http://office.microsoft.com/en-001/excel-help/subtotal-function-HP010062463.aspx there's serveal function number user can use, for example "103 COUNTA" Currently, I tried (9 MAX) and (4 SUM), it works fine. BTW, with (103 COUNTA), I got org.zkoss.poi.ss.formula.eval.NotImplementedException: SUBTOTAL - with 'exclude hidden values' option at org.zkoss.poi.ss.formula.functions.Subtotal.findFunction(Subtotal.java:77) at org.zkoss.poi.ss.formula.functions.Subtotal.evaluate(Subtotal.java:92) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) at org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:471) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1013) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) at org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3032) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2878) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1647)
    via by samchuang,
  • http://office.microsoft.com/en-001/excel-help/subtotal-function-HP010062463.aspx there's serveal function number user can use, for example "103 COUNTA" Currently, I tried (9 MAX) and (4 SUM), it works fine. BTW, with (103 COUNTA), I got org.zkoss.poi.ss.formula.eval.NotImplementedException: SUBTOTAL - with 'exclude hidden values' option at org.zkoss.poi.ss.formula.functions.Subtotal.findFunction(Subtotal.java:77) at org.zkoss.poi.ss.formula.functions.Subtotal.evaluate(Subtotal.java:92) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) at org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:471) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1013) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) at org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3032) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2878) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1647)
    via by samchuang,
  • get exception when loading zksessential /WEB-INF/excel/display/engineering.xlsx file {code} Error evaluating cell Sheet1!E8 Caused by: org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell Sheet1!E8 at org.zkoss.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:385) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:326) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) at org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:471) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1013) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) at org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3034) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2880) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1648) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1805) at org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:609) at org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:98) at org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56) at org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:854) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:490) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:135) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: org.zkoss.poi.ss.formula.eval.NotImplementedException: BESSELI at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) ... 37 more {code}
    via by dennis,
  • h3. problem description: error evaluating formulas: *AVERAGEIF, AVERAGEIFS* {code} java.lang.AssertionError: =AVERAGEIF(B12:E12,"<23000") failed, at row 11 in xsheet: formula-statistical Expected: "14000" but: was "Error evaluating cell 'formula-statistical'!B11" {code} Exception stack trace: {code} >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-statistical'!B11 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798) >> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4721) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file
    via by hawk,
  • h3. Problem Description: Unsupported formulas cause an exception and crashed. h3. Reproducing Steps: # display attached Excel within Spreadsheet *Expected:* those cells which contain unsupported formulas should display {{#NAME?}}. *Actual:* An exception is thrown and Spreadsheet is crashed. {code} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-notsupported'!B2 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: BAHTTEXT >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798) >> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4718) {code}
    via by hawk,
  • h3. problem description by automatic test the Math formula SERIESSUM cannot be evaluated to a correct result. {code} java.lang.AssertionError: =SERIESSUM(B105,0,2,B106:B109) failed, at row 104 in xsheet: formula-math Expected: "0.7071" but: was "Error evaluating cell 'formula-math'!B104" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20) at org.junit.Assert.assertThat(Assert.java:865) at org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65) at org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78) at org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63) at zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158) at zss.test.FormulaTest.testMath(FormulaTest.java:51) ... {code} Exception: {code} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'first-error'!F20 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: SERIESSUM >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:303) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:462) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:421) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:385) >> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:604) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4381) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4344) >> at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:4342) >> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:318) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0]
    via by hawk,
  • h3. problem description: error evaluating formulas: *AVERAGEIF, AVERAGEIFS* {code} java.lang.AssertionError: =AVERAGEIF(B12:E12,"<23000") failed, at row 11 in xsheet: formula-statistical Expected: "14000" but: was "Error evaluating cell 'formula-statistical'!B11" {code} Exception stack trace: {code} >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-statistical'!B11 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798) >> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4721) {code} not found formula: *BETADIST, BETAINV, CHITEST, CONFIDENCE, CORREL, COVAR, CRITBINOM, FISHER, FISHERINV, FORECAST, FREQUENCY, FTEST, GROWTH, INTERCEPT, LINEST, LOGINV, LOGNORMDIST, NEGBINOMDIST, NORMINV, NORMSDIST, NORMSINV, PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PROB, QUARTILE, RSQ, STANDARDIZE, STDEVA, STDEVPA, STEYX, TREND, TRIMMEAN, TTEST, VARA, VARPA, ZTEST* wrong evaluation result: *FDIST, FINV, GAMMADIST, HARMEAN, STDEVP,TDIST , TINV* {code} java.lang.AssertionError: =FDIST(15.2068,6,4) failed, at row 59 in xsheet: formula-statistical Expected: "0.01" but: was "0.99" java.lang.AssertionError: =FINV(0.01,6,4) failed, at row 61 in xsheet: formula-statistical Expected: "15.21" but: was "0.11" java.lang.AssertionError: =GAMMADIST(10,9,2,FALSE) failed, at row 76 in xsheet: formula-statistical Expected: "0.03" but: was "-1.00" java.lang.AssertionError: =HARMEAN(B90:H90) failed, at row 89 in xsheet: formula-statistical Expected: "5.03" but: was "0.39" java.lang.AssertionError: =STDEVP(B165:K165) failed, at row 168 in xsheet: formula-statistical Expected: "26.05" but: was "#NUM!" java.lang.AssertionError: =TDIST(1.959999,60,2) failed, at row 175 in xsheet: formula-statistical Expected: "0.05" but: was "0.03" java.lang.AssertionError: =TINV(0.054644927,60) failed, at row 177 in xsheet: formula-statistical Expected: "1.96" but: was "1.63" {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file
    via by hawk,
  • h3. problem description: error evaluating formulas: *AVERAGEIF, AVERAGEIFS* {code} java.lang.AssertionError: =AVERAGEIF(B12:E12,"<23000") failed, at row 11 in xsheet: formula-statistical Expected: "14000" but: was "Error evaluating cell 'formula-statistical'!B11" {code} Exception stack trace: {code} >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-statistical'!B11 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798) >> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4721) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file
    via by hawk,
  • h3. Problem Description: Unsupported formulas cause an exception and crashed. h3. Reproducing Steps: # display attached Excel within Spreadsheet *Expected:* those cells which contain unsupported formulas should display {{#NAME?}}. *Actual:* An exception is thrown and Spreadsheet is crashed. {code} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-notsupported'!B2 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: BAHTTEXT >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798) >> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4718) {code}
    via by hawk,
    • org.zkoss.poi.ss.formula.eval.NotImplementedException: SUBTOTAL - with 'exclude hidden values' option at org.zkoss.poi.ss.formula.functions.Subtotal.findFunction(Subtotal.java:77) at org.zkoss.poi.ss.formula.functions.Subtotal.evaluate(Subtotal.java:92) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) at org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:471) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1013) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) at org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3032) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2878) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1647)
    No Bugmate found.