Disclosure Management allows you to insert individual report values from the MS Excel files of the currently open document into the body text of MS Word files. So-called text values are inserted into the Word document.

Text values are references to the actual report values. If values in the Excel documents are changed, e.g. by manual rounding or by importing data, the corresponding text values are updated automatically. It is not necessary to check or adjust the text values manually.

How you insert a text value in Disclosure Management depends on the selected MS Office variant. The subsequent configuration of the text values is identical in all variants (see section Configuring Text Values).

To insert a text value in Office for the Web and Office Native:

1

Open the desired Word file from the Cockpit.

2

Place the cursor at the position in the Word document where the text value is to be inserted.

3

On the DM-Content tab of the Word ribbon, click Insert text values.

The Insert text values task pane is displayed on the right:

Shows the 'Insert text values' task pane of Disclosure Management with the area 'Value source' ('Document', 'Chapter', 'Column', 'Period'), the list 'Found values (15)' with the columns 'Name' and 'Sources', the area 'Settings' with 'Unit', 'Number Formatting String', the options 'Value', 'Percentage variation', 'Absolute variation', 'Use absolute value' and 'Use exact value', the 'Value Preview' and the 'Insert' button.
'Insert text values' task pane in Office for the Web and Office Native
4

Configure the text values to be inserted as required (see section Configuring Text Values) and then click Insert.

To insert a text value in Office for Desktop:

1

Click the three-dot icon in the Cockpit and select MS Word | Open Word file from the context menu or click the desired Word file in the MS Word column.

Shows the context menu of a chapter in the Cockpit of Disclosure Management and the submenu of 'MS Word' with 'Open Word file' and 'Delete Word file'. Highlighted in red are the three dots icon, 'MS Word' and 'Open Word file'.
Opening a Word file
2

The selected Word file is opened.

3

Place the cursor at the position in the Word document where the text value is to be inserted.

4

Click Insert text values in the Word ribbon.

Shows part of the Word ribbon for Disclosure Management in Office for Desktop. Highlighted in red is the 'Insert Text Values' button.
Inserting a text value using the Word ribbon

The Insert text values window is displayed:

Shows the 'Insert Text Value' window of Disclosure Management in MS Word with the areas 'VALUES SOURCE', 'FOUND VALUES' and 'SETTINGS', the 'Value preview' 'EUR 173 million', the 'Insert' button, and the area 'Conditions (1)' with 'Prefix', 'Postfix' and 'Other settings'.
'Insert text values' dialog
5

Configure the text values to be inserted as required (see section Configuring Text Values) and then click Insert.

The following configuration options for text values in Disclosure Management apply to all MS Office variants – Office for the Web, Office Native, and Office for Desktop. The example screenshots in this section are taken from Office for Desktop.

In Office for the Web and Office Native, some labels differ from the Office for Desktop screenshots shown below, even though the functionality is identical:

  • The Source section is called Value Source there.
  • The Insert section is called Settings there.

You have the following options for configuring text values:

Shows the areas 'VALUES SOURCE' and 'FOUND VALUES' of the 'Insert Text Value' window in Disclosure Management with the fields 'Document', 'Chapter', 'Column' and 'Period' and a list of values with the columns 'Name' and 'Value'.
'Insert text values' area in the 'Insert text values' dialog

The source of the text value is set in the upper part of the Insert text values dialog. The following options are available:

OptionDescription
DocumentWhen the wizard is opened, the Excel file of the corresponding chapter is automatically preset. If no Excel file with a value column is stored for the corresponding chapter, Disclosure Management searches for the closest Excel document in the structure and enters it.
ChapterChapter in which the desired text value is defined
ColumnValue column in which the desired text value is defined
PeriodPeriod in which the desired text value is defined
Found ValuesThe available values with their designation and the current value. The designation is derived from the corresponding name column of the Excel document.

In the Office for the Web and Office Native task pane, Found Values is a separate, collapsible section with a count indicator (e.g. "Found Values (12)"), not just a row within Source.

Shows the area 'SETTINGS' of the 'Insert Text Value' window in Disclosure Management with the drop-down lists 'Unit' and 'Number formatting string', the options 'Value', 'Percentage variation', 'Absolute variation', 'Use absolute value' and 'Use exact imported value', the 'Value preview' and the 'Insert' button.
Area for inserting values and deviations in the 'Insert text values' dialog

You have the following options for formatting text values in Disclosure Management:

OptionDescription
UnitUnit of the text value. In addition to the scaling units (1 / 1,000 / 1,000,000 / 1,000,000,000), % is available: the stored raw value is multiplied by 100, so for example 0.42 displays as 42 %.

Note: The scaling units offered in the Unit drop-down list depend on the table inserted in the Word document. It is not possible to insert the text values in a lower scaling unit than the one stored in the table.
ValueInserts the selected text value at the selected position.
Percentage variationPercentage change in the value compared to the previous period. Inserts the deviation value with a percentage sign.
Absolute variationAbsolute change in the value compared to the previous period. Inserts the deviation value with the currently set unit.
Number formatting stringDisplay of the text value, such as separators or the number of decimal places. In addition to formats with a regular hyphen, formats are available that display negative values with a long minus (en dash) – optionally with or without a thin space between the minus and the number. The preview in the drop-down list depends on the document culture (for an English document, for example, 1,234.56 | –1,234.56).
- Use absolute value: Specifies that the report value is used regardless of the sign.
- Use exact imported value: Specifies that the exact value of the report value is used for the calculation, even if a rounded number is displayed in the text value.

Note: The two options Percentage variation and Absolute variation are only displayed if a previous period exists for the selected period.

InsertInserts the text value at the current position. Under Value preview, the text value is displayed as it will be inserted with the current settings.
Shows the area 'Conditions (2)' of the 'Insert Text Value' window in Disclosure Management with the condition 'true', the areas 'Prefix' ('Overwrite prefix', 'Whitespace after prefix'), 'Postfix' ('Overwrite postfix', 'Whitespace before postfix') and 'Other settings' ('Do not show value', 'Switch displayed Sign (+/-)'), and the plus button.
The 'Prefix’ and ‘Postfix’ areas in the 'Insert text values' dialog

Text values in Disclosure Management can be provided with prefixes and postfixes (suffixes) and thus dynamically stored, for example loss or profit or a currency unit such as EUR. The following options are available for prefixes and postfixes (suffixes):

OptionDescription
ConditionChoose the desired condition from the drop-down list. The defined conditions are checked from top to bottom. The configuration for prefixes and postfixes whose condition is fulfilled first is then executed.
PrefixText that is written before a text value when it is inserted.
Overwrite prefix: Enables the input field below to enter a prefix that overwrites the existing one.
Whitespace after prefix: Inserts a protected space after the text entered in the Prefix input field.
SuffixText that is written after a text value when it is inserted.
Overwrite suffix: Enables the input field below to enter a postfix that overwrites the existing one.
Whitespace before suffix: Inserts a protected space before the text entered in the Suffix input field.
Other settingsDo not show value: The value is not displayed in the prefix and/or postfix (suffix) input fields as soon as the condition is met.
Switch displayed sign (+/-): Changes the sign of the value of the inserted text value.

Further options in the 'Conditions' area

  • Click the plus sign (+) to create another restriction.
  • The buttons in the menu bar of a condition can be used to change the order or delete the condition.
Shows the menu bar of a condition in the 'Insert Text Value' window of Disclosure Management with the buttons for moving the condition up and down and the button for deleting it.
Menu bar of a condition
  • Click Collapse icon to expand or collapse the configuration of a restriction. When collapsed, restrictions are displayed as follows:
Shows the area 'Conditions (2)' of the 'Insert Text Value' window in Disclosure Management with the two collapsed conditions '>= 0' and '<= 0' and the plus button.
Folded conditions

The Word ribbon for Disclosure Management can be used to highlight inserted document variables and text values in the Word document using the Highlight text values button.

Shows part of the 'Disclosure Management' tab of the Word ribbon in Office for Desktop. Highlighted in red is the 'Highlight Text Values' button.
Highlight text values with the Word ribbon

Inserted variables and references to report values are provided with a comment in the Word document and highlighted in color. The comment contains a description of the type of report value and its source.

In Office for the Web and Office Native, this function has a different name: on the DM-Content tab, click the Set button and select the Text Values entry. Use the Remove button and the Text Values entry to remove the highlight again.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.