# Common Master-Detail Image in Spreadsheet Document {{< alert style="info" >}}In this article, we will use GroupDocs.Assembly to generate a Common Master-Detail Image report in Spreadsheet Document format.{{< /alert >}}{{< alert style="info" >}}The code uses some of the objects defined in [The Business Layer](https://docs.groupdocs.com/assembly/java/the-business-layer/).{{< /alert >}} ## Common Master-Detail Image in Microsoft Excel Document ### Creating a Common Master-Detail Image 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. ### Reporting Requirement 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. ### Adding Syntax to be evaluated by GroupDocs.Assembly Engine ```java <> >" style="outline: 0px !important;"> <<[getName()]>> Clients: <><<[indexOf() != 0 ? ", " : ""]>><<[getClient().getName()]>><> <> ``` ### Download Common Master-DetailTemplate Please download the sample Common Master-Detail document we created in this article: * [Common Master-Detail.xlsx](https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-Java/blob/master/Examples/GroupDocs.Assembly.Examples.Java/Data/Storage/Spreadsheet%20Templates/Common%20Master-Detail.xlsx?raw=true) ### Generating The Report {{< gist GroupDocsGists 4b830352e9eb0a5ca52a2576173f64e6 >}} ### 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.