| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Viewports
XLCubed viewports allow you to present a range from one worksheet on another.
This can be useful for presentation reasons, you can have separate worksheets for each business area, and bring them together on a formatted summary sheet.
They are similar to standard Excel camera objects (detailed here - http://blog.xlcubed.com/2012/07/a-snappy-fix-for-layout-problems-in-excel/)
The difference between viewports and cameras is in the sizing. - Camera objects zoom the captured range to fit the camera object area. - Viewports do not zoom, and instead have scrollbars when the content does not fit in the object. - Viewports support freeze panes, useful for table and grids with headers. - Viewports 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.
