Bug 58200

Summary: Support evaluating SXSSF formula cells that aren't flushed, and don't refer to flushed cells
Product: POI Reporter: Nick Burch <apache>
Component: SXSSFAssignee: POI Developers List <dev>
Severity: enhancement    
Priority: P2    
Version: 3.13-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Nick Burch 2015-07-31 19:18:02 UTC
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.
Comment 1 Nick Burch 2015-07-31 22:21:19 UTC
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)
Comment 2 Javen O'Neal 2015-09-10 07:55:06 UTC
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