In-Table Master-Detail in Spreadsheet Document

In-Table Master-Detail in Microsoft Excel Document

Creating a In-Table Master-Detail

Practising the following steps you can create In-Table Master-Detail Template in MS Excel 2013.

  1. Add a new Workbook.
  2. Select the range of cells that you want to include in the table.
  3. On the Insert tab, in the Tables group, click Table.
  4. Insert a 2x4 table.
  5. Save the template.

Reporting Requirement

As a report developer, you are required to represent the following key requirements:

  • Report must show each manager along with his total contract prices.
  • It must also show each individual client within the contract.
  • It must show sum of the contract prices.
  • It must represent all the information in tabular form.
  • Report must be generated in the Spreadsheet document format.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

Manager/ClientContract Price
<<foreach [in getManagers()]>><<[getName()]>><<[getContracts().sum(c => c.getPrice())]>>
<<foreach [in getContracts()]>><<[getClient().getName()]>><<[getPrice()]>><</foreach>><</foreach>>
Total:<<[getManagers().sum( m => m.getContracts().sum( c => c.getPrice()))]>>

Download In-Table Master-Detail Template

Please download the sample In-Table Master-Detail document we created in this article:

Generating The Report

ODS Template and Report in Apache OpenOffice

In order to check compatibility of ODS between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests:

  • We opened the ODS template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses.
  • We opened the ODS report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.