https://issues.apache.org/bugzilla/show_bug.cgi?id=46948


Josh Micich <j...@gildedtree.com> changed:

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




--- Comment #1 from Josh Micich <j...@gildedtree.com>  2009-04-01 12:50:43 PST 
---
Fixed in svn r761023 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=761023 )

junit added

POI can now *evaluate* formulas which apply the range operator to area refs.
(e.g. "SUM((C1:D2):(D2:E3))").  So the example code should run OK now.


However, POI still cannot *parse* these formulas. For example, these calls will
fail:
cell.setCellFormula("AVERAGE(J6:OFFSET(I6,0,DAY(TODAY())-1))");
cell.setCellFormula("SUM((C1:D2):(D2:E3))");

Bug 46951 has been opened to track this as a separate bug.

-- 
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-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to