poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45334] Excel function "ERRORTYPE" not recognized properly
Date Thu, 03 Jul 2008 17:38:44 GMT

--- Comment #1 from Brad Sneade <bsneade+apache@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

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       "
"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

View raw message