 edited description
Formula processing mechanism
In issue#24 due memory consumption problem when working with SXSSF was added ability
Context context = new PoiContext(); context.getConfig().setIsFormulaProcessingRequired(false);
But this property disable calculation of formula range
In theory even if we use SXSSF we can force formula recalculation when user open filled workbook.
We can achieve it by use POI API
((PoiTransformer) transformer).getWorkbook().setForceFormulaRecalculation(true);
Will be nice to have ability of calculation of the formula range when we use SXSSF.
Comments (5)


So do you suggest to add a new method to PoiTransformer to set formula recalculation using
workbook.setForceFormulaRecalculation(true)
or are you talking about something else? 
For example we have template:
 with
each
command that has attributedirection
set toDOWN
and area fromA1:C1
Set by comment for
A1
cell jx:each(... lastCell="C1")
 and formula in
A2
cell what point toeach
command area $[SUM(A1)]
For example, after transformation of template instead of
each
areaA1:C1
we gotA1:C10
area filled by data. Formula appears inA11
cell.Is it possible to add counter for calculation of area stretching and recalculate of formula range based on counter after transformation of template? Will it work with other commands/formula?
For now is can workaround by doing additional calculation in custom command
 with

 attached example.xls
An example of the above description of the structure

 changed status to resolved
Resolved by introducing UpdateCellCommand. See SxssfDemo example
 Log in to comment