Issue in Excel Output while using SXSSF Transformer with JXLS (>=2.7.0)

Question

I've observed that the static cells are getting erased in output when I'm using SXSSF transformer to transform and apply the area as per the comments from template.

I'm using JXLS 2.11.0 and JXLS-P0I 2.11.0.

Moreover I've noted that such behavior is observed in versions newer that JXLS 2.7.0 with SXSSF Transformer

This behavior exists with fixed set of pattern i.e. in which static cell is either to left or right of iterated cell.

Sample Template

Output : JXLS 2.11.0 Output

Note that A3 cell("Manager") from Template is erased.

Any comments/lead/resolution if bug would be highly appreciated

Answer 1

This issue will be resolved in JXLS - 2.12.0 Info PR Fix