You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/07/31 21:18:02 UTC

[Bug 58200] New: Support evaluating SXSSF formula cells that aren't flushed, and don't refer to flushed cells

https://bz.apache.org/bugzilla/show_bug.cgi?id=58200

            Bug ID: 58200
           Summary: Support evaluating SXSSF formula cells that aren't
                    flushed, and don't refer to flushed cells
           Product: POI
           Version: 3.13-dev
          Hardware: PC
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: apache@gagravarr.org

Currently, it isn't possible to evaluate SXSSF formula cells

It would be good if, for cells that contain formulas which are within the
window, and where all referenced cells are within the window, you could
evaluate the cell. This would allow certain kinds of formulas (eg nearby
relative ones, pure-function ones) to be evaluated just after the cell is
created.

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

[Bug 58200] Support evaluating SXSSF formula cells that aren't flushed, and don't refer to flushed cells

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58200

Nick Burch <ap...@gagravarr.org> changed:

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

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
As of r1693664, it's now possible to evaluate SXSSF formula cells, provided
that the cell and all others it depends on are available in the current window
(so both created and not yet flushed)

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

[Bug 58200] Support evaluating SXSSF formula cells that aren't flushed, and don't refer to flushed cells

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58200

--- Comment #2 from Javen ONeal <ja...@gmail.com> ---
For people curious how this was implemented, see related commits below.

r1693641 implementation
r1693644 implementation and unit tests
r1693647 implementation
r1693654 implementation and unit tests
r1693656 implementation
r1693661 implementation
r1693662 implementation and unit tests
r1693663 unit tests
r1693664 changelog updated

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