poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Micich <josh.mic...@gmail.com>
Subject Re: Excel formula evaluation problem
Date Thu, 05 Nov 2009 09:51:40 GMT
Hello Senan,

> ... However,
> problem can be solved by double clicking on the cell and then pressing Enter
> without changing anything, Excel evaluates the formula.

This is symptomatic of POI encoding a wrong token operand class
somewhere in the formula.

There have been a few bugs fixed recently which are related to this.
For example:
https://issues.apache.org/bugzilla/show_bug.cgi?id=44675
https://issues.apache.org/bugzilla/show_bug.cgi?id=44677
https://issues.apache.org/bugzilla/show_bug.cgi?id=45060

Try out version 3.5-FINAL as your problem may have been solved already.

Unfortunately there are some still unfixed bugs too:
https://issues.apache.org/bugzilla/show_bug.cgi?id=45752
https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

If you still are getting the same error with 3.5-FINAL, please add a
comment to bug 48043 giving details of the offending formula.

cheers,
josh

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message