After generating a report, shapes are not displayed in correct position

[alexandre-ava]

My Excel template contains shapes at the bottom of the document (below the ranges with the variables and formulas). There shapes stay in their initial position in the generated report which is not what is expected.

Context: Shapes are used to frame sets of important cells in the document. They make sense alsongside these cells.

Expected: When the report is generated with new lines inserted, the shapes are offset to avoid masking the generated lines of the report and stay with the data they were highlighted.

Actual When the report is generated with new lines inserted, the shapes stay at their initial position.