On Fri, 5 Nov 2010, Toshihiko Saka wrote:
> I had already tried this, but unfortunately I came across a phenomenon
> which gave me an impression that the POI formula evaluation might still
> have some incorrect behaviors.
>
> I reported this as next:
> https://issues.apache.org/bugzilla/show_bug.cgi?id=50209
We do have some unit tests which I might have expected to pick up this
issue. If you have a look at TestFormulasFromSpreadsheet and
FormulaEvalTestData.xls you can see how we do most of our formula testing,
and there's also the TestSubtotal class.
If we're missing something from those unit tests that is tripping you up,
please do submit a patch to enhance the unit tests to cover your use case!
Secondly, fixing up the formula evaluator isn't nearly as scary as you
might fear. Yegor did a great talk yesterday on how the formula evaluator
works, how to extend it, how to write functions etc. It's only a quick 20
minute talk, but it's well worth a look.
Yegor - I can't spot the talk on your people.apache.org site, and it
won't be posted on the apachecon site for another day or so. Could you
upload it somewhere and share the link?
Cheers
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
|