In-Table List with Highlighted Rows in Spreadsheet Document

In-Table List with Highlighted Rows in Microsoft Excel Document

Creating a In-Table List with Highlighted Rows

Practising the following steps you can create In-Table List with Highlighted Rows Template in MS Excel 2013.

  1. Add a new Workbook.
  2. Select the range of cells that you want to include in the table.
  3. On the Insert tab, in the Tables group, click Table.
  4. Insert a 2x4 table.
  5. Click the cell you want to highlight.
  6. Click “Cell Styles” in Styles group.
  7. Save the template.

Reporting Requirement

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

  • Report must show all the client names with price.
  • Show single client and his single contract price in a single row.
  • It must highlight the record with contract price more than or equal to 1000000.
  • It must show sum of the contract prices.
  • It must represent all the information in tabular form.
  • Report must be generated in the Spreadsheet Document.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

 

Client

Contract Price

<<foreach [in getContracts()]>><<if [getPrice() >= 1000000]>><<[getClient().getName()]>>

<<[getPrice()]>>

<<else>><<[getClient().getName()]>>

<<[getPrice()]>><</if>><</foreach>>

Total:

<<[getContracts().sum(

  c => c.getPrice())]>>

 

 

Download In-Table List with Highlighted Rows Template

Please download the sample In-Table List with Highlighted Rows 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.