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 48195] Optimise evaluation of IF() and CHOOSE() - avoid eager evaluation of unused operands
Date Fri, 13 Nov 2009 21:52:15 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48195

Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Josh Micich <josh@gildedtree.com> 2009-11-13 13:52:15 UTC ---
Applied in svn r835994

junit added 

This is a major performance improvement for spreadsheets that contain formulas
with many (possibly nested) IF() functions.

In terms of cpu/time optimisation, this enhancement is probably second only to
the formula result caching solution (from bug 45376).  In that bug the actual
formulas of the example appear to be well suited to "short-circuit-if"
optimisation, but result caching provided biggest gains (for that example and
in general).  This enhancement was also previously requested in bug 45508, but
the underlying issue there was a bug in OFFSET(), not performance.

-- 
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