-
Bug
-
Resolution: Unresolved
-
Normal
-
5.5.0
-
None
-
None
Steps to Reproduce
Run Issue200Test and testZSS342_2 complains
Current Result
Dec 25, 2020 12:57:57 PM io.keikai.model.impl.sys.formula.FormulaEngineImpl parse0Dec 25, 2020 12:57:57 PM io.keikai.model.impl.sys.formula.FormulaEngineImpl parse0INFO: Too few arguments to function 'ISERR'. Expected 1 but got 0. when parsing ISERR() at [blank.xlsx]Sheet1!Cell:A1[0,0]org.zkoss.poi.ss.formula.FormulaParseException: Too few arguments to function 'ISERR'. Expected 1 but got 0. at org.zkoss.poi.ss.formula.token.TokenToPtgVisitor.validateNumArgs(TokenToPtgVisitor.java:353) at org.zkoss.poi.ss.formula.token.TokenToPtgVisitor.visitFunction(TokenToPtgVisitor.java:266) at org.zkoss.poi.ss.formula.token.TokenToPtgVisitor.visitFunction(TokenToPtgVisitor.java:65) at org.zkoss.poi.ss.formula.token.FunctionNode.accept(FunctionNode.java:164) at org.zkoss.poi.ss.formula.FormulaTokenParser.parse(FormulaTokenParser.java:141) at io.keikaiex.formula.FormulaEngineEx.parse(FormulaEngineEx.java:84) at io.keikai.model.impl.sys.formula.FormulaEngineImpl.parse0(FormulaEngineImpl.java:229) at io.keikai.model.impl.sys.formula.FormulaEngineImpl.parse(FormulaEngineImpl.java:187) at io.keikai.model.impl.CellImpl.setFormulaValue(CellImpl.java:272) at io.keikai.model.impl.CellProxy.setFormulaValue(CellProxy.java:124) at io.keikai.range.impl.RangeImpl$7.visit(RangeImpl.java:576) at io.keikai.range.impl.RangeImpl.travelCells(RangeImpl.java:311) at io.keikai.range.impl.RangeImpl.access$000(RangeImpl.java:103) at io.keikai.range.impl.RangeImpl$CellVisitorTask.invoke(RangeImpl.java:174) at io.keikai.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:43) at io.keikai.range.impl.RangeImpl.setEditText(RangeImpl.java:615) at io.keikai.api.impl.RangeImpl.setCellEditText(RangeImpl.java:569) at io.keikai.issue.Issue200Test.testZSS342_2(Issue200Test.java:864)
Expected Result
No such warning
Debug Information
This might not be a bug. Input an "Incorrect Formula" and complains. The Excel complains, too.
Workaround