The worksheet toolbar has icons that allow you to interact with the worksheets in the Visual KPI Designer add-on. You’ll enter data configurations on these worksheets. When you use one of these icons, it will affect the active worksheet or all open worksheets.
Worksheet Toolbar Icons
Note: An “x” placed in the first column of a row means that row is selected. This column specifies whether an entry should be affected by various actions, such as Save, Delete, or Preview, etc. By default, all entries are selected when you open a worksheet.
Select All places an “x” in the “(x)” column for each populated row in the active worksheet.
Unselect All removes all x’s from the “(x)” column for each populated row in the active worksheet.
[av_font_icon icon=’ue8ad’ font=’visual-kpi’ style=” caption=” link=” linktarget=” size=’20px’ position=’left’ color=”][/av_font_icon]Close Worksheet closes the active worksheet. Before the worksheet is closed, you may see a warning asking if you want to close the worksheet; unsaved data will be lost. Click NO to return to the active worksheet without making any changes.
Close All Worksheets But This closes all open worksheets, except the active worksheet. Before the other worksheets are closed, a warning displays asking if you want to close all other worksheets; unsaved data will be lost. Click NO to return to the active worksheet without making any changes.
Close All Worksheets closes all open worksheets (except the default Visual KPI Designer worksheet). Before the worksheets are closed, a warning displays asking if you want to close all worksheets; unsaved data will be lost. Click NO to return to the active worksheet without making any changes.
Refresh Metadata refreshes the contents of the drop-down lists in the opened worksheets.
Toggle Basic and Advanced Modes hides or shows advanced columns. When working in Basic Mode, you see fewer columns.
Toggle Context Help hides or shows the tooltips that appear when you click on cells. You can show tooltips only for header cells or for all cells.