Menu Commands
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.
Report
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.
Validate
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.
Batch Conversion
Converts multiple XBRL instance files to Excel. For more information, see Batch Convert XBRL to Excel.
Windows
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.
Table Operations
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.
Add Row
Adds a new row to the currently selected table. This button is enabled only if the table supports growing vertically.
Delete Row
Deletes an existing row. This button is enabled only if the table supports growing vertically.
Add Column
Adds a new column to the currently selected table. This button is enabled only if the table supports growing horizontally.
Delete Column
Removes an existing column. This button is enabled only if the table supports growing horizontally.
Add-In
Manage Taxonomies
This command opens the XBRL Taxonomy Manager tool, which allows viewing, installing, and uninstalling XBRL taxonomies. See Manage XBRL Taxonomies.
Settings
Displays a dialog box where you can view or change the add-in settings.
Help
Opens this help file in CHM (Microsoft Compiled HTML Help) format.
Add-In Activation
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.