AllLangHelp_scalc.mk | 2 + source/text/scalc/01/common_func.xhp | 2 - source/text/scalc/01/func_bycol.xhp | 58 ++++++++++++++++++++++++++++++++++ source/text/scalc/01/func_byrow.xhp | 59 +++++++++++++++++++++++++++++++++++ 4 files changed, 120 insertions(+), 1 deletion(-)
New commits: commit 5538d811e467b5512b46ea3da0feab11243a7068 Author: Olivier Hallot <[email protected]> AuthorDate: Tue Jul 14 20:18:47 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Jul 15 01:41:31 2026 +0200 tdf#172807 tdf#172806 Help for BYCOL and BYROW Change-Id: I502f36cc90a48f86bb90caef1fc38230713f0da3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/208128 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 0e6f315740..fd68744e15 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -201,6 +201,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_base \ helpcontent2/source/text/scalc/01/func_bahttext \ + helpcontent2/source/text/scalc/01/func_bycol \ + helpcontent2/source/text/scalc/01/func_byrow \ helpcontent2/source/text/scalc/01/func_char \ helpcontent2/source/text/scalc/01/func_clean \ helpcontent2/source/text/scalc/01/func_ceiling \ diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp index 3d2dac96f9..c4dd53959f 100644 --- a/source/text/scalc/01/common_func.xhp +++ b/source/text/scalc/01/common_func.xhp @@ -40,7 +40,7 @@ <note id="par_id431716730587722">Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.</note> </section> <section id="array"> - <note id="par_id131711543270539">Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>. Hint: enter formula using keys <keycode>Ctrl + Shift + Enter</keycode>.</note> + <note id="par_id131711543270539">Enter the formula as an <link href="text/scalc/01/04060107.xhp">array formula</link>. <emph>Hint</emph>: enter formula using keys <keycode>Ctrl + Shift + Enter</keycode>.</note> </section> <section id="NAinTable"> <paragraph role="paragraph" id="par_id221739098585036"><variable id="NA_in_table">#N/A</variable></paragraph> diff --git a/source/text/scalc/01/func_bycol.xhp b/source/text/scalc/01/func_bycol.xhp new file mode 100644 index 0000000000..7ee4c93c65 --- /dev/null +++ b/source/text/scalc/01/func_bycol.xhp @@ -0,0 +1,58 @@ +<?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_bycol.xhp" indexer="include" status="PUBLISH"> + <title id="tit">BYCOL</title> + <filename>/text/scalc/01/func_bycol.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id391784054735617" branch="hid/SC_HID_FUNC_BYCOL_MS" localize="false"/> +<bookmark branch="index" id="bm_id311784055127216"> +<bookmark_value>BYCOL function</bookmark_value> +</bookmark> +<section id="bycol"> + <h1 id="hd_id11784054735617"><variable id="h1"><link href="text/scalc/01/func_bycol.xhp">BYCOL</link></variable></h1> + <description id="par_id851784054735617">Applies a lambda function to each column of an array. Returns a single-row array of the same number of columns of the source array.</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">=BYCOL(Array; Lambda)</paragraph> +<paragraph role="paragraph" id="par_id991784055564756"><emph>Array</emph>: the source array.</paragraph> +<paragraph role="paragraph" id="par_id691784055569440"><emph>Lambda</emph>: A function (<link href="text/scalc/01/func_lambda.xhp">LAMBDA</link> or other) that will be called on each column of the array.</paragraph> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph role="paragraph" id="par_id311784057872073">The formula <input>=BYCOL(A2:C13;LAMBDA(class;AVERAGE(class)))</input> return the array</paragraph> +<table id="tab_id701784056231221"> + <tablerow> + <tablecell> + <paragraph id="par_id771784056231221" role="tablecontent">41.9090909090909</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id791784056231221" role="tablecontent">59.7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id901784056231221" role="tablecontent">44.7</paragraph> + </tablecell> + </tablerow> +</table> +<paragraph role="paragraph" id="par_id961784057866804">The same results can be obtained using the formula <input>=BYCOL(A2:C13;AGERAGE)</input>. </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.BYCOL</literal></paragraph> +<section id="relatedtopics"> +<paragraph role="paragraph" id="par_id231784061670388" localize="false"><embedvar href="text/scalc/01/func_byrow.xhp#h1" markup="ignore"/></paragraph> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/01/func_byrow.xhp b/source/text/scalc/01/func_byrow.xhp new file mode 100644 index 0000000000..78a6f40059 --- /dev/null +++ b/source/text/scalc/01/func_byrow.xhp @@ -0,0 +1,59 @@ +<?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_byrow.xhp" indexer="include" status="PUBLISH"> + <title id="tit">BYROW</title> + <filename>/text/scalc/01/func_byrow.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id391784054735617" branch="hid/SC_HID_FUNC_BYROW_MS" localize="false"/> +<bookmark branch="index" id="bm_id311784055127216"> +<bookmark_value>BYROW function</bookmark_value> +</bookmark> +<section id="byrow"> + <h1 id="hd_id11784054735617"><variable id="h1"><link href="text/scalc/01/func_byrow.xhp">BYROW</link></variable></h1> + <description id="par_id851784054735617">Applies a lambda function to each row of an array. Returns a single-column array of the same number of rows of the source array.</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">=BYROW(Array; Lambda)</paragraph> +<paragraph role="paragraph" id="par_id991784055564756"><emph>Array</emph>: the source array.</paragraph> +<paragraph role="paragraph" id="par_id691784055569440"><emph>Lambda</emph>: A function (<link href="text/scalc/01/func_lambda.xhp">LAMBDA</link> or other) that will be called on each row of the array.</paragraph> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph role="paragraph" id="par_id311784057872073">The formula <input>=BYROW(A2:C13;LAMBDA(student;MAX(student)))</input> return the array</paragraph> +<table id="tab_id701784056231221"> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id881784061481889">67</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id911784061487134">68</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id31784061490240">65</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id921784061494039">64</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id921784061497421">43</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id631784061500623">84</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id201784061503835">80</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id501784061506419">49</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id911784061509429">57</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id601784061513265">60</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id661784061516540">57</paragraph></tablecell></tablerow> + <tablerow><tablecell><paragraph role="tablecontent" localize="false" id="par_id931784061519626">26</paragraph></tablecell></tablerow> +</table> +<paragraph role="paragraph" id="par_id961784057866804">The same results can be obtained using the formula <input>=BYROW(A2:C13;MAX)</input>. </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.BYROW</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> +</section> +</body> +</helpdocument>
