Camera shape, as the name suggests, is a mirror image of a referenced area in a spreadsheet. It is a dynamic image, meaning that any change in the referenced region is reflected in the image as well.
Camera shapes can be moved, resized, rotated. They can also be grouped or ungrouped with other shapes and copy-pasted from one sheet to another.
The dashboard gadget brings this Excel dashboard to your Jira Dashboard.
Limitations
In Excel-like Tables, camera shape does not capture any pictures, shapes, or charts present in the specified cell range
It does not support text editing, text formatting, or adjustment capabilities
Note:
When a camera shape containing a picture, shape, or chart is exported to Excel, the Excel-like Tables unsupported objects (pictures, shapes, or charts) are displayed in Excel.
Usage Scenario
Consider an example where the sales data of different products across a supermarket is maintained to analyze the sales trends. The data for different product categories like Fruits, Vegetables, Bakery, Meat, etc. are maintained in different worksheets of a spreadsheet.
The summarized monthly sales data is displayed on a consolidated 'Dashboard' worksheet which shows camera shapes for the products' sales across different product categories. Any change made to the sales data is reflected in the 'Dashboard' sheet as well.
