Sequence Number

In a report system, data is often numbered:

• In grid-format reports where data settings are displayed by list, you can directly enter =seq() or =&cell in a cell, and then set the left parent cell of the cell.

• In reports where data settings are displayed by group, the above settings (namely the in-group sequence number and inter-group sequence number) have difference effects.

seq()

(1) Overview

seq() returns the number of times the function has been executed in the entire report execution process.

(2) Example

seq() returns 1 during first execution and 2 during second execution.

(3) Other Descriptions

If multiple seq() functions appear in a template, the calculation results will be accumulated.

seq() functions containing non-cell parameters are different with each other. For example, if seq(1) and seq(2) appear in the same template, the results will not be accumulated.

seq(cell)

seq(cell) returns how many times the seq function in the specified cell group has been executed. For example, seq(A2) calculates how many times the function has been executed in the A2 cell group.

Note:

When seq() calculates row sequence numbers, the maximum sequence number that can be returned is 2047.

char(seq())

The char(seq()) function returns letters. It can also be used in two modes: row sequence number and in-group sequence number.