Multicolored Numbered List in Spreadsheet Document

Multicolored Numbered List in Microsoft Excel Document

Creating a Multicolored Numbered List

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.

Reporting Requirement

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.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

We provide support for the following clients:

  1. «foreach [in getClients()]»«if [indexOf() % 2 == 0]»«[getName()]»

  2. «else»«[getName()]»

«/if»«/foreach»

Download Multicolored Numbered List Template

Please download the sample Multicolored Numbered 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.