Help & Support ↗ Lucanet Learning Space ↗
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
Mode of Excel Files
Configuring an Excel File
Names and Name Extensions in MS Excel
Creating and Editing Columns
Inserting Report Values in MS Excel
Defining Outareas
Programming References
Using Layouts in MS Excel
Inserting Tables From ESG Reports
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

Using Layouts in MS Excel

Overview

The layouts defined in a Layout Robot can be applied in an Excel table. The applied layouts will be adopted automatically when the table is inserted in a Word document.

Applying a Layout

To apply a layout defined in a Layout Robot to an Excel table:

1

Select the table cells for which you want to apply a layout.

2

Click Add Layout Range in the Excel ribbon. The menu containing the layouts available in the selected Layout Robot will be displayed:

'Add Layout Range' button in the Excel ribbon
3

Select the desired layout from the menu.

4

If necessary, repeat the process for other cells in the table.

5

Click Check In in the Excel ribbon.

  • If the outarea defined in the Excel file has already been applied in a Word document, the layout changes will only become visible when the Excel file is checked in.
  • If you checked out both documents at the same time, you can make the changed layout visible by clicking the Update button in the Word Ribbon.

A separate layout robot can be stored for each document in Lucanet Disclosure Management.

To assign a layout robot to a document, you must open the Configure document workspace and add a layout robot in the Layout Robot settings area (see also Configuring a Document).

This is also where you can use the icon to save an already assigned layout robot locally, e.g. to use it in another document.

Shows the 'Configure document' workspace. The 'Layout Robot settings' area is displayed. The options for the layout robot are outlined in red.
Assign, save, or delete layout robots

Last updated on Aug 16, 2023

Table of Contents
Using Layouts in MS ExcelOverviewApplying a Layout
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG