Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

"Camera shape, as the name suggests, " is a mirror image of a referenced specific area in of 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.

...

This document refers to Grapecity SpreadJS documents

As it works dynamically, the shape follows content changes of the mirroring area.

The details are here.

The app uses Grapecity’s SpreadJS library.