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

ZK-Tracker | hawk | 4 years ago
  1. 0

    [ZSS-270] error evaluating some statistical formulas - ZK-Tracker

    zkoss.org | 1 year ago
    org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF
  2. 0

    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

    ZK-Tracker | 3 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF
  3. 0

    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

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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

    ZK-Tracker | 3 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF
  6. 0

    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

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: AVERAGEIF

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

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

      AVERAGEIF

      at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate()
    2. org.zkoss.poi
      XSSFFormulaEvaluator.evaluate
      1. org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40)
      2. org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65)
      3. org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129)
      4. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539)
      5. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316)
      6. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255)
      7. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266)
      8. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119)
      8 frames
    3. org.zkoss.zss
      Spreadsheet.service
      1. org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018)
      3. org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355)
      4. org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89)
      5. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940)
      7. org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859)
      8. org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798)
      9. org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776)
      10. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520)
      11. org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87)
      12. org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4721)
      12 frames