This section describes the add-in commands available in the Solvency II tab of the Excel ribbon (see screenshot below). The commands in the Solvency II tab are organized into four groups: Report, Windows, Table Operations and Add-in. The description of each add-in command is provided in the subsections below.
Insert New Report
Creates a new Solvency II report. For more information, see Create a New Report. This command is disabled if the report sheet has already been inserted into the workbook.
Import from XBRL
Imports an XBRL instance file into the current Excel spreadsheet. For details, see Import Data from XBRL. This command is disabled if the report has already been inserted into the workbook. To enable the command, save and close the current report (workbook), and create a new workbook.
Export to XBRL
Exports data from all currently active sheets to an XBRL instance file. For details, see Export Data to XBRL.
Validates report data against the underlying XBRL taxonomy and displays the validation results in the Validation Report dialog box. For more information, see Validate Data.
Converts multiple XBRL instance files to Excel. For more information, see Batch Convert XBRL to Excel.
Toggle Solvency II Report Pane
Toggles the Solvency II Report Pane on or off. By default, this pane is visible.
Toggle Validation Report
Shows or hides the Validation Report window. See Validate Data.
Add Sheet (z-Axis)
Adds a new sheet which allows entering data in a third dimension. This button is enabled only if the table supports a third dimension according to the XBRL taxonomy. For more information, see Enter Data into 3D Tables.
Delete Sheet (z-Axis)
Removes the previously added z-axis sheet.
Adds a new row to the currently selected table. This button is enabled only if the table supports growing vertically.
Deletes an existing row. This button is enabled only if the table supports growing vertically.
Adds a new column to the currently selected table. This button is enabled only if the table supports growing horizontally.
Removes an existing column. This button is enabled only if the table supports growing horizontally.
This command opens the XBRL Taxonomy Manager tool, which allows viewing, installing, and uninstalling XBRL taxonomies. See Manage XBRL Taxonomies.
Displays a dialog box where you can view or change the add-in settings.
Opens this help file in CHM (Microsoft Compiled HTML Help) format.
Displays the activation status of the add-in or provides options to enter or purchase a license key code.
About Solvency II Add-In
Displays version information about the add-in.
Altova on the Web
Provides links to the Altova website, including Online Support Center, XBRL Taxonomy Download Center, training and tutorials.