Common Master-Detail Image in Spreadsheet Document Leave feedback

Note

In this article, we will use GroupDocs.Assembly to generate a Common Master-Detail Image report in Spreadsheet Document format.

Note

The code uses some of the objects defined in The Business Layer.

Please follow below steps to create Common Master-Detail Image Template in MS Excel 2013:

1. Create a new Workbook.
2. Insert a shape to display image in it.
3. Go to Insert Tab and select shape by clicking on Shape Icon.
4. Save the document.

As a report developer, you are required to represent the information of the managers and clients with the following key requirements:

• Report must show managers’ picture and name.
• It must associate the managers with their clients.
• Report must be generated in the Spreadsheet Document.

<<foreach [in getManagers()]>>
>" style="outline: 0px !important;">
<<[getName()]>>
Clients: <<foreach [in getContracts()]>><<[indexOf() != 0 ? ", " : ""]>><<[getClient().getName()]>><</foreach>>
<</foreach>>

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

• Common Master-Detail.xlsx

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.