https://bz.apache.org/bugzilla/show_bug.cgi?id=60355
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID |--- --- Comment #2 from [email protected] --- Thank you for looking into this bug! We had extended FreeRefFunction and implemented our own UDF with evaluate() before we encountered this bug. The issue we found is the same SS formula parser failure is blocking our UDF from being called. Here's the call stack we observed -- org.apache.poi.ss.formula.FormulaParseException: Unused input [("HSACTIVE","Year#Jan","Measures#Sales","Product#Cola","Market#New York","Scenario#Actual")] after attempting to parse the formula [[1]!HsGetValue("HSACTIVE","Year#Jan","Measures#Sales","Product#Cola","Market#New York","Scenario#Actual")] at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1653) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:159) at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:53) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:261) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:189) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCell(BaseXSSFFormulaEvaluator.java:117) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:346) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:337) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAll(XSSFFormulaEvaluator.java:105) -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
