Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-412

Issue200Test (testZSS342_2) complains

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Normal Normal
    • 6.1.0
    • 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

       

            Unassigned Unassigned
            henrichen henrichen
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: