https://issues.apache.org/bugzilla/show_bug.cgi?id=45334
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Josh Micich <[EMAIL PROTECTED]> 2008-07-03 16:27:46 PST ---
Fixed in svn r673853 and r673863
Thanks for the research. Your proposed patch fixes your case because the
formula name isn't encoded in the xls file, but it's not quite right.
This Excel function 'ERROR.TYPE' really *does* have a dot. POI code like
cell.setCellFormula("ERROR.TYPE(A1)") also needs to work.
The code was changed to allow dots in identifiers. Unfortunately, for area
refs dots can be used in place of colon, so special logic was needed to
distinguish these cases.
Also added an implementation for Errortype.java and junits.
Note - The new logic in Errortype.java is correct, but there are still a few
bugs in the way POI evaluates errors in other functions (see
TestFormulasFromSpreadsheet:134). In these cases, POI may get the error code of
the evaluated argument wrong, in which case ERROR.TYPE() will seem to return
the wrong value.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
