https://issues.apache.org/bugzilla/show_bug.cgi?id=46944
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |LATER --- Comment #3 from Josh Micich <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
