Common List Image in Spreadsheet Document

Common List in Microsoft Excel Document

Creating a Common List

Please follow below steps to create Common List Image in MS Excel 2013:

  1. Insert the desired shape to display image in it.
  2. Go to Insert Tab and select shape by clicking on Shape Icon.
  3. Save your Document.

Reporting Requirement

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

  • Report must show multiple managers’ picture and name.
  • Report must be generated in the Spreadsheet Document.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

«foreach [in getManagers()]»

<<image [getPhoto()]>>
<<[getName()]>> <>

Download Template

Please download the sample Common List 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.