poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: How to force Excel to recalculate on opening xlsx
Date Fri, 05 Nov 2010 16:03:30 GMT
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


Mime
View raw message