https://bz.apache.org/bugzilla/show_bug.cgi?id=58452
--- Comment #3 from Javen ONeal <[email protected]> --- Created attachment 33168 --> https://bz.apache.org/bugzilla/attachment.cgi?id=33168&action=edit main FormulaParser changes When parsing a formula, if there is an unknown name in the formula, add the name to the workbook and continue parsing. This is consistent with how Excel works: it allows formulas to contain "unrecognized text" or "invalid name errors", but the formula result is #NAME?. Formula evaluation is unchanged: a org.apache.poi.ss.formula.eval.NotImplementedFunctionException/NotImplementedException is thrown if a formula contains a UDF that isn't registered (workbook.addToolPack). In this patch: * FormulaParser.parse no longer throws FormulaParseException for formulas containing unregistered functions such as '=myFunc("arg")'. * modify TestExternalFunctions as necessary * add FormulaParser unit tests to make sure formulas with invalid syntax still throw FormulaParseException. -- 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]
