poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58452] Copy cell formulas containing unregistered Ptgs
Date Tue, 06 Oct 2015 03:17:52 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58452

--- Comment #3 from Javen ONeal <javenoneal@gmail.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message