---
title: "XLSX Output (Calculation) - Lasernet Form Editor 9 Training"
slug: "xlsx-output-calculation"
description: "In this exercise, you are proposed to finalize creating the output by applying the required style and adding calculations."
tags: ["Calculations", "Lasernet 9 ", "Lasernet Developer", "XLSX"]
updated: 2026-03-06T07:48:35Z
published: 2026-03-06T07:48:35Z
canonical: "kb.lasernetgroup.com/xlsx-output-calculation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# XLSX Output (Calculation)

**Applies to:** Lasernet 9

## Introduction

In the previous exercise, you have created an output of the XLSX format. Now you are proposed to finalize creating the output by applying the required style and adding calculations.

> [!NOTE]
> Note
> 
> This article describes a software version that is no longer supported. Although the software will no longer receive updates or technical support, existing documentation, such as this article, will be retained for reference purposes but will no longer be updated. If you have any questions, contact [Lasernet Support](https://support.lasernetgroup.com/new-ticket).

## Exercise

Download and import the attached configuration called **09. XLSX Output (Calculation)** **in Lasernet Developer 9**. Afterward, navigate to the **Forms** section and open the **Sample** form.

1. In the output, click on the cell as it is shown in the following image, and then type the following text in it: **GRAND TOTAL**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090442264 (1).png)

Use the two cells following the one to type the following text in each: **DISCOUNT TOTAL** and **AMOUNT PAID**, respectively.

1. Once the cells contain the required text, select them and then format them using the buttons on the toolbar. As a result, the output looks like the one in the following image:

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090443008.png)

1. Click in the cell next to the **GRAND TOTAL** one, and then type **=SUM(RANGE($D$14))** in the formula bar or directly to the cell.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090444663.png)

Let us consider what **=SUM(RANGE($D$14))** means. So, in the cell, we want to get a sum of numbers in the range into which the specified template cell is expanded in a merged document. It is a unit price range giving us a grand total sum.

Repeat the step to enter **=SUM(RANGE($E$14))** next to the **DISCOUNT TOTAL** cell as well as **=SUM(RANGE($F$14))** next to the **AMOUNT PAID** cell. So, we can have a sum for the discount total and the amount paid respectively.

1. Once you are done, select them, and then format the cells using the buttons on the toolbar. As a result, the output looks like the one in the following image:

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090442662.png)

1. To make sure that all the required elements are added to the template, preview it by clicking the **Preview** button on the toolbar.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090443373.png)

## Attachments

- [09.-XLSX-Output-Calculation.lnconfigx](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/09.-XLSX-Output-Calculation.lnconfigx)