https://bz.apache.org/bugzilla/show_bug.cgi?id=60858
--- Comment #3 from Daniel John <[email protected]> --- Created attachment 34823 --> https://bz.apache.org/bugzilla/attachment.cgi?id=34823&action=edit Complex sheet producing a lot of errors while evaluating Complex sheet producing a lot of errors while evaluating: Error while evaluating formula:IF(Q2="LT",SUMIFS(O2:O1,N2:N1,N2,A2:A1,A2)," ") java.lang.NullPointerException at org.apache.poi.ss.formula.functions.Baseifs.aggregateMatchingCells(Baseifs.java:138) at org.apache.poi.ss.formula.functions.Baseifs.evaluate(Baseifs.java:70) at org.apache.poi.ss.formula.functions.Sumifs.evaluate(Sumifs.java:42) at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:61) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:232) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateInCell(BaseFormulaEvaluator.java:137) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:77) -------------------------- Error while evaluating formula:IF(Q2="LT",SUMIFS(E2:E1,N2:N1,N2,A2:A1,A2)-X2," ") java.lang.NullPointerException at org.apache.poi.ss.formula.functions.Baseifs.aggregateMatchingCells(Baseifs.java:138) at org.apache.poi.ss.formula.functions.Baseifs.evaluate(Baseifs.java:70) at org.apache.poi.ss.formula.functions.Sumifs.evaluate(Sumifs.java:42) at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:61) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:232) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateInCell(BaseFormulaEvaluator.java:137) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:77) ----------------- Error while evaluating formula:IF(V2=0,IF(Q2<>"LT"," ",IF(G2<=6," ",IF(AND(G2<=9,F2>=0.02)," ",IF(F2>=0.03," ","zu kurze Pausen"))))," ") java.lang.NullPointerException at org.apache.poi.ss.formula.functions.Baseifs.aggregateMatchingCells(Baseifs.java:138) at org.apache.poi.ss.formula.functions.Baseifs.evaluate(Baseifs.java:70) at org.apache.poi.ss.formula.functions.Sumifs.evaluate(Sumifs.java:42) at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:61) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:723) at org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48) at org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74) at org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39) at org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:179) at org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62) at org.apache.poi.ss.formula.eval.RelationalOperationEval.evaluate(RelationalOperationEval.java:64) at org.apache.poi.ss.formula.functions.Fixed2ArgFunction.evaluate(Fixed2ArgFunction.java:33) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:232) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateInCell(BaseFormulaEvaluator.java:137) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:77) ---------------------------- Error while evaluating formula:IF(G2<>" ",IF(G2>10,G2-10," ")," ") java.lang.NullPointerException at org.apache.poi.ss.formula.functions.Baseifs.aggregateMatchingCells(Baseifs.java:138) at org.apache.poi.ss.formula.functions.Baseifs.evaluate(Baseifs.java:70) at org.apache.poi.ss.formula.functions.Sumifs.evaluate(Sumifs.java:42) at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:61) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:723) at org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48) at org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74) at org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39) at org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:179) at org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62) at org.apache.poi.ss.formula.eval.RelationalOperationEval.evaluate(RelationalOperationEval.java:64) at org.apache.poi.ss.formula.functions.Fixed2ArgFunction.evaluate(Fixed2ArgFunction.java:33) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:523) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:232) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateInCell(BaseFormulaEvaluator.java:137) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:77) ------------------------------ -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
