wR6k8‖

xiqnm‖MAKEARRAY

pjagA‖Creates an array of the specified dimensions, with each cell's value is generated by applying a formula.

mMG2J‖Enter the formula as an array formula. Hint: enter formula using keys Ctrl + Shift + Enter.

ebLBc‖Syntax

YzNoC‖=MAKEARRAY(nRows; nCols; Formula)

CgCWR‖nRows: the number of rows of the resulting array.

hCFGp‖nCols: the number of columns of the resulting array.

vUBep‖Formula: a formula expression or LAMBDA function that will be called on each cell of the array.

UpdsP‖The formula must define 2 variables, related to the rows and columns of the array.

GAZG2‖Examples

yumUB‖The formula =MAKEARRAY(5;5;LAMBDA(r;c;IF(r=c;1;0))) creates a 5x5 identity matrix (it is the same result of the function =MUNIT(5)).

BJvCZ‖The formula =MAKEARRAY(5;8;(LAMBDA(r;c;"@@@"))) creates a 5x8 array filled with the string "@@@".

naGaz‖The formula =MAKEARRAY(1;7;LAMBDA(r;c;c)) creates a one row array filled with numbers 1 to 7.

XAFa7‖Technical information

wB7Kb‖This function is available since LibreOfficeDev 27.2.

Gewrf‖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.MAKEARRAY

BYCOL

MAP

tCA8B‖MAKEARRAY wiki page.