Command Reference
The add-in commands available in the Solvency II tab of the Excel ribbon are listed below.
Insert New Report
Creates a new Solvency II filing report, see Creating 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 (see Importing Data from XBRL). This command is disabled if a 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 (see Exporting Data to XBRL).
Validate
Performs a validation of report data against the underlying XBRL taxonomy and displays the validation results in a dialog box (see Validating Data).
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 Validating Data.
Add Sheet (z-Axis)
Adds a new sheet which provides the ability to enter data in a third dimension. This button is enabled only if the table supports a third dimension according to XBRL taxonomy. For more information, see Entering Data into Three-Dimensional Tables (Z-Axis).
Remove Sheet (z-Axis)
Removes a 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.
Manage Taxonomies
This command opens the XBRL Taxonomy Manager tool, from where you can view, install, and uninstall XBRL taxonomies. See Managing 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, components download page, training and tutorials).