Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-562

IllegalArgumentException showed when referencing a Spring bean that contains List type properties

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.5.0
    • 3.0.0
    • ZSS Formula
    • Security Level: Jimmy
    • None

      When a spring bean contains a property which type is List. And enter formula "=bean.list" on cell C3 will show IllegalArgumentException in console.
      Stack trace

      java.lang.IllegalArgumentException: Did not expect to update to null
      	at org.zkoss.poi.ss.formula.CellCacheEntry.updateValue(CellCacheEntry.java:47)
      	at org.zkoss.poi.ss.formula.FormulaCellCacheEntry.updateFormulaResult(FormulaCellCacheEntry.java:108)
      	at org.zkoss.poi.ss.formula.CellEvaluationFrame.updateFormulaResult(CellEvaluationFrame.java:75)
      	at org.zkoss.poi.ss.formula.EvaluationTracker.updateCacheResult(EvaluationTracker.java:94)
      	at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:325)
      	at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257)
      	at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267)
      	at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120)
      	at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510)
      	at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:326)
      	at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:496)
      	at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:443)
      	at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:397)
      	at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:599)
      	at org.zkoss.zss.ui.impl.undo.CellEditTextAction.applyAction(CellEditTextAction.java:51)
      	at org.zkoss.zss.ui.impl.undo.AbstractEditTextAction.doAction(AbstractEditTextAction.java:82)
      	at org.zkoss.zssex.ui.impl.UndoableActionManagerImpl.doAction(UndoableActionManagerImpl.java:50)
      	at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4553)
      	at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4506)
      	at org.zkoss.zss.ui.Spreadsheet.access$300(Spreadsheet.java:197)
      	at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:353)
      	at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743)
      

        1. AssetsBean.java
          2 kB
          vincentjian
        2. bean.xlsx
          10 kB
          vincentjian
        3. RefSpringBeanComposer.java
          2 kB
          vincentjian
        4. springBean.zul
          1 kB
          vincentjian

            Jenkins Jenkins
            vincentjian vincentjian
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: