SECUENCIA

Genera una lista de números secuenciales en una matriz.

Esta función devuelve una matriz dinámica.

Sintaxis

=SEQUENCE(Rows; [Columns [; Start [; Step ]]])

Rows: a positive integer. The number of rows to return.

Columns: optional, a positive integer. The number of columns to return. If omitted, default is 1.

Start: optional. The initial value of the sequence. If omitted, default is 1.

Step: optional. The increment of each subsequent value in the array. If omitted, default is 1.

The array is filled from the first row to the right up to the value of Columns, and then down to the number of rows.

Ejemplo

=SEQUENCE(3; 5; 10; 11) returns the 3-by-5 array below with an upper-left value of 10 and filling the array to the right and then downward in steps of 11.

10	21	32	43	54
65	76	87	98	109
120	131	142	153	164

Información técnica

Esta función está disponible a partir de la versión 24.8 de LibreOfficeDev.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.SEQUENCE

SEQUENCE wiki page.