The Setting dialog allows you to configure instance creation, table rendering and language parameters and define validation settings. To view or change the add-in settings, click Settings in the add-in tab of the Excel ribbon (see screenshot below).
The settings you can configure are listed below.
The settings below describe the Instance Creation section of the Settings dialog box.
Specifies if the exported XBRL instances should contain a Generated by comment. Set this option to False if your reporting authority does not allow comments in the created reports. The default value is True.
Specifies if the exported XBRL instances should be streamable and contain the xbrl-streamable-instance processing instruction. Set this option to False if your reporting authority does not allow processing instructions in reports. The default value is True.
Specifies whether invalid cell values should be treated as validation errors or warnings. The default value is Error.
The Identifier property is available in the Filing Pane. By default, this parameter is empty. The Treat missing Identifier as option specifies whether an empty Identifier property should trigger a validation error or a warning. The default value is Error.
The setting below describes the Misc section of the Settings dialog box.
Preferred Label Language
Specifies the preferred language to be used in the headers of created worksheets. Note that the respective label resources must be defined in the taxonomy for this setting to take effect. The default value is en.
The setting below describes the Table Rendering section of the Settings dialog box.
Enhanced Dimensional Validity
The default and recommended setting for the Enhanced Dimensional Validity option is True. If you encounter problems with data submission to your reporting authority, set this option to False.
The setting below describes the Validation section of the Settings dialog box.
EIOPA XBRL Filing Rules
Specifies if the additional EIOPA XBRL filing rules (defined by the EIOPA XBRL Filing Rules) should be checked. The default value is Enabled.