AllLangHelp_scalc.mk | 1 source/text/scalc/01/func_makearray.xhp | 48 ++++++++++++++++++++++++++++++++ 2 files changed, 49 insertions(+)
New commits: commit edb7a26c3264462191bc8f7b0dbdd857e2101b7a Author: Olivier Hallot <[email protected]> AuthorDate: Wed Jul 15 14:21:09 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Thu Jul 16 00:46:06 2026 +0200 tdf#172808 Help page for MAKEARRAY() Change-Id: I9201a39d45f2a9614538c09b10394d12fcadd36b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/208175 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 60347e17af..4a4a3cae1c 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -273,6 +273,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_rightb \ helpcontent2/source/text/scalc/01/func_let \ helpcontent2/source/text/scalc/01/func_maxifs \ + helpcontent2/source/text/scalc/01/func_makearray \ helpcontent2/source/text/scalc/01/func_map \ helpcontent2/source/text/scalc/01/func_minifs \ helpcontent2/source/text/scalc/01/func_minute \ diff --git a/source/text/scalc/01/func_makearray.xhp b/source/text/scalc/01/func_makearray.xhp new file mode 100644 index 0000000000..381dab9b9b --- /dev/null +++ b/source/text/scalc/01/func_makearray.xhp @@ -0,0 +1,48 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + +<meta> + <topic id="text/scalc/01/func_makearray.xhp" indexer="include" status="PUBLISH"> + <title id="tit">MAKEARRAY</title> + <filename>/text/scalc/01/func_makearray.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id391784054735617" branch="hid/SC_HID_FUNC_MAKEARRAY_MS" localize="false"/> +<bookmark branch="index" id="bm_id311784055127216"> +<bookmark_value>MAKEARRAY function</bookmark_value> +</bookmark> +<section id="makearray"> + <h1 id="hd_id11784054735617"><variable id="h1"><link href="text/scalc/01/func_byrow.xhp">MAKEARRAY</link></variable></h1> + <description id="par_id851784054735617">Creates an array of the specified dimensions, with each cell's value is generated by applying a formula.</description> +</section> +<embed href="text/scalc/01/common_func.xhp#array"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> +<paragraph role="code" id="par_id401784055268151">=MAKEARRAY(nRows; nCols; Formula)</paragraph> +<paragraph role="paragraph" id="par_id991784055564756"><emph>nRows</emph>: the number of rows of the resulting array.</paragraph> +<paragraph role="paragraph" id="par_id71784128303109"><emph>nCols</emph>: the number of columns of the resulting array.</paragraph> +<paragraph role="paragraph" id="par_id691784055569440"><emph>Formula</emph>: a formula expression or <link href="text/scalc/01/func_lambda.xhp">LAMBDA</link> function that will be called on each cell of the array.</paragraph> +<note id="par_id651784128420306">The formula must define 2 variables, related to the rows and columns of the array.</note> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<paragraph role="paragraph" id="par_id501784128035012">The formula <input>=MAKEARRAY(5;5;LAMBDA(r;c;IF(r=c;1;0)))</input> creates a 5x5 identity matrix (it is the same result of the function <input>=MUNIT(5)</input>).</paragraph> +<paragraph role="paragraph" id="par_id881784128796025">The formula <input>=MAKEARRAY(5;8;(LAMBDA(r;c;"@@@")))</input> creates a 5x8 array filled with the string "@@@".</paragraph> +<paragraph role="paragraph" id="par_id401784136471565">The formula <input>=MAKEARRAY(1;7;LAMBDA(r;c;c))</input> creates a one row array filled with numbers 1 to 7.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#27.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.MAKEARRAY</literal></paragraph> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id231784061670388" localize="false"><embedvar href="text/scalc/01/func_bycol.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id11784119954361" localize="false"><embedvar href="text/scalc/01/func_map.xhp#h1" markup="ignore"/></paragraph> + <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAKEARRAY";>MAKEARRAY wiki page</link>.</tip> +</section> +</body> +</helpdocument>
