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