| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Viewports"
(Created page with "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 ...") |
|||
| Line 6: | Line 6: | ||
The difference between viewports and cameras is in the sizing. | 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]]. | |
Revision as of 11:27, 6 May 2015
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.
