RANDARRAY

Generates an array of random numbers between two limit values.

This function returns a dynamic array.

Sintaxe

RANDARRAY([Rows [; Columns [; Min [; Max [; Integers] ] ] ])

Rows: (optional) the number of rows to return. If omitted, the value is 1.

Columns: (optional) the number of columns to return. If omitted, the value is 1.

Min: (optional) The lower limit of the generated numbers. If omitted, the minimum value is 0.

Max: (optional) The upper limit of the generated numbers. If omitted, the maximum value is 1.

Integers: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE.

Pódese omitir calquera dos argumentos opcionais. Un argumento opcional require que todos os separadores presentes estean presentes.

Exemplo

{=RANDARRAY(10;4;10;50;1)} returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers).

Información técnica

Esta función está dispoñíbel desde a versión 24.8 do 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.RANDARRAY

ALEATORIOENTRE, ALEATORIOENTRE.NV, ALEATORIO, ALEATORIO.NV

RANDARRAY wiki page.