Spreadsheet is new widget added in AIV5.This document shows use of spreadsheet widget in AIV. With this widget, user can Analyse and Play with the data of dataset and also can import external excel files in to this widget.

1. Login to AIV5 with valid credentials.

2. Create a new dashboard.



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



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



5. Click on save and exit button and you will see data of sales.ds dataset in spreadsheet widget. Resize the widget to view it properly.



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

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

8. User can apply formatting on Data available in spreadsheet similar to the 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 insert menu, there are different insert options available. Which are Link, Image and chart.



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



11. Also you can apply link inside of existing spreadsheet, from 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 image option.

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



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



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

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



17. There is no save option available as of now, so user can just play & analyze the data of the dataset or external excel file.

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