Rendering To Excel
Excel doesn’t allow overlapping content. When Rendering to Excel, you need to ensure that the components in the report all conform to a grid structure. The easiest way to do this is to use HBoxes and VBoxes. Alternatively, you might choose to place rulers to designate the different cells and place your components so they snap to the ruler guides.
The vertical rulers cut across all bands of the report. It is important that all components align to the same grid, regardless of the band in which they are defined, in order to achieve the best results in Excel format.
Should there be any overlapping content, the message that you will encounter will be something similar to the following :-
Warning: Could not merge cells D9-E10 as they clash with an existing set of merged cells. where ‘D90’ and ‘E10’ refers to the cells