jxls

JXLS2, XLSCommentBuilder and row overwrite white iterating over the passed collection

I have rather simple XLS template, and one of the rows is annotated with the comment on the cell A10:

jx:each(items="obj.reportRows" var="reportRow" lastCell="H10")

it works well - takes the collection and adds all the data from it, however it does overwrite some static cell data that is below the row A, instead of inserting the generated rows.

Looks like there's no attribute for the each command that controls whether the rows should be inserted or overwritten.

Am I missing something?

Solution

  • Try to include those static cells into jx:area tag.

    In this case they should be shifted down as expected.