java.lang.IllegalStateException: Too few arguments supplied to operation. Expected (2) operands but got (0)

ZK-Tracker | hawk | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    h3. Reproducing Steps: 1. Run Spreadsheet and load an Excel 2003 file (zss.test/display2003.zul) 2. enter {{=sum(d)}} in a cell 3. edit the same cell *Actually See:* {{IllegalStateException}} is thrown. {quote} 2014/3/4 上午 09:19:34 org.zkoss.zk.ui.impl.UiEngineImpl handleError:1352 嚴重的: >>java.lang.IllegalStateException: Too few arguments supplied to operation. Expected (2) operands but got (0) >> at org.zkoss.poi.ss.formula.FormulaRenderer.getOperands(FormulaRenderer.java:125) >> at org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:101) >> at org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83) >> at org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624) >> at org.zkoss.zss.model.impl.BookHelper.getEditText(BookHelper.java:993) >> at org.zkoss.zss.model.impl.BookHelper.getRichEditText(BookHelper.java:1052) >> at org.zkoss.zss.model.impl.RangeImpl.getRichEditText(RangeImpl.java:287) >> at org.zkoss.zss.ui.impl.Utils.getRichEditText(Utils.java:924) >> at org.zkoss.zss.ui.impl.Utils.getEditText(Utils.java:891) >> at org.zkoss.zss.ui.fn.UtilFns.getEdittext(UtilFns.java:115) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3110) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2933) >> at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2557) >> at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2526) >> at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2479) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2240) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2232) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2032) >> at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) >> at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:110) >> at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:145) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2732) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2703) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2644) {quote}

    ZK-Tracker | 3 years ago | hawk
    java.lang.IllegalStateException: Too few arguments supplied to operation. Expected (2) operands but got (0)
  2. 0

    h3. Reproducing Steps: 1. Run Spreadsheet and load an Excel 2003 file (zss.test/display2003.zul) 2. enter {{=sum(d)}} in a cell 3. edit the same cell *Actually See:* {{IllegalStateException}} is thrown. {quote} 2014/3/4 上午 09:19:34 org.zkoss.zk.ui.impl.UiEngineImpl handleError:1352 嚴重的: >>java.lang.IllegalStateException: Too few arguments supplied to operation. Expected (2) operands but got (0) >> at org.zkoss.poi.ss.formula.FormulaRenderer.getOperands(FormulaRenderer.java:125) >> at org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:101) >> at org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83) >> at org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624) >> at org.zkoss.zss.model.impl.BookHelper.getEditText(BookHelper.java:993) >> at org.zkoss.zss.model.impl.BookHelper.getRichEditText(BookHelper.java:1052) >> at org.zkoss.zss.model.impl.RangeImpl.getRichEditText(RangeImpl.java:287) >> at org.zkoss.zss.ui.impl.Utils.getRichEditText(Utils.java:924) >> at org.zkoss.zss.ui.impl.Utils.getEditText(Utils.java:891) >> at org.zkoss.zss.ui.fn.UtilFns.getEdittext(UtilFns.java:115) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3110) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2933) >> at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2557) >> at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2526) >> at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2479) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2240) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2232) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2032) >> at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) >> at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:110) >> at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:145) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2732) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2703) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2644) {quote}

    ZK-Tracker | 3 years ago | hawk
    java.lang.IllegalStateException: Too few arguments supplied to operation. Expected (2) operands but got (0)

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Too few arguments supplied to operation. Expected (2) operands but got (0)

      at org.zkoss.poi.ss.formula.FormulaRenderer.getOperands()
    2. org.zkoss.poi
      HSSFCell.getCellFormula
      1. org.zkoss.poi.ss.formula.FormulaRenderer.getOperands(FormulaRenderer.java:125)
      2. org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:101)
      3. org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83)
      4. org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624)
      4 frames
    3. org.zkoss.zss
      EventDispatchListener.onEvent
      1. org.zkoss.zss.model.impl.BookHelper.getEditText(BookHelper.java:993)
      2. org.zkoss.zss.model.impl.BookHelper.getRichEditText(BookHelper.java:1052)
      3. org.zkoss.zss.model.impl.RangeImpl.getRichEditText(RangeImpl.java:287)
      4. org.zkoss.zss.ui.impl.Utils.getRichEditText(Utils.java:924)
      5. org.zkoss.zss.ui.impl.Utils.getEditText(Utils.java:891)
      6. org.zkoss.zss.ui.fn.UtilFns.getEdittext(UtilFns.java:115)
      7. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3110)
      8. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2933)
      9. org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2557)
      10. org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2526)
      11. org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2479)
      12. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2240)
      13. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2232)
      14. org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2032)
      15. org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43)
      15 frames
    4. org.zkoss.zssex
      RefBookImpl$DelegateListener.onEvent
      1. org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:110)
      1 frame
    5. ZK Kernel
      AbstractComponent.service
      1. org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:145)
      2. org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2732)
      3. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2703)
      4. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2644)
      4 frames