poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45376] Performance difference between HSSFFormulaEvaluator#evaluateInCell and evaluateFormulaCell
Date Fri, 11 Jul 2008 07:12:11 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45376


Matthias <Matthias.Igel@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW




--- Comment #2 from Matthias <Matthias.Igel@gmx.net>  2008-07-11 00:12:10 PST ---
The formula is indeed a recursive one, but the time needed to evaluate it,
especially for column 9 to 15, is not acceptable, I think (compared to the time
excel needs to evaluate it, which is almost null).

When you have a look at the sheet, you can see that the formula is also set for
columns with index greater than 15. The time to evaluate these formulas would
of course grow exponentially. 

What the formula does, can be expressed in the following way:

- get the date (year and month) of your left neighbour cell and add "1" to the
month.
- look, if that date is smaller or equal to the date in column (3,4).
- if so, put it the new date into the actual cell
- else, write down #nv

It is clear, that the recursive formula evaluation is executed twice for each
cell, but compared to the low complexicity of the formula, that should not
result in such a long running evaluation.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


Mime
View raw message