| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Viewports
Revision as of 11:27, 6 May 2015 by Colin Overton (talk)
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.
