Multicolored Numbered List in Spreadsheet Document Leave feedback

Note

In this article, we will use GroupDocs.Assembly to generate a Multicolored Numbered List report in Spreadsheet Document format.

Practicing the following steps you can create Multicolored Numbered List Template in MS Excel 2013.

1. Add a new Workbook.
2. In one cell, write a sentence like “We provide support for the following clients:”.
3. Select the cell, and assign a color by pressing “Cell Styles” in Styles group.
4. Save the template.

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

• Report must show the clients in numbered list.
• It must highlight the products.
• Report must be generated in the Spreadsheet Document.

We provide support for the following clients:

1. <<foreach [in getClients()]>><<if [indexOf() % 2 == 0]>><<[getName()]>>
2. <<else>><<[getName()]>>

​ «/if»«/foreach»

Please download the sample Multicolored Numbered List document we created in this article:

• Multicolored Numbered List.xlsx

Note

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

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.