SYMPTOM:
When one grid is directly above another, and the grid Properties > Layout > Grid Overflow (HTML) is set to scrollbar, the two grids will display a scrollbar to compensate for grid overflow in Strategy Web:
However, when exporting to Excel with the grid Properties > Layout > Grid Overflow (PDF & Excel) is set to Fit to grid contents, the lower grid will overlap the first and cut the grid overflow so not all of the contents of the upper grid are shown:
CAUSE:
This is a limitation of Excel exporting. Excel does not support scroll bars on grids and the positions of the grids are fixed. Since all data is shown, the overlapping occurs.
WORKAROUND:
Place the two grids in different subsections of the document and ensure that the setting is enable for "height can grow" in both subsection.
