AllLangHelp_scalc.mk | 2 source/text/scalc/00/avail_release.xhp | 11 +++ source/text/scalc/01/common_func.xhp | 6 +- source/text/scalc/01/func_isomitted.xhp | 43 +++++++++++++++ source/text/scalc/01/func_lambda.xhp | 90 ++++++++++++++++++++++++++++++++ 5 files changed, 148 insertions(+), 4 deletions(-)
New commits: commit ecbaee5d117b214b0f6c99b84765dbc6c50ba79b Author: Olivier Hallot <[email protected]> AuthorDate: Fri Jul 10 18:36:29 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Jul 12 23:47:37 2026 +0200 tdf#138749 Add Help page for LAMBDA function Change-Id: I565daa2d98e6ea23ee6b8474664504bc08af19f8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/207969 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 571293f692..0e6f315740 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -262,6 +262,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_isomitted \ helpcontent2/source/text/scalc/01/func_isoweeknum \ helpcontent2/source/text/scalc/01/func_jis \ + helpcontent2/source/text/scalc/01/func_lambda \ helpcontent2/source/text/scalc/01/func_leftb \ helpcontent2/source/text/scalc/01/func_lenb \ helpcontent2/source/text/scalc/01/func_lookup \ diff --git a/source/text/scalc/01/func_isomitted.xhp b/source/text/scalc/01/func_isomitted.xhp index 3b8d4d57ac..d66c4f8b26 100644 --- a/source/text/scalc/01/func_isomitted.xhp +++ b/source/text/scalc/01/func_isomitted.xhp @@ -22,7 +22,7 @@ </bookmark> <section id="isomitted"> - <h1 id="hd_id241783686031327"><variable id="h1"><link href="text/scalc/01/func_isomitted.xhp">ISOMITTED Function</link></variable></h1> + <h1 id="hd_id241783686031327"><variable id="h1"><link href="text/scalc/01/func_isomitted.xhp">ISOMITTED</link></variable></h1> <description id="par_id281783686031328">Returns whether a LAMBDA parameter was provided (FALSE) or omitted (TRUE). Only valid within a LAMBDA expression.</description> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> @@ -34,7 +34,9 @@ <embed href="text/scalc/01/common_func.xhp#notODFF"/> <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.ISOMITTED</literal></paragraph> <section id="relatedtopics"> -<tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOMITTED";>ISOMITTED wiki page</link>.</tip> + <paragraph role="paragraph" id="par_id31783713113751" localize="false"><embedvar href="text/scalc/01/func_lambda.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id821783713192310" localize="false"><embedvar href="text/scalc/01/func_let.xhp#h1" markup="ignore"/></paragraph> + <tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOMITTED";>ISOMITTED wiki page</link>.</tip> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_lambda.xhp b/source/text/scalc/01/func_lambda.xhp new file mode 100644 index 0000000000..28ae5d255f --- /dev/null +++ b/source/text/scalc/01/func_lambda.xhp @@ -0,0 +1,90 @@ +<?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_lambda.xhp" indexer="include" status="PUBLISH"> + <title id="tit">LAMBDA</title> + <filename>/text/scalc/01/func_lambda.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id851783693005888" branch="hid/SC_HID_FUNC_LAMBDA_MS" localize="false"/> +<section id="lambda"> + <h1 id="hd_id371783693005888"><variable id="h1"><link href="text/scalc/01/func_lambda.xhp">LAMBDA</link></variable></h1> + <description id="par_id921783693005888">The LAMBDA function creates custom functions, enabling you to write reusable formulas with different inputs. It also supports advanced features like recursion and higher-order functions.</description> +</section> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> +<paragraph role="code" id="par_id111783708469030">=LAMBDA(Parameter 1 [; Parameter 2 [; ... [; Parameter n]...]]; Formula)</paragraph> +<paragraph role="paragraph" id="par_id111783708627795"><emph>Parameter 1</emph>: (required) The name of the first parameter to the function. The name must follow the <link href="text/scalc/guide/value_with_name.xhp">range naming rules</link> and cannot be the output of a reference or text formula. The scope of the parameter name is restricted to the LAMBDA function.</paragraph> +<paragraph role="paragraph" id="par_id751783708895171"><emph>Parameter 2, ..., n </emph>: (optional). Additional parameters for the function. The same naming rules for <emph>Parameter 1</emph> applies.</paragraph> +<paragraph role="paragraph" id="par_id701783709031402"><emph>Formula</emph>: a formula expression. It must be the last argument of the function.</paragraph> +<note id="par_id331783710050170">By default, the LAMBDA function displays the Greek character lambda (λ) in the cell.</note> +<h2 id="hd_id831783710257485">Usage</h2> +<list type="ordered"> + <listitem> + <paragraph id="par_id321783710660632" role="listitem">For better readability, it is recommended (though optional) to assign a name to the cell containing the LAMBDA function.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id881783710653711" role="listitem">Create the LAMBDA function expression in the named cell above (by default, the cell will display the character <emph>λ</emph>).</paragraph> + </listitem> + <listitem> + <paragraph id="par_id831783710666038" role="listitem">Use the named cell, passing the parameters for the LAMBDA function.</paragraph> + </listitem> +</list> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<h4 id="hd_id821783715660204">Example of a simple geometric mean</h4> +<list type="ordered"> + <listitem> + <paragraph id="par_id301783712620663" role="listitem">Assign name MY_MEAN to cell A1.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id971783712627758" role="listitem">Enter <input>=LAMBDA(Number1;Number2;SQRT(Number1*Number2))</input> in cell A1.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id741783712635060" role="listitem">In cell B1, enter <input>=MY_MEAN(2;3)</input>.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id191783712640914" role="listitem">Cell B1 displays the number 2.44948974278318, the square root of 2 times 3.</paragraph> + </listitem> +</list> +<note id="par_id981783715329179">If you don’t assign a name to the cell containing the LAMBDA function, you can still use it by entering the formula <input>=A1(2;3)</input> in B1. However, this makes the formula less readable.</note> +<h4 id="hd_id281783715637980">Example of a recursive call of a LAMBDA function</h4> +<list type="ordered"> + <listitem> + <paragraph id="par_id951783714102933" role="listitem">Assign name MY_FACTORIAL to cell A1</paragraph> + </listitem> + <listitem> + <paragraph id="par_id261783714109684" role="listitem">Enter <input>=LAMBDA(n,IF(n>1,n*MY_FACTORIAL(n-1),1))</input> in cell A1</paragraph> + </listitem> + <listitem> + <paragraph id="par_id921783714125947" role="listitem">Enter <input>=MY_FACTORIAL(5)</input> in cell B1</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1001783714134212" role="listitem">Cell B1 will show 120.</paragraph> + </listitem> +</list> +<h4 id="hd_id331783717131876">Using ISOMITTED in function LAMBDA</h4> +<paragraph role="paragraph" id="par_id911783717111321">The ISOMITTED function allows you to handle missing parameters in a LAMBDA function. For example, the LAMBDA function in cell A1:</paragraph> + +<paragraph role="paragraph" id="par_id501783717973525"><input>=LAMBDA(_n1, _n2, IF(ISOMITTED(_n2), "Missing second parameter", _n1/_n2))</input></paragraph> + +<paragraph role="paragraph" id="par_id91783717979957">returns "Missing second parameter" if the LAMBDA function is called as <input>=A1(3;)</input>. <emph>Note</emph>: The trailing argument separator (;) must be included in the function call.</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.LAMBDA</literal></paragraph> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id31783713113751" localize="false"><embedvar href="text/scalc/01/func_isomitted.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id821783713192310" localize="false"><embedvar href="text/scalc/01/func_let.xhp#h1" markup="ignore"/></paragraph> +<tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/LAMBDA";>LAMBDA wiki page</link>.</tip> +</section> +</body> +</helpdocument> commit 1be37dbcf4d4440967a504353cd655993cadb1dc Author: Olivier Hallot <[email protected]> AuthorDate: Fri Jul 10 11:14:11 2026 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Jul 12 23:47:27 2026 +0200 tdf#172751 Help page for ISOMITTED() function Change-Id: I462c3225353962bc1999090b89971c75b6d699df Reviewed-on: https://gerrit.libreoffice.org/c/help/+/207968 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index ff06d3d6ec..571293f692 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -259,6 +259,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_imsin \ helpcontent2/source/text/scalc/01/func_imsinh \ helpcontent2/source/text/scalc/01/func_imtan \ + helpcontent2/source/text/scalc/01/func_isomitted \ helpcontent2/source/text/scalc/01/func_isoweeknum \ helpcontent2/source/text/scalc/01/func_jis \ helpcontent2/source/text/scalc/01/func_leftb \ diff --git a/source/text/scalc/00/avail_release.xhp b/source/text/scalc/00/avail_release.xhp index a764e90b20..4125b79048 100644 --- a/source/text/scalc/00/avail_release.xhp +++ b/source/text/scalc/00/avail_release.xhp @@ -105,7 +105,16 @@ <tip id="par_id491708380768121">This function is available since %PRODUCTNAME 25.2.</tip> </section> <section id="25.8"> - <tip id="par_id491738280768121">This function is available since %PRODUCTNAME 25.8.</tip> + <tip id="par_id141783688730743">This function is available since %PRODUCTNAME 25.8.</tip> + </section> + <section id="26.2"> + <tip id="par_id621783688734066">This function is available since %PRODUCTNAME 26.2.</tip> + </section> + <section id="26.8"> + <tip id="par_id171783688736954">This function is available since %PRODUCTNAME 26.8.</tip> + </section> + <section id="27.2"> + <tip id="par_id121783689114299">This function is available since %PRODUCTNAME 27.2.</tip> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp index 08bcfd9139..3d2dac96f9 100644 --- a/source/text/scalc/01/common_func.xhp +++ b/source/text/scalc/01/common_func.xhp @@ -9,8 +9,8 @@ * --> <meta> - <topic id="commonfunctionsyntaxexample" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Common Syntax and example</title> + <topic id="commonfunctionsyntaxexample" indexer="exclude" status="PUBLISH"> + <title id="tit">Common Syntax and example</title> <filename>/text/scalc/01/common_func.xhp</filename> </topic> </meta> @@ -31,7 +31,7 @@ <h3 id="hd_id371655560095924">See also</h3> </section> <section id="notODFF"> - <paragraph role="paragraph" id="par_id251640873774457">This function is <emph>NOT</emph> part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard. The name space is</paragraph> + <paragraph role="paragraph" id="par_id251640873774457">This function is <emph>NOT</emph> part of the <emph>Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format</emph> standard. The name space is</paragraph> </section> <section id="datenumbersequencenote"> <note id="par_id301616845402409">This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href="text/scalc/01/03080000.xhp">value highlighting</link> feature.</note> diff --git a/source/text/scalc/01/func_isomitted.xhp b/source/text/scalc/01/func_isomitted.xhp new file mode 100644 index 0000000000..3b8d4d57ac --- /dev/null +++ b/source/text/scalc/01/func_isomitted.xhp @@ -0,0 +1,41 @@ +<?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_isomitted.xhp" indexer="include" status="PUBLISH"> + <title id="tit">ISOMITTED</title> + <filename>/text/scalc/01/func_isomitted.xhp</filename> + </topic> +</meta> +<body> +<bookmark id="bm_id91783686031327" branch="hid/SC_HID_FUNC_IS_OMITTED_MS" localize="false"/> +<bookmark branch="index" id="bm_id1001783687799995"> +<bookmark_value>ISOMITTED function</bookmark_value> +</bookmark> + +<section id="isomitted"> + <h1 id="hd_id241783686031327"><variable id="h1"><link href="text/scalc/01/func_isomitted.xhp">ISOMITTED Function</link></variable></h1> + <description id="par_id281783686031328">Returns whether a LAMBDA parameter was provided (FALSE) or omitted (TRUE). Only valid within a LAMBDA expression.</description> +</section> +<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> +<paragraph role="code" id="par_id801783687174304">=ISOMITTED(Name)</paragraph> +<paragraph role="paragraph" id="par_id721783687428293"><emph>Name</emph>: The name of the parameter to check.</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.ISOMITTED</literal></paragraph> +<section id="relatedtopics"> +<tip id="par_id701677016751508"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOMITTED";>ISOMITTED wiki page</link>.</tip> +</section> +</body> +</helpdocument> +
