Viewports

XLCubed Viewports help with the layout of variable length or width reports. For example they allow you to present a range from worksheet 1 on worksheet 2. This can be useful in many presentation scenarios, you can have separate worksheets for each business area, and bring them together on a formatted summary sheet.

They have a number of advantages over standard Excel camera objects (detailed here - http://blog.xlcubed.com/2012/07/a-snappy-fix-for-layout-problems-in-excel/). Firstly Viewports are scrollable. The Viewport can reference a much larger area on the source sheet, and if the Viewport control itself is smaller it will show vertical and horizontal scrollbars as required. This can be very useful for row dynamic reporting as the display area remains unchanged and additional parts of the report beneath the Viewport can remain in place even if the number of rows in the Viewport changes. They also support freeze panes so that the row and column headers can always be visible as you scroll.

Secondly they retain interactivity. If the Viewport contains a Grid, the grid is still drillable and editable even through the Viewport. If there are active cell links which update other parts of the workbook these are still interactive in the Viewport.

Lastly, they support named ranges being specified as the area (type in the name when picking a range). This works will when combined with specifying Named Ranges on Grids or Tables.