Bug 58200 - Support evaluating SXSSF formula cells that aren't flushed, and don't refer to flushed cells
Summary: Support evaluating SXSSF formula cells that aren't flushed, and don't refer t...
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: 3.13-dev
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2015-07-31 19:18 UTC by Nick Burch
Modified: 2015-09-10 07:55 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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