You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/07/03 19:38:44 UTC

DO NOT REPLY [Bug 45334] Excel function "ERRORTYPE" not recognized properly

https://issues.apache.org/bugzilla/show_bug.cgi?id=45334





--- Comment #1 from Brad Sneade <bs...@gmail.com>  2008-07-03 10:38:44 PST ---
Debugging into it I have found the following:

org.apache.poi.hssf.model.FormulaParser.parseFunctionOrIdentifier() calls
GetName() and uses the existence of '(' to decide to parse and node or handle a
function.  

The ERRORTYPE function is passed around as "ERROR.TYPE(args)".  When GetName()
parses this it sets 'look' to '.' instead of '('.  It looks as if ERROR.TYPE
comes from functionMetadata.txt.  I've overridden this file (via the classpath)
and changed
"261    ERROR.TYPE      1       1       V       V       "
to
"261    ERRORTYPE       1       1       V       V       "
and this seems to fix the problem.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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