Spreadsheet

Introduction

Spreadsheet is a new widget added in AIV6. This document shows the use of the spreadsheet widget in AIV. With this widget, users can Analyze and Play with the data of the dataset and also can import external excel files into this widget.

A spreadsheet exists of cells in rows and columns and can help arrange, calculate and sort data. Spreadsheet data can be numeric values, along with text, formulas, references, and functions.

Prerequisites

• You can use any existing dataset except pipeline, pds and parameter dataset. these non supported formats will be added in later releases.

Steps to follow

Please follow below steps to get hands on with spreadsheet.

1. Log in to AIV6 with valid credentials.

2. Create a new dashboard and you can see spreadsheet in widget library.

   

3.From the widget library, select the spreadsheet widget to add to the dashboard. You will see the widget properties window.

4. Select the dataset you want to view and analyze, To demonstrate, we are using sales.ds dataset.

5. Click the save and exit button and see dataset in spreadsheet widget. Resize the widget to view it properly.

   

6. As you can see in the above figure, there are many formatting options are available in different menu bars like File, Home, Insert, Formulas, data, and view.

7. By default, formatting options of the home menu will be available when you select Dataset.

   File: The File menu is the leftmost item in the Spreadsheet. The File items enable you to perform file management functions, including New, open, and save. You also use the File menu to import from external sources into Excel.

   Save: The Spreadsheet control saves its data, style, format, and more as Excel file document.you can save Spreadsheet data as Excel document by clicking File > Save menu item in ribbon.

   Home: The Home menu is the second menu in the Spreadsheet menu bar. The Home items include options for formatting font, color, conditional formatting, filter, number type, and more. All these functions help one in performing various effective calculations.

   Insert: As the name suggests, the Insert menu helps you insert various options and items into a spreadsheet. You can insert a variety of things ranging from the pivot table to pictures, clip art, shapes, screenshots, charts and graphs, text boxes, symbols, equations, Link, and more.

   Formulas: Formulas are used for calculating the data in a worksheet. The spreadsheet comes with lots of formulas including financial, logic, text, date & time.

   Data: The Data menu also contains many important functions in Spreadsheet. You access the Protect Sheet, Protect Workbook, data validation, Highlight Invalid data, Clear Highlight & Clear Validation on the Data menu.

   Protect Sheet: Protect sheet feature helps prevent unknown users from accidentally changing, editing, moving, or deleting data in a spreadsheet. You can protect the sheet with a password.

   Protect Workbook: Protect workbook feature helps you to protect the workbook so that users cannot insert, delete, rename, or hide the sheets in the spreadsheet. You can use the password property to protect the workbook with a password.

   Views: On the View menu, you customize the way spreadsheets appear on your screen. Options include displaying grid lines between cells, Hide Headers, Freeze Panes, Freeze Rows, and Freeze Columns.

8. Users can apply formatting on Data available in a spreadsheet similar to excel. The only difference here is not all functions of Microsoft excel or spreadsheet will work here. There are some limited functionalities given here in this spreadsheet widget.

9. If we talk about the insert menu, different insert options are available. Which are Link, Images, and charts.

   

10. Using a link, the user can insert any external link on the cell value selected or the user can provide a location in existing spreadsheet on the specific cell to redirect on. So when you select a cell value and click on the link option.

    

11. Also you can apply a link inside of an existing spreadsheet, from the insert link window just go to this document option and you will see.

    

12. You can also import any image in this sheet from local storage by clicking on the image option.

13. Same way you can prepare a chart, by selecting required data from the sheet and selecting chart from chart options.

    

14. You can use various formulas supported by the widget from the formula menu.

    

15. Same way you can explore data & view menu options.

16. From the file option, you can create a new blank sheet as well as use can open the excel file resides on his computer.

    

17. When you open widget edit settings, you will see a form checkbox, this checkbox is kept here for future purposes.