On Tue, 1 Apr 2008, poijava wrote: > ... When I click on the formula in Excel and click the green tick > to enter it it evaluates the formula correctly. ...
Excel tends to 'fix' incorrectly coded formulas if it can understand enough. In this case, Excel is probably replacing the NamePtg with NameXPtg and adding all of the SUPBOOK related stuff. On Tue, Apr 1, 2008 at 6:57 AM, Nick Burch <[EMAIL PROTECTED]> wrote: > ... > Your best bet is probably to re-calculate in poi: > http://poi.apache.org/hssf/eval.html > ... Unfortunately, that won't work yet. Another part of add-in function logic that needs to be implemented is *evaluation*' (i.e. code under HSSFFormulaEvaluator). That is scheduled to get done before the functionality to write new calls to add-in functions. Both enhancements will be needed before this will work -josh --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
