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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to