https://bz.apache.org/bugzilla/show_bug.cgi?id=60355
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #6 from [email protected] --- Thank you for your feedback! I've uploaded a standalone test case zip file to illustrate the parsing error. We would like to replace evaluation of HsGetValue() with Java FreeRefFunction implementation of HsGetValue. For debugging purposes, I've hard coded functional values for now. We would like to remove run-time dependency on C:\Oracle\SmartView\bin\HsTbar.xla since we are doing the HsGetvalue() evaluation ourselves in Java. I have setIgnoreMissingWorkbooks(true) to tell the Formula Evaluator to skip looking for Oracle HsTbar binaries. Here's the SS Formula parse exception stack -- cell_4_1 formula:[1]!HsGetValue("HSACTIVE","Year#Jan","Measures#Sales","Product#Cola","Market#New York","Scenario#Actual") cell_4_2 formula:[1]!HsGetValue("HSACTIVE","Year#Jan","Measures#Sales","Product#Cola","Market#Utah","Scenario#Actual") 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) at HsGetValTest.main(HsGetValTest.java:47) -- 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]
