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

--- 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
is thrown if a formula contains a UDF that isn't registered

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

View raw message