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

Exception when export a cell with special formula

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • 3.5.0
    • None
    • Security Level: Jimmy
    • None

      SEVERE: Wildcard lookup values 'Dimmxxx?' not supported yet when eval IF(OR(C$26=" ",C$26=""),"",VLOOKUP(C50,Data!$A5:$R574,MATCH("Dimmxxx?",Data!$A$4:$R$4,0),FALSE))
      java.lang.RuntimeException: Wildcard lookup values 'Dimmxxx?' not supported yet
      at org.zkoss.poi.ss.formula.functions.Match.createLookupComparer(Match.java:238)
      at org.zkoss.poi.ss.formula.functions.Match.findIndexOfValue(Match.java:190)
      at org.zkoss.poi.ss.formula.functions.Match.eval(Match.java:100)
      at org.zkoss.poi.ss.formula.functions.Match.evaluate(Match.java:88)
      at org.zkoss.poi.ss.formula.functions.Var2or3ArgFunction.evaluate(Var2or3ArgFunction.java:36)
      at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65)
      at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
      at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:578)
      at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:314)
      at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:253)
      at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluateFormula(FormulaEngineImpl.java:441)
      at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluate(FormulaEngineImpl.java:338)
      at org.zkoss.zss.model.impl.CellImpl.evalFormula(CellImpl.java:172)
      at org.zkoss.zss.model.impl.CellImpl.getFormulaResultType(CellImpl.java:182)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.exportCell(AbstractExcelExporter.java:340)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.exportRow(AbstractExcelExporter.java:314)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.exportRowColumn(AbstractExcelExporter.java:281)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.export(AbstractExcelExporter.java:101)
      at org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:49)
      at org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:86)
      at org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:123)
      at org.zkoss.zss.app.ui.dlg.OpenManageBookCtrl$1.onEvent(OpenManageBookCtrl.java:181)
      at org.zkoss.zss.app.ui.dlg.OpenManageBookCtrl$1.onEvent(OpenManageBookCtrl.java:1)
      at org.zkoss.zul.impl.FileuploadDlg.onClose(FileuploadDlg.java:61)

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

              Created:
              Updated:
              Resolved: