-
Bug
-
Resolution: Fixed
-
Normal
-
3.0.0 RC
Problem Description:
Unsupported formulas cause an exception and crashed.
Reproducing Steps:
- display attached Excel within Spreadsheet
Expected:
those cells which contain unsupported formulas should display #NAME?.
Actual:
An exception is thrown and Spreadsheet is crashed.
嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-notsupported'!B2
>>org.zkoss.poi.ss.formula.eval.NotImplementedException: BAHTTEXT
>> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40)
>> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65)
>> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129)
>> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539)
>> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316)
>> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255)
>> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266)
>> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119)
>> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476)
>> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018)
>> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355)
>> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89)
>> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066)
>> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940)
>> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:859)
>> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:798)
>> at org.zkoss.zss.ui.Spreadsheet.access$40(Spreadsheet.java:776)
>> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520)
>> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87)
>> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4718)