-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: 3.5.0
-
Component/s: 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)