Ribbons for Disclosure Management

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Working with MS Office Files

Ribbons for Disclosure Management

Creating and Editing Excel Files

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

When working with MS Office documents, you can use functions in specific ribbons for MS Excel and MS Word. The functions provided in the ribbons are perfectly adapted for use in conjunction with Lucanet Disclosure Management:

The

Excel ribbon

helps you program an MS Excel file for Disclosure Management.

The

Word ribbon

helps you create result documents in MS Word.

Have you not installed the ribbons yet? Then go to the Toolbox of Disclosure Management and first install the Excel ribbon, the Word ribbon, and the Dispatcher. The Dispatcher is responsible for communication between Disclosure Management and the MS Office files, so installing it is a prerequisite.

For Disclosure Management, there are functions that are available in all ribbons and special functions for the MS Office product being used. The following figures highlight the general functions in the ribbons for MS Excel and MS Word:

Displays the Excel ribbon for Disclosure Management. The 'Server' and 'Files' areas and the 'Insert Document Variable' button are highlighted. — Excel ribbon containing the general functions for Disclosure Management

Displays the Word ribbon for Disclosure Management. The 'Server' and 'Files' areas and the 'Insert Document Variable' button are highlighted. — Word ribbon containing the general functions for Disclosure Management

The following functions are available in the Excel ribbon and Word ribbon:

Option	Description
Check In	The current file will be saved in the database. Comments can be stored during the check-in process. Comments will be displayed in the document's history.
Update	By clicking Update, changes made in Excel or Word files can be viewed as a preview at any time without having to check in the file. The file view will be refreshed according to the current, changed settings. Examples: You have created names and name extensions, but the corresponding cells of an Excel file have not yet been filled with content. By clicking Update in the Excel ribbon, the document's reference year will appear in the sn_year named range, for example. Values in Excel files are to be updated if a new data import has been performed in the meantime.

Option

Description

Check In

The current file will be saved in the database.

Comments

can be stored during the check-in process. Comments will be displayed in the document's history.

Update

By clicking

Update

, changes made in Excel or Word files can be viewed as a preview at any time without having to check in the file. The file view will be refreshed according to the current, changed settings.

Examples:

You have created names and name extensions, but the corresponding cells of an Excel file have not yet been filled with content. By clicking

Update

in the Excel ribbon, the document's reference year will appear in the

sn_year

named range, for example. Values in Excel files are to be updated if a new data import has been performed in the meantime.

Option	Description
Event Reports	Disclosure Management has an internal error logging system that flags invalid references, etc. Show Log opens the results of the log.
Save File Locally	Saves the file in the local file directory.
Open Local File	Opens a file from the local file directory.
Recover Version	Opens or recovers a previous version of the document that is currently open.

Insertion of a document variable; document variables are text building blocks that can be created in the document variable management tool and then easily inserted in every Excel and Word file of the current document.

More information on document variables can be found in Using Document Variables.

The following specific functions are available in the Excel ribbon:

Option	Description
Name Manager	Opens MS Excel's standard Name Manager.
Delete Names	Deletes a selected name from the Excel file.
Delete All Names	Deletes all names from the Excel file.

Option	Description
Insert	Adds a new outarea.
Move	Shifts an outarea.
Insert Document Variable	Insertion of a document variable; document variables are text building blocks that can be created in the document variable management tool and then easily inserted in every Excel and Word file of the current document.

Option	Description
Name	Button for creating a name column
Value	Button for creating a value column
Prog	Button for creating a programming column
Other	Button for creating other columns, e. g. footnote columns

Edit Properties opens a dialog where the general properties of the Excel file can be configured.

Add Layout Area defines an area where a specific layout from the Layout Robot is to be applied (see Configuring Document). By doing so, you ensure that a table layout defined using the Layout Robot is implemented in the Word document.

The following specific functions are available in the Word ribbon:

Compare with Local Document opens the local directory structure where a file can be selected for comparison.

Option	Description
Insert Table	Opens a dialog where a table can be selected from an Excel file to carry it over to the Word document.

More information on inserting tables can be found in Inserting Tables in a Word Document.

Option	Description
Insert XBRL Text Block Tag	Opens a window in MS Word where you can assign an XBRL text block tag to a selected area in the Word document.
Insert XBRL Footnote Tag	Opens a window in MS Word where you can assign an XBRL footnote tag to a selected area in the Word document.
Highlight XBRL Text Blocks	Highlights all XBRL text blocks in the current Word file and displays a comment field for all highlighted text blocks.

More information on inserting XBRL tags can be found in Inserting XBRL Tags.

Option	Description
Text adjustment	Opens a window in MS Word that allows you to optimize a selected text in the Word document with AI support.
Text draft	Opens a window in MS Word that enables you to create a taxonomy-compliant text with AI support.