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 46944] Error Value can only be 0,7,15,23,29,36 or 42. It cannot be -30
Date Wed, 01 Apr 2009 20:37:42 GMT

Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
             Status|NEW                         |RESOLVED
         Resolution|                            |LATER

--- Comment #3 from Josh Micich <josh@gildedtree.com>  2009-04-01 13:37:41 PST ---
The -30 code is caused by POI attempting to evaluate a function which has not
been implemented.  Part of the problem is that the -30 error value can silently
propagate around, masquerading as a genuine Excel error code. So using
FormulaEvaluator.evaluateInCell() has probably not avoided the real problem.
Since bug 46580 , POI has been improved to throw an exception explaining which
function needs to be implemented.  

In the file you have uploaded, there are actually two functions that POI does
not support yet: ADDRESS() and INDIRECT().  The implementation of ADDRESS()
should be relatively straightforward. INDIRECT()  might be more complex because
it involves invoking a formula parser on an arbitrary string value, during
evaluation (something that hasn't been done in POI yet).

Since you are using a combination of INDIRECT(ADDRESS(...)) it might be
possible to replace this with OFFSET() (which POI *can* evaluate).

I am marking this bug as 'LATER' in the hope that OFFSET() might do what you
need. Please change the status if you can't find an acceptable work around.  As
always, we are happy to receive patches from new contributors.

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